Change SQLite database mode to read-write

Question

There can be several reasons for this error message:

• Several processes have the database open at the same time (see the FAQ).

• There is a plugin to compress and encrypt the database. It doesn't allow to modify the DB.

• Lastly, another FAQ says: "Make sure that the directory containing the database file is also writable to the user executing the CGI script." I think this is because the engine needs to create more files in the directory.

• The whole filesystem might be read only, for example after a crash.

• On Unix systems, another process can replace the whole file.

I solved this by changing owner from root to me on all files on /db dir.

Just do ls -l on that folder, if any of the filer is owned by root just change it to you, using: sudo chown user file

(this error message is typically misleading, and is usually a general permissions error)

On Windows

• If you're issuing SQL directly against the database, make sure whatever application you're using to run the SQL is running as administrator
• If an application is attempting the update, the account that it uses to access the database may need permissions on the folder containing your database file. For example, if IIS is accessing the database, the IUSR and IIS_IUSRS may both need appropriate permissions (you can try this by temporarily giving these accounts full control over the folder, checking if this works, then tying down the permissions as appropriate)

This error usually happens when your database is accessed by one application already, and you're trying to access it with another application.

If using Android.

Make sure you have added the permission to write to your EXTERNAL_STORAGE to your AndroidManifest.xml.

Add this line to your AndroidManifest.xml file above and outside your <application> tag.

<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/>

This will allow your application to write to the sdcard. This will help if your EXTERNAL_STORAGE is where you have stored your database on the device.