Drizzle Team•4mo ago

missing semicolon

I just generated migrations using drizzle-kit for my react native expo app and when attemping to run the migrations, there is an error: iOS Bundling failed 318ms node_modules/expo-router/entry.js (3071 modules) ERROR SyntaxError: /Users/<snip>/WebstormProjects/<snip>/drizzle/0000_hard_shocker.sql: Missing semicolon. (1:6)

> 1 | CREATE TABLE `pictures` (
    |       ^
  2 |     `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  3 |     `task_id` integer NOT NULL,
  4 |     `image_data` blob NOT NULL,

> 1 | CREATE TABLE `pictures` (
    |       ^
  2 |     `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  3 |     `task_id` integer NOT NULL,
  4 |     `image_data` blob NOT NULL,

7 Replies

⚡Z.E.U.S⚡•4mo ago

Hey @dsf_2. Can you confirm that you have completed steps 6 and 7 from the guide? https://orm.drizzle.team/docs/get-started/expo-new#step-6---setup-metro-config

Drizzle ORM - Native SQLite

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

dsf_2OP•4mo ago

Hi @⚡Z.E.U.S⚡ , thanks for responding. I did complete steps 6 and 7 as described, except that I actually misspelled the babel file when I was creating it. So it was bable.config.js instead of babel.config.js. Unfortunately, even after correcting it, the issue still remains

⚡Z.E.U.S⚡•4mo ago

Have you installed babel-plugin-inline-import?

dsf_2OP•4mo ago

yes

dsf_2OP•4mo ago

does it need to be a dependency instead of a devDependency?

⚡Z.E.U.S⚡•4mo ago

Yes

dsf_2OP•4mo ago

ok, i reinstalled it as a normal dependency, did npx expo prebuild --clean to clear all the cache files, rebuilt the app, and i'm still getting the error @⚡Z.E.U.S⚡ it's fixed, i had to run npx expo start -c to clear the bundler cache and now it's working as intended thanks for your assistance

Gaming

Programming

missing semicolon

Did you find this page helpful?