Hi, At the end of imdbpy2sql.py script, i get this error:
# TIME TOTAL TIME TO INSERT/WRITE DATA : 253min, 55sec (wall) 93min, 7sec (user) 15min, 0sec (system) building database indexes (this may take a while) # TIME createIndexes() : 26min, 33sec (wall) 0min, 0sec (user) 0min, 0sec (system) adding foreign keys (this may take a while) Traceback (most recent call last): File "/usr/bin/imdbpy2sql.py", line 5, in <module> pkg_resources.run_script('IMDbPY==4.8.2', 'imdbpy2sql.py') File "/usr/lib64/python2.6/site-packages/pkg_resources.py", line 500, in run_script self.require(requires)[0].run_script(script_name, ns) File "/usr/lib64/python2.6/site-packages/pkg_resources.py", line 1236, in run_script execfile(script_filename, namespace, namespace) File "/usr/lib64/python2.6/site-packages/IMDbPY-4.8.2-py2.6-linux-x86_64.egg/EGG-INFO/scripts/imdbpy2sql.py", line 2958, in <module> run() File "/usr/lib64/python2.6/site-packages/IMDbPY-4.8.2-py2.6-linux-x86_64.egg/EGG-INFO/scripts/imdbpy2sql.py", line 2910, in run buildIndexesAndFK() File "/usr/lib64/python2.6/site-packages/IMDbPY-4.8.2-py2.6-linux-x86_64.egg/EGG-INFO/scripts/imdbpy2sql.py", line 2722, in buildIndexesAndFK createForeignKeys(DB_TABLES) File "/usr/lib64/python2.6/site-packages/IMDbPY-4.8.2-py2.6-linux-x86_64.egg/imdb/parser/sql/dbschema.py", line 460, in createForeignKeys table.addForeignKeys(mapTables, ifNotExists) File "/usr/lib64/python2.6/site-packages/IMDbPY-4.8.2-py2.6-linux-x86_64.egg/imdb/parser/sql/objectadapter.py", line 133, in addForeignKeys newcls._connection.query(fkQuery) File "/usr/lib64/python2.6/site-packages/sqlobject/dbconnection.py", line 414, in query return self._runWithConnection(self._query, s) File "/usr/lib64/python2.6/site-packages/sqlobject/dbconnection.py", line 327, in _runWithConnection val = meth(conn, *args) File "/usr/lib64/python2.6/site-packages/sqlobject/dbconnection.py", line 411, in _query self._executeRetry(conn, conn.cursor(), s) File "/usr/lib64/python2.6/site-packages/sqlobject/dbconnection.py", line 406, in _executeRetry return cursor.execute(query) psycopg2.IntegrityError: insert or update on table "movie_info" violates foreign key constraint "movie_id_exists" DETAIL: Key (movie_id)=(2077921) is not present in table "title". When i look in movie_info table for id 2077921, i have this: id; movie_id; info_type; info; note "2077921";1559911;96;"Hallo - Sie haben Ihre Frau vergessen. In: Illustrierte Film-Bühne, Film-Bühne G.m.b.H., No. 310, 1949, Pgs. 4";"" In table title, i have no line with id=2077921 but i have a line with id =1559911 (the number from movie_info's movie_id. The line seems to match :) "1559911";"Hallo - Sie haben Ihre Frau vergessen";"";1;1949;;"H4215";;;;"";"8500761c703695245a02335ec6e4e139" The data files were downloaded on december 13th and i use imdbpy 4.8.2. If you need any more informations, i can provide them ------------------------------------------------------------------------------ Cloud Computing - Latest Buzzword or a Glimpse of the Future? This paper surveys cloud computing today: What are the benefits? Why are businesses embracing it? What are its payoffs and pitfalls? http://www.accelacomm.com/jaw/sdnl/114/51425149/ _______________________________________________ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help