> Whenever my phBB3 install is failing on the PPC Mac Mini, it appears > that SQLite is producing an empty database file (size 0) plus a file > with the same name plus "-journal" appended. What kind of error is > this? Does this mean SQLite somehow crashed out while attempting to > write to the DB?
The journal file is created when a database transaction begins. The file is used to ensure that the transaction is "atomic"-- ie, that it completes fully, or not at all. In your case, the leftover journal file likely indicates that the phBB3 install either crashed mid-update, or it neglected to "commit" the pending transaction. The next process that opens the database will detect the incomplete transaction, and roll the database back to its previous (in this case empty) state. Some helpful info: http://www.sqlite.org/tempfiles.html http://www.sqlite.org/atomiccommit.html ~Eric _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
