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