Hi Michael,
yes, it seems that something has gone wrong populating the database.
I've just tested it, and works for me.
Running imdbpy2sql.py, it's usually a good idea to append some
redirection to store the output, like:
./imdbpy2sql.py -d /path/to/files -u
mysql://user:password@localhost:/imdb 2>&1 | tee ~/OUTPUT.log
Maybe with that we can try to understand what happened.
Thanks for the report!
On Wed, Dec 7, 2016 at 11:47 PM, Michael Solsky
<michael.sol...@gmail.com> wrote:
> 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
--
Davide Alberani <davide.alber...@gmail.com> [PGP KeyID: 0x3845A3D4AC9B61AD]
http://www.mimante.net/
------------------------------------------------------------------------------
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/intel
_______________________________________________
Imdbpy-help mailing list
Imdbpy-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-help
