* Davide Alberani <davide.alber...@gmail.com> [2011-04-23 13:23:18]: > If it still fails: > - check your postgres settings. > - try using SQLite (just for a test) - see notes in README.sqldb
Hi, I've just had a try using sqlite with fresh lists and on my Debian system and I get this: thomas@ikaite:~$ /tmp/imdbpy2sql.py -d /home/thomas/Desktop/imdb/lists -u sqlite:///home/thomas/Desktop/imdb/imdb.db --sqlite-transactions IMPORTING psyco... DONE! 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, 2sec (wall) 0min, 0sec (user) 0min, 0sec (system) SCANNING movies: !Women Art Revolution (2010) (movieID: 1) SCANNING movies: A Child's Garden of Verses (1992) (TV) (movieID: 10001) SCANNING movies: A Strict Affair... Lessons in Discipline and Obedience (1992) (V) (movieID: 20001) SCANNING movies: AIDS: What Everyone Needs to Know (1987) (movieID: 30001) SCANNING movies: Amour (1922) (movieID: 40001) SCANNING movies: Arktinen lumous (1997) (TV) (movieID: 50001) SCANNING movies: Baby's Storytime (1989) (V) (movieID: 60001) SCANNING movies: Bei jiu gao ge (1974) (movieID: 70001) SCANNING movies: Black in the Ass 8 (2005) (V) (movieID: 80001) SCANNING movies: Breaking In (1925) (movieID: 90001) EXECUTING "BEFORE_MOVIES_TODB:BEGIN TRANSACTION;"... EXECUTING "BEGIN TRANSACTION;"... DONE! * FLUSHING MoviesCache... Traceback (most recent call last): File "/tmp/imdbpy2sql.py", line 2950, in <module> run() File "/tmp/imdbpy2sql.py", line 2786, in run readMovieList() File "/tmp/imdbpy2sql.py", line 1467, in readMovieList mid = CACHE_MID.addUnique(title, yearData) File "/tmp/imdbpy2sql.py", line 1073, in addUnique else: return self.add(key, miscData) File "/tmp/imdbpy2sql.py", line 950, in add self[key] = c File "/tmp/imdbpy2sql.py", line 860, in __setitem__ self.flush() File "/tmp/imdbpy2sql.py", line 883, in flush self._toDB(quiet) File "/tmp/imdbpy2sql.py", line 1057, in _toDB self._runCommand(l) File "/tmp/imdbpy2sql.py", line 1061, in _runCommand CURS.executemany(self.sqlstr, self.converter(dataList)) pysqlite2.dbapi2.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. thomas@ikaite:~$ Regards -- Tom ------------------------------------------------------------------------------ Fulfilling the Lean Software Promise Lean software platforms are now widely adopted and the benefits have been demonstrated beyond question. Learn why your peers are replacing JEE containers with lightweight application servers - and what you can gain from the move. http://p.sf.net/sfu/vmware-sfemails _______________________________________________ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help