Jump to content

Topic on Project:Support desk

"Error: 14 unable to open database file"

3
Schiffy (talkcontribs)

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.

88.130.87.163 (talkcontribs)

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.

Schiffy (talkcontribs)

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.

Reply to ""Error: 14 unable to open database file""