Topic on Project:Support desk

Continuation from this thread

Recently, I've been having problems with certain functions on my domain http://grisaiawiki.net When I try to protect, undelete, or move a page, I get errors preventing me from doing so. After enabling the appropriate settings, I now get the following message when trying to do any of these: (this example from trying to protect the Main Page from non-administrators)

---

A database query error has occurred. This may indicate a bug in the software.

Query:

• UPDATE page SET page_restrictions = '' WHERE page_id = '146'
• Function: WikiPage::doUpdateRestrictions
• Error: 14 unable to open database file

---

I still can't figure out why I'm having this issue, or even what's causing it. I've never made any changes to files like DefaultSettings.php or WikiPage.php, nor have I touched anything in /includes/db/. None of my extensions or changes to LocalSettings.php seem to have caused it either, as removing/undoing those changes doesn't help. I'm at a complete loss by this point.

This seems to be an issue with SQLite.

The PDO SQLite driver requires that if you are going to do a write operation (INSERT,UPDATE,DELETE,DROP, etc), then the folder the database resides in must have write permissions, as well as the actual database file.

I found this information in a comment on php.net.

That's what strikes me as odd, because this issue was not happening when I first installed 1.23.3. The most I could have done was create a database and a few tables in my cpanel that ended up not being even connected to the domain. I certainly never removed any permissions from the folder. Checking them, they don't seem to have the public allowed to write to them, but changing this still doesn't stop the problem.