插入过程中出现 SQLite 错误“尝试写入只读数据库"?

2021-12-08 00:00:00 permissions sqlite

我有一个用于网站的 SQLite 数据库.问题是当我尝试 INSERT INTO 它时，我得到一个 PDOException

I have a SQLite database that I am using for a website. The problem is that when I try to INSERT INTO it, I get a PDOException

SQLSTATE[HY000]: General error: 8 attempt to write a readonly database

我通过 SSH 连接到服务器并检查权限，并且数据库具有权限

I SSH'd into the server and checked permissions, and the database has the permissions

-rw-rw-r--

我不太熟悉 *nix 权限，但我很确定这意味着

I'm not that familiar with *nix permissions, but I'm pretty sure this means

  • 不是目录
  • 所有者具有读/写权限(根据 ls -l，就是我)
  • 组具有读/写权限
  • 其他人只有读取权限

我还查看了所有我知道使用 sqlite3 程序的地方，但没有发现任何相关内容.

I also looked everywhere I knew to using the sqlite3 program, and found nothing relevant.

因为我不知道 PDO 试图以什么权限打开数据库，所以我知道

Because I didn't know with what permissions PDO is trying to open the database, I did

chmod o+w supplies.db

现在，我得到另一个PDOException:

SQLSTATE[HY000]: General error: 14 unable to open database file

但它仅在我尝试在数据库打开后执行INSERT查询时发生.

But it ONLY occurs when I try to execute an INSERT query after the database is open.

对正在发生的事情有什么想法吗?

推荐答案

事实证明，问题在于 PDO SQLite 驱动程序要求如果您要执行写操作(INSERT、UPDATE、DELETE、DROP等)，那么数据库所在的文件夹必须有写权限，以及实际的数据库文件.

The problem, as it turns out, is that 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.

我在位于PDO SQLite 驱动程序手册页.

I found this information in a comment at the very bottom of the PDO SQLite driver manual page.

相关文章