Hi,
I am running imdbpy2sql.py on MySQL 5.1 and I am receiving an error like
below:
Traceback (most recent call last):
File "C:\WorkSpace\tez\IMDbPY-4.1\imdbpy2sql.py", line 2580, in <module>
run()
File "C:\WorkSpace\tez\IMDbPY-4.1\imdbpy2sql.py", line 2424, in run
readMovieList()
File "C:\WorkSpace\tez\IMDbPY-4.1\imdbpy2sql.py", line 1439, in
readMovieList
mid = CACHE_MID.addUnique(title, yearData)
File "C:\WorkSpace\tez\IMDbPY-4.1\imdbpy2sql.py", line 1053, in addUnique
else: return self.add(key, miscData)
File "C:\WorkSpace\tez\IMDbPY-4.1\imdbpy2sql.py", line 932, in add
self[key] = c
File "C:\WorkSpace\tez\IMDbPY-4.1\imdbpy2sql.py", line 842, in __setitem__
self.flush()
File "C:\WorkSpace\tez\IMDbPY-4.1\imdbpy2sql.py", line 894, in flush
self.flush(quiet=quiet, _recursionLevel=_recursionLevel)
File "C:\WorkSpace\tez\IMDbPY-4.1\imdbpy2sql.py", line 894, in flush
self.flush(quiet=quiet, _recursionLevel=_recursionLevel)
File "C:\WorkSpace\tez\IMDbPY-4.1\imdbpy2sql.py", line 894, in flush
self.flush(quiet=quiet, _recursionLevel=_recursionLevel)
File "C:\WorkSpace\tez\IMDbPY-4.1\imdbpy2sql.py", line 894, in flush
self.flush(quiet=quiet, _recursionLevel=_recursionLevel)
File "C:\WorkSpace\tez\IMDbPY-4.1\imdbpy2sql.py", line 898, in flush
self.flush(quiet=quiet, _recursionLevel=_recursionLevel)
File "C:\WorkSpace\tez\IMDbPY-4.1\imdbpy2sql.py", line 898, in flush
self.flush(quiet=quiet, _recursionLevel=_recursionLevel)
File "C:\WorkSpace\tez\IMDbPY-4.1\imdbpy2sql.py", line 894, in flush
self.flush(quiet=quiet, _recursionLevel=_recursionLevel)
File "C:\WorkSpace\tez\IMDbPY-4.1\imdbpy2sql.py", line 865, in flush
self._toDB(quiet)
File "C:\WorkSpace\tez\IMDbPY-4.1\imdbpy2sql.py", line 1037, in _toDB
self._runCommand(l)
File "C:\WorkSpace\tez\IMDbPY-4.1\imdbpy2sql.py", line 1041, in
_runCommand
CURS.executemany(self.sqlstr, self.converter(dataList))
File "C:\Python25\Lib\site-packages\MySQLdb\cursors.py", line 218, in
executemany
r = self._query('\n'.join([query[:p], ',\n'.join(q), query[e:]]))
File "C:\Python25\Lib\site-packages\MySQLdb\cursors.py", line 312, in
_query
rowcount = self._do_query(q)
File "C:\Python25\Lib\site-packages\MySQLdb\cursors.py", line 276, in
_do_query
db.query(q)
_mysql_exceptions.DataError: (1406, "Data too long for column
'phonetic_code' at row 88")
I would be very glad if you helped me with this situation.
Thanks in advance.
Best Regards,
Gozde
------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image
processing features enabled. http://p.sf.net/sfu/kodak-com
_______________________________________________
Imdbpy-help mailing list
Imdbpy-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-help
