apollographql / apollographql/fullstack-tutorial

Login exception INTERNAL_SERVER_ERROR

Open
#139 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
TypeScript
Stars
1.2k
Forks
808
PR merge metrics
No merged PRs in 30d

Description

When performing the first login I receive this error:
```
"SQLITE_ERROR: no such table: users",
```
The sqlite db is there and I can read from it with an sql tool. I've also verified that the table `users` is available.

The location of this file is in `server/store.sqlite` but somehow when I run my server it gets copied to the root folder (whic part of the logic does this, maybe sequelize?)

I can read from `src/utils` that `storage: './store.sqlite',` so I guess the db should be located inside the `server/src` directory, but even copying it manually inside `src` doesn't fix the problem.

Maybe I've missed a step somehow?

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by tracing the SQLite storage configuration in src/utils and how server/store.sqlite is resolved or copied when the server starts. Verify which database file the running server opens and compare it with the file containing the users table; done means the first login no longer reports SQLITE_ERROR: no such table: users.

Written by the indexing model from the issue text.

Assessment

Tech stack
sqlite, typescript
Domain
authentication, backend, database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.