Last modified: 2011-11-30 16:16:47 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()
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.
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.
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
Fixed in REL1_5 and HEAD, will issue 1.5.1 later today which will include this fix.
Had MediaWiki installed yesterday - exactly same problem. Win XP/Mysql5/php5
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.
