Page MenuHomePhabricator

AddRowIDs.sql fails on sqlite
Closed, ResolvedPublic

Description

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"


Version: unspecified
Severity: normal

Details

Reference
bz42689

Event Timeline

bzimport raised the priority of this task from to Low.Nov 22 2014, 12:46 AM
bzimport set Reference to bz42689.
bzimport added a subscriber: Unknown Object (MLST).
daniel created this task.Dec 4 2012, 3:39 PM

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.

Restricted Application added a project: Wikidata. · View Herald TranscriptMay 19 2017, 8:21 AM