David,
The install works until the very end.
I am new to MSQL so I am sure this error is from my own oversight.
I get the truncated error.
I am using Php admin for MySQL 4.1
I thought I hade uniform character settings but my initial settings are utf8
while the table rows eventually read latin1-bin
I think this is the problem.
Attached is my error log.
Thanks
James Rubino
* FLUSHING SQLData...
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 216
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 269
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1077
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1955
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2050
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2252
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2427
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2752
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3228
CURS.executemany(self.sqlString, self.converter(self.values()))
* FLUSHING SQLData...
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 92
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 720
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 851
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1592
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1747
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2086
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2228
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3345
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3761
CURS.executemany(self.sqlString, self.converter(self.values()))
* FLUSHING SQLData...
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 907
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1856
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2397
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2967
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3975
CURS.executemany(self.sqlString, self.converter(self.values()))
SCANNING quotes: Fantôme d'Henri Langlois, Le (2004)
* FLUSHING SQLData...
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 330
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 619
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1114
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1506
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1741
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1785
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2078
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2093
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2431
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2861
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3309
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3900
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3953
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3955
CURS.executemany(self.sqlString, self.converter(self.values()))
* FLUSHING SQLData...
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 55
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 648
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 711
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 825
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1031
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1216
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2391
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3358
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3378
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3723
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3841
CURS.executemany(self.sqlString, self.converter(self.values()))
* FLUSHING SQLData...
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 673
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1032
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1147
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1372
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1869
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2889
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3324
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3464
CURS.executemany(self.sqlString, self.converter(self.values()))
* FLUSHING SQLData...
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 4
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 887
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 991
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1111
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2274
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2470
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2764
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2767
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2774
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3211
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3254
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3910
CURS.executemany(self.sqlString, self.converter(self.values()))
* FLUSHING SQLData...
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 16
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 43
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 529
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 567
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1143
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1946
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2279
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2363
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3361
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3523
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3646
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3765
CURS.executemany(self.sqlString, self.converter(self.values()))
* FLUSHING SQLData...
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 89
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 397
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 960
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 1162
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 2220
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3139
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3595
CURS.executemany(self.sqlString, self.converter(self.values()))
C:\Python25\Scripts\imdbpy2sql.py:982: Warning: Data truncated for column 'info'
at row 3877
CURS.executemany(self.sqlString, self.converter(self.values()))
* FLUSHING SQLData...
Traceback (most recent call last):
File "C:\Python25\Scripts\imdbpy2sql.py", line 2094, in <module>
run()
File "C:\Python25\Scripts\imdbpy2sql.py", line 2002, in run
doMinusHashFiles()
File "C:\Python25\Scripts\imdbpy2sql.py", line 1371, in doMinusHashFiles
minusHashFiles(fp, funct, INFO_TYPES[index], fname)
File "C:\Python25\Scripts\imdbpy2sql.py", line 1350, in minusHashFiles
sqldata.add((mid, defaultid, data))
File "C:\Python25\Scripts\imdbpy2sql.py", line 927, in add
self[key] = None
File "C:\Python25\Scripts\imdbpy2sql.py", line 922, in __setitem__
self.flush()
File "C:\Python25\Scripts\imdbpy2sql.py", line 948, in flush
self._toDB()
File "C:\Python25\Scripts\imdbpy2sql.py", line 982, in _toDB
CURS.executemany(self.sqlString, self.converter(self.values()))
File "C:\Python25\lib\site-packages\mysql_python-1.2.2.0002-py2.5-win32.egg\My
SQLdb\cursors.py", line 218, in executemany
r = self._query('\n'.join([query[:p], ',\n'.join(q), query[e:]]))
MemoryError
C:\Python25\Scripts>
C:\Python25\Scripts>
C:\Python25\Scripts>-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Imdbpy-devel mailing list
Imdbpy-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
