On 1 Mar 2019, at 10:27am, Lloyd <lloydkl.t...@gmail.com> wrote: > I am able to serialize, deserialize and prepare a SQL query against the > rollback database. When I do the same against the WAL database file, the > 'prepare' statement fails with code '1'.
It's possible that some of the data for the WAL database is in the journal and hasn't been written back to the database properly. Was that database correctly closed when last used ? Using the SQLite command-line tool, open the database run "PRAGMA integrity_check;" on it close the database Then try serializing it again. If still fails, do the above again but "VACUUM;" it instead of the integrity_check. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users