id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 9834,SQL syntax error when converting wiki table from 0.12 install,jolyon@…,takayama,"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, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, chunk 2598. Use of uninitialized value in join or string at /usr/local/bin/sqlite2mysql.pl line 91, 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, 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, chunk 2598. }}} let me know what other info I can provide.",defect,closed,normal,SqliteToMySqlScript,critical,wontfix,,jolyon@… Jun Omae,0.12