I've got a small issue with imdbpy2sql.py. I'm running CVS (current as of
last night) in order to work around a previous character encoding issue
already covered, here, but I've stumbled onto another one:
SCANNING actor: Four Kings, The
SCANNING actor: Franchi, Sergio
* FLUSHING SQLData...
Traceback (most recent call last):
File "/usr/local/bin/imdbpy2sql.py", line 1662, in <module>
run()
File "/usr/local/bin/imdbpy2sql.py", line 1571, in run
castLists()
File "/usr/local/bin/imdbpy2sql.py", line 879, in castLists
doCast(f, roleid, rolename)
File "/usr/local/bin/imdbpy2sql.py", line 854, in doCast
sqldata.add((pid, movieid, role, note, order))
File "/usr/local/bin/imdbpy2sql.py", line 679, in add
self[key] = None
File "/usr/local/bin/imdbpy2sql.py", line 674, in __setitem__
self.flush()
File "/usr/local/bin/imdbpy2sql.py", line 696, in flush
self._toDB()
File "/usr/local/bin/imdbpy2sql.py", line 723, in _toDB
CURS.executemany(self.sqlString, self.converter(self.values()))
psycopg.ProgrammingError: ERROR: invalid byte sequence for encoding "UTF8":
0xc327
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
INSERT INTO cast_info (person_id, movie_id, person_role, note, nr_order,
role_id) VALUES (248024, 758459, 'Puhuja Helsingist�', NULL, 33, 1)
This is using Python 2.5, SQLObject 0.7.1, and python-psycopg 1.1.21. Would
upgrading to newer versions of any of these fix my issue, or is it a problem
with imdbpy2sql.py, itself? This is preventing me from doing the import, so
any advice would be greatly appreciated.
Andrew
(Oh, and thanks so much for writing this thing in the first place. Very
useful!)
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Imdbpy-devel mailing list
Imdbpy-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
