Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

problem loading data from csv files

2011-05-03
2013-05-30
  • Utkarsh Dubey
    Utkarsh Dubey
    2011-05-03

    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

     
  • Icarus
    Icarus
    2011-06-23

    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