SQL syntax error when converting wiki table from 0.12 install

[jolyon@…]

We are running Percona MySQL 5.5.20, which is compatible with the general release MySQL 5.5 series the error (below) suggests there is a syntax problem with the IF statement in the SQL, but I imagine our data set might have something to do with it also.

Also, this is a recently converted trac install from 0.11 to 0.12, in case there might have been an artifact from the upgrade process that is contributing to this error.

creating system with name,value
creating permission with username,action
creating auth_cookie with cookie,name,ipnr,time
creating session with sid,authenticated,last_visit
creating session_attribute with sid,authenticated,name,value
creating attachment with type,id,filename,size,time,description,author,ipnr
creating wiki with name,version,time,author,ipnr,text,comment,readonly
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, <IN> chunk 2598.
creating IF with ,,,,,,the,we,but,have,when,they,which,we,but,external,birthday,UP,,special,,so,,but,can,you,but,,,,,if,it,Amistad,at,if,THEN,only,they,Overall,Cumulative,,when,they,much,they,for,he,in,would,,,would,which,can,so,show,instead,and,it,not,just,it,so,we,when,to,just,but,detention,make,it,which,but,reading,and,when,records,specifically,not,often,but,so,Under,I,teacher,and,Instead,can,Can,,On,can,,UNIQUE,,,
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF' at line 1 at /usr/local/bin/sqlite2mysql.pl line 92, <IN> chunk 2598.
can't drop IF 
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF' at line 1 at /usr/local/bin/sqlite2mysql.pl line 92, <IN> chunk 2598.

let me know what other info I can provide.

[Ryan J Ollos]

This plugin is deprecated. See the TracMigratePlugin.