Page MenuHomePhabricator

update.php fails on a new install with 'wikidatawiki.wb_terms doesn't exist'
Closed, ResolvedPublic

Description

Did a fresh install from master on my laptop, set up the various wikibase config values to match what we have in production except with an empty clientdb list, imported some pages and properties, and then realized I oughta run update.php. However...

update.php tries to retrieve something from wb_terms before it is created; a workaround for me was to comment out in extensions/Wikibase/repo/includes/store/sql/SqlStore.php the line

$this->rebuild();

at line 130 and then update.php ran to completion. Page views looked ok too.


output from update.php:

MediaWiki 1.22alpha Updater

Going to run database updates for wikidatawiki
Depending on the size of your database this may take a while!
Abort with control-c in the next five seconds (skip this countdown with --quick)
... 0
...wb_items_per_site doesn't exist.
...wb_items doesn't exist.
...wb_aliases doesn't exist.
...wb_texts_per_lang doesn't exist.

A database query syntax error has occurred.
The last attempted database query was:
"SELECT term_language,term_type,term_text FROM wb_terms WHERE term_entity_i
d = '15' AND term_entity_type = 'item' "
from within function "Wikibase\TermSqlIndex::getTermsOfEntity".
Database returned error "1146: Table 'wikidatawiki.wb_terms' doesn't exist (loca
lhost)"


Version: master
Severity: normal

Details

Reference
bz48771

Event Timeline

bzimport raised the priority of this task from to Low.Nov 22 2014, 1:27 AM
bzimport set Reference to bz48771.
bzimport added a subscriber: Unknown Object (MLST).

Should be fixed by now... Please reopen if not.