Drizzle Team•11mo ago

SQLite error: no such table: main.__old_push_users

I am currently trying to build a blog in sveltekit using lucia auth as the auth provider. I just can't create any user because I always get this error:

code: 'SQLITE_UNKNOWN',
  rawCode: undefined,
  [cause]: [ResponseError: SQLite error: no such table: main.__old_push_users] {
    code: 'SQLITE_UNKNOWN',
    proto: {
      message: 'SQLite error: no such table: main.__old_push_users',
      code: 'SQLITE_UNKNOWN'
    }
  }
}

code: 'SQLITE_UNKNOWN',
  rawCode: undefined,
  [cause]: [ResponseError: SQLite error: no such table: main.__old_push_users] {
    code: 'SQLITE_UNKNOWN',
    proto: {
      message: 'SQLite error: no such table: main.__old_push_users',
      code: 'SQLITE_UNKNOWN'
    }
  }
}

I can give additional information to this, but help pls

3 Replies

NevTheRealOP•11mo ago

This is the repo: https://github.com/nevthereal/codoodle

GitHub

GitHub - nevthereal/codoodle: A SvelteKit blog with Turso

A SvelteKit blog with Turso. Contribute to nevthereal/codoodle development by creating an account on GitHub.

Mykhailo•8mo ago

Hello, @NevTheReal ! Were you able to resolve this issue? Unfortunately, I can't replicate it, but it's essential to know the solution.

NevTheRealOP•8mo ago

Not really. I just deleted the db since it was in dev anyway. I found that a migrate script helps though

Gaming

Programming

SQLite error: no such table: main.__old_push_users