Page MenuHomePhabricator

Error on installation
Closed, ResolvedPublic

Description

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

Version: unspecified
Severity: normal
Whiteboard: u=dev c=backend p=0

Details

Reference
bz63482

Event Timeline

bzimport raised the priority of this task from to Unbreak Now!.Nov 22 2014, 3:10 AM
bzimport set Reference to bz63482.
bzimport added a subscriber: Unknown Object (MLST).

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