Last modified: 2010-05-15 15:34:00 UTC
At least two problems: first, it's trying to do a multi-row INSERT statement MySQL-style. Second, it's using the raw timestamps which won't work in PG. Related, it's in some modes setting the inverse timestamp with a numerical subtraction that fails on a PG timestamp. [selected '1' in rebuildMessages.php; long SQL INSERT statement snipped] Function: initialiseMessages Error: 1 ERROR: syntax error at or near "," at character 344 Backtrace: DatabasePostgreSQL.php line 370 calls wfDebugDieBacktrace() Database.php line 297 calls DatabasePostgreSQL::reportQueryError() InitialiseMessages.inc line 145 calls DatabasePostgreSQL::query() rebuildMessages.php line 54 calls initialiseMessages() -or- Please enter a number: 2 Initialising "MediaWiki" namespace... Warning: pg_query(): Query failed: ERROR: operator does not exist: bigint - timestamp without time zone HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts. in /var/www/html/gres/includes/DatabasePostgreSQL.php on line 96 A database error has occurred Query: INSERT INTO "old" (old_namespace,old_title,old_text,old_comment,old_user,old_user_text,old_timestamp,inverse_timestamp) SELECT cur_namespace,cur_title,cur_text,cur_comment,cur_user,cur_user_text,cur_timestamp,99999999999999-cur_timestamp FROM cur WHERE cur_namespace='8' AND cur_title='Mainpage' Function: Article::quickEdit Error: 1 ERROR: operator does not exist: bigint - timestamp without time zone HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts. Backtrace: DatabasePostgreSQL.php line 370 calls wfDebugDieBacktrace() Database.php line 297 calls DatabasePostgreSQL::reportQueryError() Database.php line 1034 calls DatabasePostgreSQL::query() Article.php line 1999 calls DatabasePostgreSQL::insertSelect() InitialiseMessages.inc line 120 calls Article::quickEdit() rebuildMessages.php line 57 calls initialiseMessages()
fixed in InitialiseMessages:1.27