Last modified: 2013-04-22 16:15:48 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T39590, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 37590 - Can't install CheckUser extension with SQLite
Can't install CheckUser extension with SQLite
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
CheckUser (Other open bugs)
unspecified
All All
: Normal major with 1 vote (vote)
: ---
Assigned To: Dereckson
: schema-change
Depends on:
Blocks: sqlite
  Show dependency treegraph
 
Reported: 2012-06-14 12:47 UTC by Dereckson
Modified: 2013-04-22 16:15 UTC (History)
5 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Dereckson 2012-06-14 12:47:51 UTC
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
Comment 1 Dereckson 2012-06-25 00:15:43 UTC
[ Adding tracking bug. ]
Comment 2 Brandon Sky 2012-07-22 00:33:01 UTC
I have the same problem.
Comment 3 Dereckson 2012-12-17 23:57:01 UTC
Gerrit change #39159
Comment 4 Alex Monk 2013-02-16 21:45:52 UTC
Merged by Aaron on January the 10th.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links