Table has x columns but x values were

[solangepaz]

When I run this command:table lineorder has 2 columns but 17 values were supplied I have this error: Error: near line 60: table lineorder has 2 columns but 17 values were supplied Error: near line 61: table lineorder has 2 columns but 17 values were supplied Error: near line 62: table lineorder has 2 columns but 17 values were supplied Error: near line 63: table lineorder has 2 columns but 17 values were supplied Error: near line 64: table lineorder has 2 columns but 17 values were supplied Error: near line 65: table lineorder has 2 columns but 17 values were supplied Error: near line 66: table lineorder has 2 columns but 17 values were supplied Error: near line 67: table lineorder has 2 columns but 17 values were supplied

[dumblob]

Could you please post exact command how you created the MySQL dump you want to convert? mysql2sqlite depends on specifics of mysqldump syntax and we can't get around it, so you need to use it without arguments which change the resulting syntax (search for several other issues in this tracker to see what everything was caused by using other than supported syntax).

[solangepaz]

mysqldump -u root -h localhost --compact ssb1g > dump_mysql.sql

[solangepaz]

It is the same with this command: mysqldump --skip-extended-insert --compact ssb1g > dump_mysql.sql

[dumblob]

Thanks. Because it shouldn't happen, next thing would be the actual output of mysqldump. Could you please post somewhere (pastebin, gist, ...) at least the first few hundred lines?

[solangepaz]

https://pastebin.com/sduMMAgL Are these lines enough?

[solangepaz]

https://pastebin.com/WLk4CHxq The error is somewhere here