Drizzle TeamDT
Drizzle Team•2y ago
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,


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?
Was this page helpful?