Hi,
I have just installed imdbpy for the first time and I am getting the
same error reported in May only if I use the -o sqlobject parameter.
Using -o sqlalchemy works with the sqlite:////absolute_dir URI. Maybe
there is some other connection for sqlobject that needs the
text_factory=str fix.
Regards,
Luis
Versions
-------------
Ubuntu 10.10
Python 2.6.6
Sqlalchemy 0.6.3
Sqlobject 0.12.4
imdbpy 4.7
Command
------------------
imdbpy2sql.py -d $HOME/Descargas/imdb/ -u 'sqlite:/media/programacion/
Audiovisual/imdb/imdb.db' --sqlite-transactions -o sqlobject
Log
----------
RUNNING imdbpy2sql.py
EXECUTING "BEGIN:PRAGMA synchronous = OFF;"...
EXECUTING "PRAGMA synchronous = OFF;"... DONE!
# TIME BEGIN command : 0min, 0sec (wall) 0min, 0sec (user) 0min, 0sec
(system)
SAVING imdbID values for movies... SKIPPING: no data.
SAVING imdbID values for people... SKIPPING: no data.
SAVING imdbID values for characters... SKIPPING: no data.
SAVING imdbID values for companies... SKIPPING: no data.
DROPPING current database... DONE!
CREATING new tables... DONE!
# TIME dropping and recreating the database : 0min, 13sec (wall) 0min,
0sec (user) 0min, 0sec (system)
SCANNING movies: !Women Art Revolution (2010) (movieID: 1)
SCANNING movies: A Conversation Between Two Miserable People in Dr.
Tourin's Waiting Room (2006) (movieID: 10001)
SCANNING movies: A Touch of High Life (1916) (movieID: 20001)
SCANNING movies: Akon Makes a Video (2004) (TV) (movieID: 30001)
SCANNING movies: An Obstacle Race (1902) (movieID: 40001)
SCANNING movies: As Aventuras de Chico Valente (1968) (movieID: 50001)
SCANNING movies: Bagu (1997) (movieID: 60001)
SCANNING movies: Bertrand coeur de lion (1951) (movieID: 70001)
SCANNING movies: Blood Fare (2011) (movieID: 80001)
SCANNING movies: Brutale Stadt: Bronson & Sollima (2005) (V) (movieID:
90001)
EXECUTING "BEFORE_MOVIES_TODB:BEGIN TRANSACTION;"...
EXECUTING "BEGIN TRANSACTION;"... DONE!
* FLUSHING MoviesCache...
Traceback (most recent call last):
File "/usr/local/bin/imdbpy2sql.py", line 2950, in <module>
run()
File "/usr/local/bin/imdbpy2sql.py", line 2786, in run
readMovieList()
File "/usr/local/bin/imdbpy2sql.py", line 1467, in readMovieList
mid = CACHE_MID.addUnique(title, yearData)
File "/usr/local/bin/imdbpy2sql.py", line 1073, in addUnique
else: return self.add(key, miscData)
File "/usr/local/bin/imdbpy2sql.py", line 950, in add
self[key] = c
File "/usr/local/bin/imdbpy2sql.py", line 860, in __setitem__
self.flush()
File "/usr/local/bin/imdbpy2sql.py", line 883, in flush
self._toDB(quiet)
File "/usr/local/bin/imdbpy2sql.py", line 1057, in _toDB
self._runCommand(l)
File "/usr/local/bin/imdbpy2sql.py", line 1061, in _runCommand
CURS.executemany(self.sqlstr, self.converter(dataList))
sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless
you use a text_factory that can interpret 8-bit bytestrings (like
text_factory = str). It is highly recommended that you instead just
switch your application to Unicode strings.
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Imdbpy-help mailing list
Imdbpy-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-help
