Kickstart error on SQLite
Guys,
I installed Drupal Kickstart fixing up php.ini file a few times along the way. I now have demo store at www.meadowbank.biz/drupalks.
I tried to login as admin and get this error
PDOException: SQLSTATE[HY000]: General error: 5 database is locked: INSERT INTO {variable} (name, value) VALUES (?, ?); Array ( [0] => rules_empty_sets [1] => a:66:{
I looked up this error and saw sqlite database as being a problem This is the reason I choose Drupal Kickstart. the following comment was interesting
have ubuntu 10.10 with SQLite 3.7.2, and my simple tests also shows me error you mentioned. My first impression is that in comparison to MySQL-based SQLite-based Drupal is not really usable out-of-the-box.
http://drupal.org/node/1120020
Any progress on the fix?
Thanks

Comments
Anyone tried this on a server?
Removing Sqlite Database Locks Using `.backup`
The general strategy here is to create a backup of the database, where the backup does not have the locks, and then swapping out the database with the backup copy. Here's how to do this.
Use the command line sqlite3 program to do the following (assuming the sqlite database file is named .ht.sqlite, as it is by default in Drupal):
$ sqlite3 .ht.sqlite
sqlite> .backup main backup.sqlite
sqlite> .exit
Now you should have a file called backup.sqlite in the same directory. Next, you need to move your old database, and replace it with the backup copy. As far as I understand it, the backup copy does not have the locks, so this swap will essentially eliminate the problem.
$ mv .ht.sqlite old.sqlite
$ mv backup.sqlite .ht.sqlite
At this point you should be able to once again access the database with the sqlite3 command line client. You may also need to chown or chmod the file in order to grant access to the webserver again. But that's all there is to it.
Once you have tested and verified that your database is once again allowing both reads and writes, you can and should delete the old database file.