#27 MySQL and Windows 7

closed
sql (8)
5
2012-09-01
2011-04-23
No

I have the same problem as described here:
http://groups.google.com/group/imdbpy-users/browse_thread/thread/2ef48768027b9586/7029ff37a734e170
http://www.mail-archive.com/imdbpy-devel@lists.sourceforge.net/msg00757.html

$ python imdbpy2sql.py -d D:\imdb -u mysql://u:p@localhost/imdb --mysql-force-myisam
_mysql_exceptions.IntegrityError: (1062, "Duplicate entry '758975' for key 'PRIMARY'")
Full error log as attachment.

My system:
Windows 7 Home Premium (64 bit); 4 GB RAM
ActivePython 2.7.1.4 (ActiveState Software Inc.) based on
Python 2.7.1 (r271:86832, Feb 7 2011, 11:30:38) [MSC v.1500 32 bit (Intel)] on win32
Server version: 5.5.11 MySQL Community Server (GPL)
$ pypm freeze
decorator==3.3.1
distribute==0.6.15
formencode==1.2.4
imdbpy==4.7
imdbpykit==1.1.1
lxml==2.3
mysql-python==1.2.3
paste==1.7.5.1
pastedeploy==1.3.4
pastescript==1.7.3
pastewebkit==1.0
pip==1.0
sqlalchemy==0.7b1
sqlalchemy-migrate==0.6.1
sqlobject==1.0.0b1dev-r4354
tempita==0.5dev

Discussion

  • Jef Van den Brandt

    backtrace

     
  • Jef Van den Brandt

    I did a bit of debugging. It all boils down to this exception:
    OperationalError: (1366, "Incorrect string value: '\\xC3' for column 'name' at row 1")

    I only get it when I use the full actor dataset. I have no problems with a reduced dataset with more than 200000 records and has the same char at least once.

    The debugging info and the console output is added as attachment.

    I think that something like this causes it:
    'Dr. Nu\xc3\x9fgruber': 310998,

     
  • Jef Van den Brandt

    pydev debug output

     
  • Davide Alberani

    Davide Alberani - 2011-04-25

    Thanks for the report!

    Right now it's hard to tell if this bug is related to the ongoing problem with unicode/utf8 chars (see this thread: http://groups.google.com/group/imdbpy-users/browse_thread/thread/7a9c4448943202e8 ) or it's something related to MySQL on Windows.

    If you can, please try using the CSV files:
    - create an empty directory (let's say C:\Temp)
    - run the imdbpy2sql.py script with the usual arguments plus: -c C:\Temp\ (notice the two backslashes: yes, there's a known problem in imdbpy2sql.py waiting to be fixed :-/ )

    Let me know it this improves your results (by the way, I think there's another bug related to the use of CSV...)

     


Anonymous

Cancel  Add attachments





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

Sign up for the SourceForge newsletter:





No, thanks