[Zope] Scripting for Python Errors

[Tim Zegir]

Hello List,
 
I am porting data from an old postgresql (7.3.2) database to a new mysql
(4)
Database.
 
I have this python script to do the mappings from one table to another,
 
Line 1 --- for object in context.get_all_from_postgres():
Line 2 ---   context.insert_into_mysql(id=object.id, name=object.name,
code=object.code, home=object.home, map=object.map, posx=object.posx,
posy=object.posy, enabled=object.enabled, mobile=object.mobile,
email=object.email)
Line 3 --- 
Line 4 --- return 'Done'
 
Get_all_from_postgres and insert_into_mysql are zsql objects.
 
This scrip works fine except when it gets near the end of the table
entry's it gives me this error,
Error Type: OperationalError
Error Value: (1054, "Unknown column 'None' in 'field list'")
Does anyone have any ideas???
Thanks
From
Tim Zegir
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.zope.org/pipermail/zope/attachments/20031205/2555bca0/attachment.html