|Come for the quick hacks, stay for the epiphanies.
Upgraded SQLite: "database changed" errorby bsb (Priest)
|on Jun 05, 2007 at 07:14 UTC
bsb has asked for the wisdom of the Perl Monks concerning the following question:
Update: DBD::SQLite 1.14 now uses sqlite3_prepare_v2 and this problem has gone away. MattSargeant++
I just dist-upgraded my system and have since encountered the SQLite "database schema has changed" error in an application that worked prior to the upgrade.
The "change" involved is running ANALYZE which invalidates prepared statement handles (see the SQLite FAQ). Unfortunately, I don't control what is prepared where as I use Class::DBI so I'm looking to either revert to a working set of modules or work around the problem at a lower level.
Does the code below reproduce the problem for other people?
Any tips on same versions or work-arounds?
Update: I'm starting to think that the changes during the upgrade causing this problem to manifest were at the Class::DBI/Ima::DBI level. On my laptop I get an error for the above but an older version is the application (using ANALYZE) is fine. I'll compare versions tomorrow.