Page MenuHomePhabricator

SQLITE Error: 1 near "DROP": syntax error in entity_usage-drop-touched.sql in update.php
Closed, ResolvedPublic

Description

Function: Database::sourceFile( C:\git\gerrit\mediawiki\extensions\Wikibase\client\includes\Usage\Sql/../../../sql/entity_usage-drop-touched.sql )
Error: 1 near "DROP": syntax error

Backtrace:
#0 C:\git\gerrit\mediawiki\includes\libs\rdbms\database\Database.php(858): Database->reportQueryError(string, integer, string, string, boolean)
#1 C:\git\gerrit\mediawiki\includes\libs\rdbms\database\Database.php(3199): Database->query(string, string)
#2 C:\git\gerrit\mediawiki\includes\libs\rdbms\database\Database.php(3139): Database->sourceStream(unknown type, boolean, boolean, string, boolean)
#3 C:\git\gerrit\mediawiki\includes\installer\DatabaseUpdater.php(667): Database->sourceFile(string)
#4 C:\git\gerrit\mediawiki\includes\installer\DatabaseUpdater.php(781): DatabaseUpdater->applyPatch(string, boolean, string)
#5 C:\git\gerrit\mediawiki\includes\installer\DatabaseUpdater.php(453): DatabaseUpdater->dropField(string, string, string, boolean)
#6 C:\git\gerrit\mediawiki\includes\installer\DatabaseUpdater.php(420): DatabaseUpdater->runUpdates(array, boolean)
#7 C:\git\gerrit\mediawiki\maintenance\update.php(171): DatabaseUpdater->doUpdates(array)
#8 C:\git\gerrit\mediawiki\maintenance\doMaintenance.php(110): UpdateMediaWiki->execute()
#9 C:\git\gerrit\mediawiki\maintenance\update.php(216): require_once(string)
#10 {main}

Related to T110446 and https://gerrit.wikimedia.org/r/#/c/308912/

Details

Related Gerrit Patches:
mediawiki/extensions/Wikibase : masterSpecial handling for dropping eu_touched on SQLite

Event Timeline

Addshore created this task.Oct 4 2016, 11:28 AM
Restricted Application added a project: Collaboration-Team-Triage. · View Herald TranscriptOct 4 2016, 11:28 AM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
Addshore triaged this task as High priority.Oct 4 2016, 12:23 PM
Addshore added a project: Regression.
hoo added a comment.Oct 4 2016, 1:04 PM

We could just not apply that update on SQLite… not nice, but also not harmful AFAICT.

@Addshore: Which project/codebase is this about? MediaWiki-extensions-WikibaseClient ?

Restricted Application added a project: Wikidata. · View Herald TranscriptOct 4 2016, 3:09 PM

Change 314169 had a related patch set uploaded (by Paladox):
Fix support for sqlite

https://gerrit.wikimedia.org/r/314169

@Aklapper yeh, wikibase client.

Change 314169 merged by jenkins-bot:
Special handling for dropping eu_touched on SQLite

https://gerrit.wikimedia.org/r/314169

hoo closed this task as Resolved.Oct 5 2016, 8:49 AM
hoo claimed this task.
hoo removed a project: Patch-For-Review.