Last modified: 2010-05-15 15:29:16 UTC
here is the response from installation page. Checking environment... * PHP 4.3.3: ok * PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title) * Have XML / Latin1-UTF-8 conversion support. * PHP's memory_limit is 50M. If this is too low, installation may fail! * Have zlib support; enabling output compression. * Found GD graphics library built-in, image thumbnailing will be enabled if you enable uploads. * Installation directory: /var/www/html/wiki * Script URI path: /wiki * Connected as root (automatic) * Connected to database... 3.23.58 * Database wikidb exists * Creating tables...Query "CREATE TABLE user ( user_id int(5) unsigned NOT NULL auto_increment, user_name varchar(255) binary NOT NULL default \'\', user_real_name varchar(255) binary NOT NULL default \'\', user_rights tinyblob NOT NULL default \'\', user_password tinyblob NOT NULL default \'\', user_newpassword tinyblob NOT NULL default \'\', user_email tinytext NOT NULL default \'\', user_options blob NOT NULL default \'\', user_touched char(14) binary NOT NULL default \'\', UNIQUE KEY user_id (user_id) ) PACK_KEYS=1" failed with error code "You have an error in your SQL syntax near '\'\', user_real_name varchar(255) binary NOT NULL default \'\', user_rights tiny' at line 1".
Check your PHP configuration; do you have the 'magic_quotes_runtime' option on? (see http://www.php.net/manual/en/ref.info.php#ini.magic-quotes-runtime ) If you do, try turning it off -- it's likely to cause no end of trouble. If that's not it, I'm not sure what else could be causing this...
Reopening this for now; we should add a check for this setting and abort the installation with a message explaining the problem.
Check for magic_quotes_runtime and magic_quotes_sybase now checked into the installer for REL1_4 and HEAD.