Page MenuHomePhabricator

Can't install CheckUser extension with SQLite
Closed, ResolvedPublic

Description

The SQL queries to update database at install doesn't cope well with the AUTOINCREMENT field syntax on SQLite.

It uses:
cuc_id INTEGER NOT NULL AUTO_INCREMENT,

Database engine class will translate it to:
cuc_id INTEGER NOT NULL AUTOINCREMENT,

What SQLite expects is:
cuc_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,

So we have this error:
Error: 1 near "AUTOINCREMENT": syntax error

See https://www.mediawiki.org/wiki/Manual:Database_access#SQLite_compatibility


Version: unspecified
Severity: major

Details

Reference
bz37590

Event Timeline

bzimport raised the priority of this task from to Normal.
bzimport set Reference to bz37590.

[ Adding tracking bug. ]

brandonskypimenta wrote:

I have the same problem.

Gerrit change 39159

Merged by Aaron on January the 10th.

MarcoAurelio moved this task from Backlog to Closed on the CheckUser board.May 9 2016, 8:58 AM
Restricted Application added a subscriber: JEumerus. · View Herald TranscriptMay 9 2016, 8:58 AM