Last modified: 2011-12-01 14:55:24 UTC
hello, i want to install mediawiki on my pc. I have windows xp pro sp2 with IIS 5.1 and mysql 5.0.26community and during creating tables i have error message. i send you all informations: # PHP 5.2.0 installed # Found database drivers for: MySQL # PHP server API is isapi; using ugly URLs (index.php?title=Page_Title) # Have XML / Latin1-UTF-8 conversion support. # PHP is configured with no memory_limit. # Have zlib support; enabling output compression. # Couldn't find Turck MMCache, eAccelerator or APC. Object caching functions cannot be used. # GNU diff3 not found. # Couldn't find GD library or ImageMagick; image thumbnailing disabled. # Installation directory: C:\Inetpub\wwwroot\mediawiki # Script URI path: /mediawiki # Environment checked. You can install MediaWiki. # Warning: $wgSecretKey key is insecure, generated with mt_rand(). Consider changing it manually. Generating configuration file... # Database type: MySQL # Loading class: DatabaseMysql # Attempting to connect to database server as root...success. # Connected to 5.0.26-community-nt # Created database wikidb # Creating tables... using MySQL 4 table defs...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_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 '', user_token char(32) binary NOT NULL default '', user_email_authenticated char(14) binary, user_email_token char(32) binary, user_email_token_expires char(14) binary, user_registration char(14) binary, PRIMARY KEY user_id (user_id), UNIQUE INDEX user_name (user_name), INDEX (user_email_token) ) TYPE=InnoDB " failed with error code "BLOB/TEXT column 'user_password' can't have a default value (localhost)" i don t understood. i used mysql with utf8 by default. why this installation use MySQL 4 table defs ? can we use MySQL 5 tables defs ? thx
*** This bug has been marked as a duplicate of 7669 ***