Last modified: 2010-05-15 15:42:48 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T9555, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 7555 - Problem with installation of new MediaWiki
Problem with installation of new MediaWiki
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
1.8.x
PC Windows XP
: Normal critical (vote)
: ---
Assigned To: Nobody - You can work on this!
:
: 7552 (view as bug list)
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-10-12 20:56 UTC by Cezary Wagner
Modified: 2010-05-15 15:42 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Cezary Wagner 2006-10-12 20:56:27 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)".
Comment 1 Cezary Wagner 2006-10-12 21:01:14 UTC
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
Comment 2 Brion Vibber 2006-10-12 22:19:50 UTC
*** Bug 7552 has been marked as a duplicate of this bug. ***
Comment 3 Andreas Kolf 2006-10-13 09:57:56 UTC
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.
Comment 4 Cezary Wagner 2006-10-15 11:06:28 UTC
That problem is related to mysql 5.0.26 (but not exist in MySql 5.0.24).
Comment 5 Andreas Kolf 2006-10-16 07:14:31 UTC
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 ;-)

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links