6 replies

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

breakpoints: true

to drizzle.config, but unfortunately that didn't help. (I also tried it with

breakpoints: false

breakpoints: false

just to check and got the same error). Any suggestions on what to try next?

Drizzle Team•2y ago•

6 replies

autumnstwilight

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,

breakpoints: true

breakpoints: true

to drizzle.config, but unfortunately that didn't help. (I also tried it with

breakpoints: false

breakpoints: false

just to check and got the same error). Any suggestions on what to try next?

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

Similar Threads

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

Similar Threads

Similar Threads

Similar Threads