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