https://bugzilla.wikimedia.org/show_bug.cgi?id=46492
Web browser: ---
Bug ID: 46492
Summary: Sqlite updater does not add indexes properly
Product: MediaWiki
Version: 1.21-git
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Database
Assignee: wikibugs-l@lists.wikimedia.org
Reporter: bawolff...@gmail.com
Classification: Unclassified
Mobile Platform: ---
This came up on irc. u42p was attempting to convert his db from mysql ->
sqlite, but the conversion script didn't convert the indexes is right. Running
update.php got a lot of errors like:
A database query syntax error has occurred.
The last attempted database query was:
"INSERT OR IGNORE INTO user_tmp SELECT * FROM user
"
from within function "DatabaseBase::sourceFile(
/srv/http/w/maintenance/sqlite/archives/initial-indexes.sql )".
Database returned error "1: table user_tmp has 15 columns but 14 values were
supplied"
---------------
Expected behaviour: If you run the updater on an up-to date sqlite schema but
with indexes missing, the updater should add the indexes
Actual behaviour. Due to initial-indexes.sql copying over tables, but still
expecting columns like user_options which have been dropped, sql errors occur.
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
