sqlite3.OperationalError: unable to open database file

Question

I am new in Django. I got the following error while working with it.
I am not able to solve it yet.
Can anyone tell me what needs to be done?

sqlite3.OperationalError: unable to open database file

linuxeasy · Accepted Answer · 2012-03-06 11:59:20Z

1

The error says it all. Do you have your sqlite DB file in place? is it being referred rightly? You need to create/correct your sqlite DB file, so that your framework can find and load it correctly!

answered Mar 6, 2012 at 11:59

linuxeasy

6,4997 gold badges35 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

sam Over a year ago

database already present.DATABASES = { 'default': { 'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': 'bdu-celery', 'USER': 'django', 'PASSWORD': 'hello' } }

linuxeasy Over a year ago

@sam: The config you have put is of PostGre, but your framework seems to be using sqlite. You need to check in your framework, where at all is it referring sqlite config.

Kristin Gannon · Accepted Answer · 2012-12-09 22:24:44Z

1

I'm a beginner, too, and had a similar problem. The .db file will created for you when you run python manage.py syncdb. From your terminal window, just be sure that you're located in the same folder as the manage.py file in your directory structure. From this location, I was able to successfully create the necessary tables. The settings.py file will have already been created when you initially set the project up.

edited Dec 9, 2012 at 22:24

answered Dec 9, 2012 at 20:20

Kristin Gannon

991 silver badge4 bronze badges

Comments

Graham Klyne · Accepted Answer · 2013-07-22 13:16:31Z

1

It appears that python manage.py syncdb will create the database file, but requires the directory used to already exist.

answered Jul 22, 2013 at 13:16

Graham Klyne

84610 silver badges16 bronze badges

Comments

Codebender · Accepted Answer · 2019-01-12 09:28:04Z

1

I had a similar problem at sometime. Error: sqlite3.OperationalError: unable to open database file and yet my settings.py pointed to a postgres database. It was just a mistake, I had moved my project directory which previously used sqlite. The new one(moved) used postgres but my uwsgi server still pointed to the old project directory.

If you are using more than one server in my case was using nginx and uwsgi, it's a good idea check both config files.

answered Jan 12, 2019 at 9:28

Codebender

3153 silver badges11 bronze badges

Comments

Ramandeep Singh · Accepted Answer · 2012-03-06 12:05:55Z

0

Make a File "settings.py" in the folder where your "manage.py" is there..

In the settings.py , change the following settings :

DATABASE_ENGINE = 'sqlite3'           # 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'.
DATABASE_NAME = '[your_database_name]'             # Or path to database file if using sqlite3.
DATABASE_USER = ''             # Not used with sqlite3.
DATABASE_PASSWORD = ''         # Not used with sqlite3.

N you are good to go..!!

Note : your database file will stored in your project folder.

answered Mar 6, 2012 at 12:05

Ramandeep Singh

5,2833 gold badges31 silver badges34 bronze badges

2 Comments

sam Over a year ago

already I have written as DATABASES = { 'default': { 'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': 'bdu-celery', 'USER': 'django', 'PASSWORD': 'hello' } }

Ramandeep Singh Over a year ago

I dont know what you are doing...Configuration says "u are using postgresql"...but error saying "u are using SQLITE" ..i am not able to help by just seeing the question...please post detailed Error Info..!!

Collectives™ on Stack Overflow

sqlite3.OperationalError: unable to open database file

5 Answers 5

2 Comments

Comments

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related