stan
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
There's no github issue about it, later I'm going to create one, I suggest you do the same so that they may fix it
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
XD! cReAtE A nEw oNe
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
And worst, did it loose it?
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
But why was it looking for it?
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
It was trying to use the main.__old_push_users table, that I guess is the name of the users table from before the push
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
But it does not make any sense for me
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
I did exactly the same
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
You can see it says old_push_users doesn't exist because it's related to the push migration I did
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
My full error looks like this: LibsqlError: SQLITE_UNKNOWN: SQLite error: no such table: main.old_push_users
at mapHranaError (/home/stan/project-rusilla-nstc/node_modules/.pnpm/@[email protected]/node_modules/@libsql/client/lib-cjs/hrana.js:287:16)
at HttpClient.execute (/home/stan/project-rusilla-nstc/node_modules/.pnpm/@[email protected]/node_modules/@libsql/client/lib-cjs/http.js:84:48)
at processTicksAndRejections (node:internal/process/task_queues:95:5)
at async PreparedQuery.all (/home/stan/project-rusilla-nstc/nodemodules/.pnpm/[email protected]@[email protected][email protected]/node_modules/src/libsql/session.ts:223:16)
at async /home/stan/project-rusilla-nstc/src/routes/storeRoutes.ts:38:22 {
code: 'SQLITE_UNKNOWN',
[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'
}
}
}
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
I think the problem was specifically related to the stores table and the migration a made to it
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
Because I ran this one and it worked seamlessly: const newUser = await db.insert(users).values(user).returning();
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
And it makes no sense for me
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
The problem came when I was trying to run this code const newStore = await db.insert(stores).values(store).returning();
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
For me I wasn't using Lucia auth, I made my own auth with jwt and passportjs and it was working fine
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
But I fear it may happen in production and to say that it would be bad is an understatement haha
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
I did the same and is now working
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
The problem started after I made a migration
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
Not at all, I'm not in production, so I just changed the db and now it's working
77 replies
DTDrizzle Team
•Created by louis on 10/2/2023 in #help
No such table: main.__old_push_[TABLENAME]
Did you solve this?
77 replies