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: wikibugs-l@lists.wikimedia.org
ReportedBy: dereck...@espace-win.org
CC: aschulz4...@gmail.com, wikimedia.b...@snowolf.eu
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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
