autumnstwilight Posts - Answer Overflow

autumnstwilight

•Created by autumnstwilight on 4/12/2024 in #help

Sqlite syntax error when calling useMigrations in react-native expo app

Hello, I'm currently trying to set up a React Native app and having some problems with useMigrations. The error is complaining about the syntax but it looks fine to me:

error: SyntaxError: /root/coding/kutuba-app/drizzle/0000_stale_natasha_romanoff.sql: Missing semicolon. (1:6)

> 1 | CREATE TABLE `LESSONS` (
    |       ^
  2 |   `ID` integer PRIMARY KEY NOT NULL,
  3 |   `LESSON_NUM` integer,
  4 |   `TITLE` text,

error: SyntaxError: /root/coding/kutuba-app/drizzle/0000_stale_natasha_romanoff.sql: Missing semicolon. (1:6)

> 1 | CREATE TABLE `LESSONS` (
    |       ^
  2 |   `ID` integer PRIMARY KEY NOT NULL,
  3 |   `LESSON_NUM` integer,
  4 |   `TITLE` text,

The full SQL is here: https://github.com/plutoniumcat/kutuba-app/blob/drizzle-problem/drizzle/0000_stale_natasha_romanoff.sql Here's the part of my code that calls useMigrations: https://github.com/plutoniumcat/kutuba-app/blob/drizzle-problem/src/database/DatabaseInitialization.ts I've looked through the discord for similar issues, and added breakpoints: true to drizzle.config, but unfortunately that didn't help. (I also tried it with breakpoints: false just to check and got the same error). Any suggestions on what to try next?

6 replies

Gaming

Programming