Why do I get sqlite error, “unable to open database file”?

Aha, just stumbled across an article explaining this. Also Django have info on their NewbieMistakes page.

The solution is to make sure the directory containing the database file also has write access allowed to the process.

In my case, running this command fixed the problem:

sudo chown www-data .

Related Posts:

  1. How can I upgrade specific packages using pip and a requirements file?
  2. How to switch Python versions in Terminal?
  3. ‘NOT NULL constraint failed’ after adding to models.py
  4. django display message after POST form submit
  5. CommandError: You must set settings.ALLOWED_HOSTS if DEBUG is False
  6. “The path python3 (from –python=python3) does not exist” error
  7. How can I get the file name from request.FILES?
  8. Django – no such table exception
  9. Django TemplateDoesNotExist?
  10. Django – no such table exception
  11. Django: no such table: django_session
  12. Implementing a SOA in Django using celery
  13. Django 1.7 upgrade error: AppRegistryNotReady: Apps aren’t loaded yet
  14. Python/Django: log to console under runserver, log to file under Apache
  15. What is a NoReverseMatch error, and how do I fix it?
  16. sqlite3.OperationalError: unable to open database file
  17. python: can’t open file ‘manage.py’: [Errno 2] No such file or directory
  18. OperationalError: database is locked
  19. What is the use of PYTHONUNBUFFERED in docker file?
  20. Cannot find command ‘git’ – windows
  21. How to revert the last migration?
  22. Output Django queryset as JSON
  23. Getting stuck at Django error: No module named registration
  24. Django __str__ returned non-string (type NoneType)
  25. ow to ‘bulk update’ with Django?
  26. ‘pip’ is not recognized as an internal or external command
  27. File extension .DB – What kind of database is it exactly?
  28. Where does pip install its packages?
  29. Does Python have a toString() equivalent, and can I convert a class to String?
  30. Where does pip install its packages?
  31. django: TypeError: ‘tuple’ object is not callable
  32. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  33. How to use SQLite in Visual Studio 2017?
  34. Can’t fix “zipimport.ZipImportError: can’t decompress data; zlib not available” when I type in “python3.6 get-pip.py”
  35. No module named ‘psycopg2’
  36. Is #include bad practice?
  37. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  38. No module named MySQLdb
  39. No module named MySQLdb
  40. How to check Django version
  41. python3 is not recognized as an internal or external command, operable program or batch file showing for creating django runserver
  42. Django: ImproperlyConfigured: The SECRET_KEY setting must not be empty
  43. is not JSON serializable
  44. Where does Chrome keep the SQLite Database file it writes things like stored passwords to?
  45. Django: ImproperlyConfigured: The SECRET_KEY setting must not be empty
  46. Install mysql-python (Windows)
  47. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  48. django:django.core.exceptions.AppRegistryNotReady: Apps aren’t loaded yet
  49. No module named pkg_resources
  50. Django upgrading to 1.9 error “AppRegistryNotReady: Apps aren’t loaded yet.”
  51. Can’t compare naive and aware datetime.now() <= challenge.datetime_end
  52. How to open .SQLite files
  53. django import error – No module named core.management
  54. Forbidden (403) CSRF verification failed. Request aborted. Even using the {% csrf_token %}
  55. Django 2.1.3 Error: __init__() takes 1 positional argument but 2 were given
  56. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  57. Setting Django up to use MySQL
  58. SQLite – UPSERT *not* INSERT or REPLACE
  59. django:django.core.exceptions.AppRegistryNotReady: Apps aren’t loaded yet
  60. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  61. SQLiteDatabase.query method
  62. OSError – Errno 13 Permission denied
  63. React Error: Target Container is not a DOM Element
  64. Pylint “unresolved import” error in Visual Studio Code
  65. django MultiValueDictKeyError error, how do I deal with it
  66. Exit a SQLite 3 database
  67. Sqlite3, OperationalError: unable to open database file
  68. Print type of variable in python3.5 on django 1.8
  69. Is there a list of Pytz Timezones?
  70. sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 74 supplied
  71. Django – “no module named django.core.management”
  72. “Insert if not exists” statement in SQLite
  73. Error: “dictionary update sequence element #0 has length 1; 2 is required” on Django 1.4
  74. In Django, how do I know the currently logged-in user?
  75. NumPy array is not JSON serializable
  76. How can I add the sqlite3 module to Python?
  77. You are trying to add a non-nullable field ‘new_field’ to userprofile without a default
  78. pip install -r requirements.txt [Errno 2] No such file or directory: ‘requirements.txt’
  79. sqlite3 “foreign key constraint failed”
  80. Error: C2228: left of ” must have class/struct/union
  81. super(type, obj): obj must be an instance or subtype of type
  82. What is difference between SQLite and SQL
  83. java.lang.ClassNotFoundException: org.sqlite.JDBC error in Sample.java program from xerial
  84. Convert MySQL to SQlite [closed]
  85. Django Rest Framework — no module named rest_framework
  86. Error: “dictionary update sequence element #0 has length 1; 2 is required” on Django 1.4
  87. Python Django: You’re using the staticfiles app without having set the STATIC_ROOT setting
  88. TypeError: int() argument must be a string, a bytes-like object or a number, not ‘list’
  89. Django reverse lookup of foreign keys
  90. ImportError: No module named ‘django.core.urlresolvers’
  91. How to fix error “ERROR: Command errored out with exit status 1: python.” when trying to install django-heroku using pip
  92. How to set environment variables in PyCharm?
  93. H14 error in heroku – “no web processes running”
  94. What does this Django regular expression mean? `?P`
  95. Is it better to use path() or url() in urls.py for django 2.0?
  96. Uncaught Reference Error: stLight is not defined (in Chrome only)
  97. SQLite equivalent to ISNULL(), NVL(), IFNULL() or COALESCE()
  98. What is a “slug” in Django?
  99. TemplateDoesNotExist at /
  100. No module named django but it is installed

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)