Hello,
I've just joined this list. I found this app this morning and
downloaded the imdb database last night. While converting the data, I
was getting an error stating that some data was too long for the
person_info.info field in the biographies list.
This patch changes the person_info.info field from a text to a
mediumtext field.
After making this change, I was able to successfully convert the text
files into a mysql database.
Thanks!!
Mark Armendariz
=== modified file 'imdbpy/imdb/parser/sql/dbschema.py'
--- imdbpy/imdb/parser/sql/dbschema.py 2008-04-02 06:48:00 +0000
+++ imdbpy/imdb/parser/sql/dbschema.py 2008-04-02 06:49:41 +0000
@@ -128,7 +128,7 @@
class PersonInfo(SQLObject):
personID = IntCol(notNone=True)
infoTypeID = IntCol(notNone=True)
- info = UnicodeCol(notNone=True)
+ info = BLOBCol(notNone=True, varchar=True, length=2**16)
note = UnicodeCol(default=None)
class RoleType(SQLObject):
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Imdbpy-devel mailing list
Imdbpy-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
