Last modified: 2014-07-07 14:15:52 UTC
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.