Database is locked

[Former user]

Originally reported on Google Code with ID 256

What steps will reproduce the problem?
1. Won't let me add, delete or update a row in the database. 

What is the expected output? What do you see instead?
It should correctly add, edit or delete that specific row. 

What version of the product are you using? On what operating system? Which
Database Extension (PDO/SQLiteDatabase/SQLiteDatabase3 - see Database
structure-tab in phpLiteAdmin)?
PDO

Please provide any additional information below.

Reported by rosemarygraham94 on 2014-07-04 20:52:15

[Christopher Kramer]

Do you get any error message? Does the tab on the left say [r] or [rw] next to your
database?

Is the database file writeable? Have you checked the rights of the file? Tried chmod
777 or chown www-data:www-data?

Reported by crazy4chrissi on 2014-07-04 22:41:40

[Former user]

It says [rw] next to my database. 

Reported by rosemarygraham94 on 2014-07-07 17:08:29

[Former user]

I was able to fix the issue by exporting the contents of the database, deleting it and
the recreating, importing. No system file permissions were changed.

Reported by straterpatrick on 2014-07-07 17:17:54

[Christopher Kramer]

Was there any error message before when you tried to change the database?
Perhaps some other program opened the DB, got a lock and crashed without unlocking
the DB?

Reported by crazy4chrissi on 2014-07-07 17:20:59

[Former user]

There isn't another program accessing that file and I even tried rebooting apache to
clear the lock with no success. The only error was that the DB was locked.

Reported by straterpatrick on 2014-07-07 17:30:03

[Christopher Kramer]

I don't know how I could reproduce this and I think it is rather a problem of a db in
a corrupted state than a problem of phpLiteAdmin.
Therefore closing the issue.

Reported by crazy4chrissi on 2014-12-27 23:28:10 - Status changed: Invalid