I downloaded the en_20080727 dump and trying to load data from it into the mysql..but wen i call the loaddata() method I get an error for content.csv file
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 ''''Anarchism''' (from [] ἀν (without) + ἄ�χειν (' at line 1)
I have no idea because all other csv files are loaded successfully….
Any idea what could be the reason?
Thanks
dutkarsh
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Can you go to that line in the content.csv and try inserting that data from the MySQL query editor ? Perhaps the data in the cells has values that make the generated SQL invalid.
Thanks,
Ic
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I downloaded the en_20080727 dump and trying to load data from it into the mysql..but wen i call the loaddata() method I get an error for content.csv file
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 ''''Anarchism''' (from [] ἀν (without) + ἄ�χειν (' at line 1)
I have no idea because all other csv files are loaded successfully….
Any idea what could be the reason?
Thanks
dutkarsh
Hi dutkarsh,
Can you go to that line in the content.csv and try inserting that data from the MySQL query editor ? Perhaps the data in the cells has values that make the generated SQL invalid.
Thanks,
Ic