Django "can't Adapt Type" Error Using Mutliple Databases (postgresql 8.4 And Sqlite3)

Short Description Using a local (sqlite3) database I can save and extract information, however when using my production sever (postgresql 8.4 on a different machine) Django throws

Solution 1:

Turns out that sqlite3 ignores and or tries to convert a value to a string when using it in a Django filter. From the GUI I was passing in the actual chassis object rather than the serial number. Postgresql threw the error when trying to use a Chassis object as a serial number while sqlite3 ignored it and cast it as a string (which I defined in Django as the serial number).

I hope this discovery might help someone else when trying to debug this type of error.

Thanks for all who looked into this.