Last modified: 2014-04-15 13:53:02 UTC
I am getting the followng error on fresh installation of Wikibase Query. Error comming from Repo (which was not installed before). Modifying term_row_id field of table wb_terms ...A database query error has occurred. Query: ALTER TABLE /*:*/wb_terms MODIFY term_row_id BIGINT unsigned NOT NULL auto_increment Function: DatabaseBase::sourceFile( /home/j/www/phase3/extensions/WikibaseQuery/extensions/Wikibase/repo/includes/store/sql/../../../sql/MakeRowIDsBig.sql ) Error: 1146 Table 'mw_dev.wb_terms' doesn't exist (localhost) PHP Notice: Uncommitted DB writes (transaction from DatabaseUpdater::doUpdates). in /home/j/www/phase3/includes/db/Database.php on line 4131 PHP Stack trace: PHP 1. {main}() /home/j/www/phase3/maintenance/update.php:0 PHP 2. require_once() /home/j/www/phase3/maintenance/update.php:194 PHP 3. DatabaseBase->__destruct() /home/j/www/phase3/includes/db/Database.php:0 PHP 4. trigger_error() /home/j/www/phase3/includes/db/Database.php:4131 Notice: Uncommitted DB writes (transaction from DatabaseUpdater::doUpdates). in /home/j/www/phase3/includes/db/Database.php on line 4131 Call Stack: 0.0003 277624 1. {main}() /home/j/www/phase3/maintenance/update.php:0 0.0014 584608 2. require_once('/home/j/www/phase3/maintenance/doMaintenance.php') /home/j/www/phase3/maintenance/update.php:194 1.7189 19505664 3. DatabaseBase->__destruct() /home/j/www/phase3/includes/db/Database.php:0 1.7189 19505848 4. trigger_error() /home/j/www/phase3/includes/db/Database.php:4131
Did you run update.php after installing wikibase (without) query, or did you try to run update.php for wikibase + wikibasequery at once?
Hm, looks like MakeRowIDsBig.sql has /*:*/ instead of /*_*/, which causes an error if you are using table prefixes. Will fix.
Change 123637 had a related patch set uploaded by Daniel Kinzler: (bug 63482) Fix table prefix in MakeRowIDsBig.sql https://gerrit.wikimedia.org/r/123637
Change 123637 merged by Jeroen De Dauw: (bug 63482) Fix table prefix in MakeRowIDsBig.sql https://gerrit.wikimedia.org/r/123637
