CodeForPhilly / CodeForPhilly/CHIME-2

Windows on flask db migrate: (sqlite3.OperationalError) unable to open database file

Offen
#20 0 Kommentare 1 Reaktion 1 zugewiesene Person Beansprucht von @BrianThomasRoss Auf GitHub ansehen
flask
Vorherrschende Sprache
Python
Sterne
2
Forks
4
PR-Merge-Kennzahlen
Keine gemergten PRs in 30 T.

Beschreibung

### Problem

Trying to build the app on Windows 10.

After creating a `.env` file from `.env.example`, I tried to initialize the project from the command line like so:

```
pip install -r requirements/dev.txt
npm install
for /f "tokens=*" %i in (.env) do set %i
flask db init
flask db migrate -m "initial"
```

At the `migrate` line, there is a long stack trace, and then this error (even when running the prompt as Administrator):

```
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
(Background on this error at: http://sqlalche.me/e/13/e3q8)
```

### Proposed Solution

Changing the value of `DATABASE_URL` in `.env` from the example default `sqlite:////tmp/dev.db` to a path I knew I had write access to (in my case, the project directory itself: `sqlite:///C:\\Users\\\\chime2\\dev.db`) fixed the issue.

Because the example path assumes a Linux filesystem, can a note be made, maybe in the README, that the value would need to be changed prior to building?

Beitragsleitfaden

Beitragsleitfaden öffnen

Bewertung

Dieses Issue wurde noch nicht bewertet.

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.