Modify

Opened 3 years ago

Closed 18 months ago

#9834 closed defect (wontfix)

SQL syntax error when converting wiki table from 0.12 install

Reported by: jolyon@… Owned by: takayama
Priority: normal Component: SqliteToMySqlScript
Severity: critical Keywords:
Cc: jolyon@…, jun66j5 Trac Release: 0.12

Description

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.

Attachments (0)

Change History (1)

comment:1 Changed 18 months ago by rjollos

  • Cc jun66j5 added
  • Resolution set to wontfix
  • Status changed from new to closed

This plugin is deprecated. See the TracMigratePlugin.

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.