updating tables (migration from 3ceam - rathena dabase)

[Kanage]

i need help with my database migration and as i updating my item_db this error occurred. hope someone can help me fix it ASAP all other tables has been updated from 3ceam to rathena except the error that appeared

i cant check whats the problem with line 49 it says theres an invalid syntax

i think ill just drop the tables and import my itemdb again. as i import again the itemdb, the error still persist. can someone figure out the problem here. thanks in advance for the help

Edited March 29, 2012 by Myrmiddon

[Jezu]

It is really hard to migrate 3CeAM to rAthena since 3CeAM is using old mechanics.

[Kanage]

i have sucesfully migrated my 3ceam database to rathena sir, the problem is that as i import the itemdb is has shown that error but i even drop the 3ceam itemdb tables to import rathena's own itemdb error still there while importing. hope our developer here can see and answer my problem. thanks in advance

Edited March 30, 2012 by Myrmiddon

[JayPee]

Hi, are you using phpMyAdmin? Try using another import tool such as MySQL Query Browser.

[Kanage]

@Jaypee, yes i am using myphpadmin and also mysql workbench CE. i have drop every 3ceam itemdb tables and use rathenas itemdb

i tried using mysql workbench but an error occurs when initiating and reading at the part of bellium_katzbalger and my workbench freezes.

ill try mysql query browser later.

itx now fixed. i used mysql query browser. workbench is the culprit, i think there something with the new syntax with that version. all is migrated from 3ceam to rathena database and no error occur while importing you may now mark this as fixed, thanks for the suggestion and help.

Edited March 30, 2012 by Myrmiddon