Hi, Hello,
I’m trying to run imdbpy from a local database. Using the following code: i = IMDb('sql', uri=‘<<<mysqlinfo>>>') resList = i.search_movie('the incredibles') for x in resList: print x ti = resList[0] i.update(ti) print ti['director'][0] I get an error, as listed at the bottom. I think this is related, to either the Title IDs not being registered in the database, or in an error in trying to update the IMDb object with a movie object. It seems like I can’t update in the idle prompt either. Any help would be greatly appreciated. Thanks, Michael Specs: OS X 10.10.5, python 2.7.12, Mysql Ver 14.14 Distrib 5.7.16. Imdbpy 5.2dev20161118’ ERROR CODE: 2016-12-07 17:43:54,108 WARNING [imdbpy.parser.sql.aux] /Library/Python/2.7/site-packages/imdb/parser/sql/__init__.py:458: Unable to fetch information for movieID 3805020: The object Title by the ID 3805020 does not exist 2016-12-07 17:43:54,173 WARNING [imdbpy.parser.sql.aux] /Library/Python/2.7/site-packages/imdb/parser/sql/__init__.py:458: Unable to fetch information for movieID 3208968: The object Title by the ID 3208968 does not exist 2016-12-07 17:43:54,258 WARNING [imdbpy.parser.sql.aux] /Library/Python/2.7/site-packages/imdb/parser/sql/__init__.py:458: Unable to fetch information for movieID 3237815: The object Title by the ID 3237815 does not exist 2016-12-07 17:43:54,325 WARNING [imdbpy.parser.sql.aux] /Library/Python/2.7/site-packages/imdb/parser/sql/__init__.py:458: Unable to fetch information for movieID 3279356: The object Title by the ID 3279356 does not exist 2016-12-07 17:43:54,396 WARNING [imdbpy.parser.sql.aux] /Library/Python/2.7/site-packages/imdb/parser/sql/__init__.py:458: Unable to fetch information for movieID 3473388: The object Title by the ID 3473388 does not exist 2016-12-07 17:43:54,456 WARNING [imdbpy.parser.sql.aux] /Library/Python/2.7/site-packages/imdb/parser/sql/__init__.py:458: Unable to fetch information for movieID 2963043: The object Title by the ID 2963043 does not exist [… ] Incredible Neobyknovenniy Posha The Incredible Ned The Incredible Hulk The Incredible Hulk The Incredible Hulk The Incredible Hulk Hulk Incredible Tales The Incredible Truth The Incredible Genie The Incredible Drunk Incredible Bugs The Incredible Gulp 4 The Incredible Gulp 2 L'Incroyable Marrec The Ingredient 2016-12-07 17:43:56,500 WARNING [imdbpy.parser.sql.aux] /Library/Python/2.7/site-packages/imdb/parser/sql/__init__.py:458: Unable to fetch information for movieID 3805020: The object Title by the ID 3805020 does not exist 2016-12-07 17:43:56,535 CRITICAL [imdbpy] /Library/Python/2.7/site-packages/imdb/_exceptions.py:35: IMDbDataAccessError exception raised; args: ('unable to get movieID "3805020"',); kwds: {} Traceback (most recent call last): File "/usr/local/Cellar/python/2.7.12_2/Frameworks/Python.framework/Versions/2.7/lib/python2.7/idlelib/run.py", line 111, in main seq, request = rpc.request_queue.get(block=True, timeout=0.05) File "/usr/local/Cellar/python/2.7.12_2/Frameworks/Python.framework/Versions/2.7/lib/python2.7/Queue.py", line 176, in get raise Empty Empty 2016-12-07 17:43:56,602 CRITICAL [imdbpy] /Library/Python/2.7/site-packages/imdb/__init__.py:777: caught an exception retrieving or parsing "main" info set for mopID "3805020" (accessSystem: sql) Traceback (most recent call last): File "/Library/Python/2.7/site-packages/imdb/__init__.py", line 772, in update ret = method(mopID) File "/Library/Python/2.7/site-packages/imdb/parser/sql/__init__.py", line 1037, in get_movie_main raise IMDbDataAccessError('unable to get movieID "%s"' % movieID) IMDbDataAccessError: unable to get movieID "3805020" 2016-12-07 17:43:56,671 WARNING [imdbpy.parser.sql.aux] /Library/Python/2.7/site-packages/imdb/parser/sql/__init__.py:458: Unable to fetch information for movieID 3805020: The object Title by the ID 3805020 does not exist 2016-12-07 17:43:56,736 CRITICAL [imdbpy] /Library/Python/2.7/site-packages/imdb/_exceptions.py:35: IMDbDataAccessError exception raised; args: ('unable to get movieID "3805020"',); kwds: {} Traceback (most recent call last): File "/Library/Python/2.7/site-packages/imdb/__init__.py", line 772, in update ret = method(mopID) File "/Library/Python/2.7/site-packages/imdb/parser/sql/__init__.py", line 1037, in get_movie_main raise IMDbDataAccessError('unable to get movieID "%s"' % movieID) IMDbDataAccessError: unable to get movieID "3805020" 2016-12-07 17:43:56,802 CRITICAL [imdbpy] /Library/Python/2.7/site-packages/imdb/__init__.py:777: caught an exception retrieving or parsing "plot" info set for mopID "3805020" (accessSystem: sql) Traceback (most recent call last): File "/Library/Python/2.7/site-packages/imdb/__init__.py", line 772, in update ret = method(mopID) File "/Library/Python/2.7/site-packages/imdb/parser/sql/__init__.py", line 1037, in get_movie_main raise IMDbDataAccessError('unable to get movieID "%s"' % movieID) IMDbDataAccessError: unable to get movieID "3805020" Traceback (most recent call last): File "/Users/AA/code/python/imdbpy/test_imdbpy_sql2.py", line 8, in <module> print ti['director'][0] File "/Library/Python/2.7/site-packages/imdb/utils.py", line 1472, in __getitem__ rawData = self.data[key] KeyError: 'director' ------------------------------------------------------------------------------ Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today.http://sdm.link/xeonphi _______________________________________________ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help