Jump to content

[Solved] how to write to sqlite database?


taotao

Recommended Posts

Here is the error:

 

Django Version: 2.1.4

Exception Type: OperationalError

Exception Value: attempt to write a readonly database

 

The database is sqlite.

 

1) It worked fine locally, but error when deployed to tommy.

2) Changed the sqlite database file permission to 777, got the same error.

 

Please help.

 

Thanks,

jayjay

Edited by taotao
Link to comment
Share on other sites

Here are the settings of file permissions which will work:

 

1. sqlite database file must in public_html folder (why the server put this limitation???)

2. public_html must have group write permission

3 sqlite database file must have both group and world write permission.

 

Even though it is working, but not a safe configuration anyway. 

 

Sqlite3 seems requires the write permission to both database and the holding directory. So if the 1 is lift, it will be safer.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...