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,

> 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,

⚡

⚡Z.E.U.S⚡•7/2/25, 10:07 AM

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•7/2/25, 1:21 PM

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.jsbable.config.js instead of babel.config.jsbabel.config.js.

Unfortunately, even after correcting it, the issue still remains

Ddsf_2 Hi @⚡Z.E.U.S⚡ , thanks for responding. I did complete steps 6 and 7 as describe...

⚡

⚡Z.E.U.S⚡•7/2/25, 1:29 PM

Have you installed babel-plugin-inline-importbabel-plugin-inline-import?

⚡⚡Z.E.U.S⚡Have you installed `babel-plugin-inline-import`?

dsf_2OP•7/2/25, 1:29 PM

yes

dsf_2OP•7/2/25, 1:31 PM

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

⚡

⚡Z.E.U.S⚡•7/2/25, 1:32 PM

Yes

⚡⚡Z.E.U.S⚡Yes

dsf_2OP•7/2/25, 1:40 PM

ok, i reinstalled it as a normal dependency, did npx expo prebuild --cleannpx expo prebuild --clean to clear all the cache files, rebuilt the app, and i'm still getting the error

dsf_2OP•7/2/25, 1:45 PM

Z.E.U.S

it's fixed, i had to run npx expo start -cnpx expo start -c to clear the bundler cache and now it's working as intended

dsf_2OP•7/2/25, 1:45 PM

thanks for your assistance

missing semicolon

Similar Threads

Similar Threads

Similar Threads