Last modified: 2014-07-16 11:42:22 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T44689, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 42689 - AddRowIDs.sql fails on sqlite
AddRowIDs.sql fails on sqlite
Status: VERIFIED FIXED
Product: MediaWiki extensions
Classification: Unclassified
WikidataRepo (Other open bugs)
unspecified
All All
: Low normal (vote)
: ---
Assigned To: Wikidata bugs
:
Depends on:
Blocks: sqlite
  Show dependency treegraph
 
Reported: 2012-12-04 15:39 UTC by Daniel Kinzler
Modified: 2014-07-16 11:42 UTC (History)
5 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Daniel Kinzler 2012-12-04 15:39:07 UTC
AddRowIDs.sql currently uses MySQL specific syntax. But it's unclear how to add a primary key column in sqlite at all.

----------------
Adding term_row_id field to table wb_terms ...A database query syntax error has occurred.
The last attempted database query was:
"ALTER TABLE wb_items_per_site
 ADD ips_row_id
 INTEGER PRIMARY KEY AUTOINCREMENT
"
from within function "DatabaseBase::sourceFile( /DATA/var/www/daniel/wikidata/extensions/Wikibase/repo/includes/store/sql/AddRowIDs.sql )".
Database returned error "1: Cannot add a PRIMARY KEY column"
Comment 1 Lydia Pintscher 2013-10-08 22:36:04 UTC
Still relevant?
Comment 2 Daniel Kinzler 2013-10-29 11:24:26 UTC
This is fixed i think. And I don't think there will be many legacy installs out there that still use the old schema anyway. Closing.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links