https://bugzilla.wikimedia.org/show_bug.cgi?id=37590
Web browser: ---
Bug #: 37590
Summary: Can't install CheckUser extension with SQLite
Product: MediaWiki extensions
Version: unspecified
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: CheckUser
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected], [email protected]
Classification: Unclassified
Mobile Platform: ---
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
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
