Hi all, I set up few wikis before but lately we've made mysql update and it seems something must have changed in its configuration, because i encounter problem during installation of wiki (doesn't matter which version i install:
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)".
Do you have any idea on that?
Regards Bartlomiej Skorupski
In the search archive of this newsgroup Maurice Joseph (http://thread.gmane.org/gmane.org.wikimedia.mediawiki/7955/focus=7955) pointed to this error on the FAQ: http://meta.wikimedia.org/wiki/Talk:Installing_MediaWiki_on_Windows_Server_2...
Are you running a windows server ? This could be an information for further follow ups.
Hope this helps.
François
mediawiki-l@lists.wikimedia.org