On Apr 13, Atul Kulkarni <atulskulka...@gmail.com> wrote:
> /usr/bin/imdbpy2sql.py:1278: Warning: Incorrect string value: '\xC2\x92s
> ch...' for column 'info' at row 1164
> /usr/bin/imdbpy2sql.py:1006: Warning: Incorrect string value: '\xC2\x80$'
> for column 'title' at row 35842
>
> Will they have any impact on my query?
I can't tell, since I can't figure the strange errors you got.
Or better: looks like a problem with garbage in the plain text
data files or a misconfiguration about charset/collation of your
MySQL, but... who knows? That chars don't make much sense. :-/
> I am getting some errors like
[...]
> TypeError: int() argument must be a string or a number, not 'NoneType'
That's really bad and should never happen.
It's as if the 'id' column in the 'title' table contains some
NULL value, but this can't be.
If possible, you can try this:
- update to 4.0 (I guess you're using 3.9 or older).
- run imdbpy2sql.py appending this:
2>&1 | tee OUTPUT.txt
so that you can record its output in OUTPUT.txt.
- show me the code you're running (or a short example useful to
reproduce the problem), if possible using movie titles and not
movieIDs.
I.e.: i.get_movie(1234) is not that useful to debug the "sql"
data access system; it's much better:
movie = i.search_movie('The Movie Title')[0]
i.update(movie)
Thank you very much!
--
Davide Alberani <davide.alber...@gmail.com> [PGP KeyID: 0x465BFD47]
http://erlug.linux.it/~da/
------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Imdbpy-help mailing list
Imdbpy-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-help
