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

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks