Last modified: 2010-05-15 15:42:48 UTC
Instead of description just log of installation (problem also exist on reconfiguration of old wiki - see 2nd log): === 1st situation - new database === MediaWiki 1.8.1 Installation Don't forget security updates! Keep an eye on the low-traffic release announcements mailing list. Checking environment... Please include all of the lines below when reporting installation problems. PHP 5.1.6 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. Found GD graphics library built-in, image thumbnailing will be enabled if you enable uploads. Installation directory: C:\root\mediawiki\mediawiki-1.8.1 Script URI path: /mediawiki-test 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 Database wikidbtest exists 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)". === 2nd situation - update existing database === MediaWiki 1.8.1 Installation Don't forget security updates! Keep an eye on the low-traffic release announcements mailing list. Checking environment... Please include all of the lines below when reporting installation problems. PHP 5.1.6 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. Found GD graphics library built-in, image thumbnailing will be enabled if you enable uploads. Installation directory: C:\root\mediawiki\mediawiki-1.8.1 Script URI path: /mediawiki-test 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 Database wikidbtest exists There are already MediaWiki tables in this database. Checking if updates are needed... DB user account ok ...hitcounter table already exists. ...querycache table already exists. ...objectcache table already exists. ...categorylinks table already exists. ...logging table already exists. ...user_newtalk table already exists. ...transcache table already exists. ...trackbacks table already exists. ...externallinks table already exists. ...job table already exists. ...langlinks table already exists. ...querycache_info table already exists. ...filearchive table already exists. ...have ipb_id field in ipblocks table. ...have ipb_expiry field in ipblocks table. ...have rc_type field in recentchanges table. ...have rc_ip field in recentchanges table. ...have rc_id field in recentchanges table. ...have rc_patrolled field in recentchanges table. ...have user_real_name field in user table. ...have user_token field in user table. ...have user_email_token field in user table. ...have user_registration field in user table. ...have log_params field in logging table. ...have ar_rev_id field in archive table. ...have ar_text_id field in archive table. ...have page_len field in page table. ...have rev_deleted field in revision table. ...have img_width field in image table. ...have img_metadata field in image table. ...have img_media_type field in image table. ...have ss_total_pages field in site_stats table. ...have iw_trans field in interwiki table. ...have ipb_range_start field in ipblocks table. ...have ss_images field in site_stats table. Adding ipb_anon_only field to table ipblocks...Query "CREATE TABLE `ipblocks_newunique` ( ipb_id int(8) NOT NULL auto_increment, ipb_address tinyblob NOT NULL default '', ipb_user int(8) unsigned NOT NULL default '0', ipb_by int(8) unsigned NOT NULL default '0', ipb_reason tinyblob NOT NULL default '', ipb_timestamp char(14) binary NOT NULL default '', ipb_auto bool NOT NULL default 0, ipb_anon_only bool NOT NULL default 0, ipb_create_account bool NOT NULL default 1, ipb_expiry char(14) binary NOT NULL default '', ipb_range_start tinyblob NOT NULL default '', ipb_range_end tinyblob NOT NULL default '', PRIMARY KEY ipb_id (ipb_id), UNIQUE INDEX ipb_address_unique (ipb_address(255), ipb_user, ipb_auto), INDEX ipb_user (ipb_user), INDEX ipb_range (ipb_range_start(8), ipb_range_end(8)), INDEX ipb_timestamp (ipb_timestamp), INDEX ipb_expiry (ipb_expiry) ) TYPE=InnoDB " failed with error code "BLOB/TEXT column 'ipb_address' can't have a default value (localhost)".
php.ini is good (options are set as in included link and works with 1.7.1 -> http://mail.wikipedia.org/pipermail/wikitech-l/2005-March/028196.html
*** Bug 7552 has been marked as a duplicate of this bug. ***
i've a similar problem (was #7552) but in my php.ini magic_quotes_runtime and magic_quotes_sybase are set to off. changing password for admin-user and database-user does'nt work.
That problem is related to mysql 5.0.26 (but not exist in MySql 5.0.24).
geat information. many thanks to Cezary. after installing MySQL 5.0.24 everything starts up. Hope MySQL will server Version 5.0.24 for a long time ;-)