Last modified: 2011-11-30 16:16:47 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 T5735, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 3735 - Error on creating Default Database (MySQL 5.0 strict mode)
Error on creating Default Database (MySQL 5.0 strict mode)
Status: RESOLVED WORKSFORME
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.5.x
All All
: High critical with 1 vote (vote)
: ---
Assigned To: Brion Vibber
http://mrnet.dnsalias.org/wiki/
:
Depends on:
Blocks: 3738
  Show dependency treegraph
 
Reported: 2005-10-18 14:56 UTC by Miguel Ángel Rodríguez
Modified: 2011-11-30 16:16 UTC (History)
0 users

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


Attachments

Description Miguel Ángel Rodríguez 2005-10-18 14:56:16 UTC
MediaWiki version: 1.5.0 final.
Apache version: 2.0.54 (Win 32).


Checking environment...
PHP 5.0.5: ok 
PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title) 
Have XML / Latin1-UTF-8 conversion support. 
PHP is configured with no memory_limit. 
Have zlib support; enabling output compression. 
Neither Turck MMCache nor eAccelerator are installed, can't use object caching 
functions 
GNU diff3 not found.
Couldn't find GD library or ImageMagick; image thumbnailing disabled. 
Installation directory: C:\Servidores\http\htdocs\wiki 
Script URI path: /wiki 
Warning: $wgSecretKey key is insecure, generated with mt_rand(). Consider changing it 
manually. 
Trying to connect to MySQL on localhost as root... 
Connected as root (automatic)
Connected to 5.0.13-rc-nt; enabling MySQL 4 enhancements
Warning: $wgSecretKey key is insecure, generated with mt_rand(). Consider changing it 
manually. 
Created database wikidb 
Creating tables... done. 
Initializing data...
Granting user permissions... 
Created sysop account MrNet. 
Initialising "MediaWiki" namespace...
A database error has occurred
Query: INSERT  INTO `IngSWProyectospage` 
(page_id,page_namespace,page_title,page_counter,page_restrictions,page_is_redirect,pag
e_is_new,page_random,page_touched,page_latest) VALUES 
(NULL,'8','1movedto2','0','sysop','0','1','0.627684395841','20051018140116','0')
Function: Article::insertOn
Error: 1364 Field 'page_len' doesn't have a default value (localhost)

Backtrace:
GlobalFunctions.php line 451 calls wfBacktrace()
Database.php line 400 calls wfDebugDieBacktrace()
Database.php line 350 calls Database::reportQueryError()
Database.php line 940 calls Database::query()
Article.php line 943 calls Database::insert()
InitialiseMessages.inc line 189 calls Article::insertOn()
InitialiseMessages.inc line 72 calls initialiseMessagesReal()
index.php line 649 calls initialiseMessages()
Comment 1 Martin Zillner 2005-10-25 13:08:47 UTC
I have just seen the same message with MySQL 5.0.15-nt: I edited
'maintenance/tables.sql' as follows:

[...]
CREATE TABLE /*$wgDBprefix*/page (
[...]
page_len int(8) unsigned NOT NULL default 0,
                                 ^^^^^^^^^^

But now I get the following:

Initialising "MediaWiki" namespace...
A database error has occurred
Query: UPDATE  `page` SET page_latest = '2',page_touched =
'20051025125015',page_is_new = '0',page_is_redirect = '',page_len = '27' WHERE
page_id = '2'
Function: Article::updateToRevision
Error: 1366 Incorrect integer value: '' for column 'page_is_redirect' at row 1
(localhost)

It seems that the method 'Article::isRedirect' in 'includes/Article.php' returns
a wrong value.
Comment 2 Brion Vibber 2005-10-25 21:27:01 UTC
Please provide your my.cnf or my.ini file and details of the configuration. I have 
encountered no such issues with MySQL 5.0 to date.
Comment 3 Brion Vibber 2005-10-25 23:01:59 UTC
Seems to be problems with the non-default "strict mode" enabled on the MySQL server. To 
reproduce for testing, restart server with --sql-mode="STRICT_ALL_TABLES".

Reference: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
Comment 4 Brion Vibber 2005-10-25 23:26:53 UTC
Fixed in REL1_5 and HEAD, will issue 1.5.1 later today which will include this fix.
Comment 5 Ivan Demkovitch 2005-10-28 15:31:43 UTC
Had MediaWiki installed yesterday - exactly same problem.
Win XP/Mysql5/php5
Comment 6 Brion Vibber 2005-10-28 22:51:09 UTC
What does "Had MediaWiki installed yesterday" mean? Did you install 1.5.1 which includes 
the fix, or just the old one again?

Please provide your my.cnf or my.ini file and details of your configuration.

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


Navigation
Links