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