ericson Comments - Answer Overflow

ericson

•Created by ericson on 2/22/2025 in #help

Error with Expo Sqlite + Drizzle

now i got this error

Failed to run the query 'CREATE TABLE `plan` (
    `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
    `type` text NOT NULL,
    `title` text NOT NULL,
    `description` text,
    `category` text DEFAULT 'general' NOT NULL,
    `icon` text,
    `estimated_pomodoro` integer DEFAULT 1,
    `completed_pomodoro` integer DEFAULT 0,
    `priority` text DEFAULT 'normal',
    `recurrence` text,
    `deadline` text,
    `created_at` text DEFAULT strftime('%Y-%m-%dT%H:%M:%fZ', 'now') NOT NULL,
    `updated_at` text
);
'

Failed to run the query 'CREATE TABLE `plan` (
    `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
    `type` text NOT NULL,
    `title` text NOT NULL,
    `description` text,
    `category` text DEFAULT 'general' NOT NULL,
    `icon` text,
    `estimated_pomodoro` integer DEFAULT 1,
    `completed_pomodoro` integer DEFAULT 0,
    `priority` text DEFAULT 'normal',
    `recurrence` text,
    `deadline` text,
    `created_at` text DEFAULT strftime('%Y-%m-%dT%H:%M:%fZ', 'now') NOT NULL,
    `updated_at` text
);
'

Any idea?

4 replies

DTDrizzle Team

•Created by ericson on 2/22/2025 in #help

Error with Expo Sqlite + Drizzle

Query:
            CREATE TABLE IF NOT EXISTS "__drizzle_migrations" (
                id SERIAL PRIMARY KEY,
                hash text NOT NULL,
                created_at numeric
            )
 (NOBRIDGE) LOG  Query: SELECT id, hash, created_at FROM "__drizzle_migrations" ORDER BY created_at DESC LIMIT 1
 (NOBRIDGE) LOG  Query: BEGIN
 (NOBRIDGE) LOG  Query: ROLLBACK

Query:
            CREATE TABLE IF NOT EXISTS "__drizzle_migrations" (
                id SERIAL PRIMARY KEY,
                hash text NOT NULL,
                created_at numeric
            )
 (NOBRIDGE) LOG  Query: SELECT id, hash, created_at FROM "__drizzle_migrations" ORDER BY created_at DESC LIMIT 1
 (NOBRIDGE) LOG  Query: BEGIN
 (NOBRIDGE) LOG  Query: ROLLBACK

based on logger

4 replies

DTDrizzle Team

•Created by ericson on 2/22/2025 in #help

Error with Expo Sqlite + Drizzle

ops looks like i need to add the metro config and babel but still having experience an error

SyntaxError: .../drizzle/0000_crazy_prodigy.sql: Missing semicolon. (1:6)

> 1 | CREATE TABLE `plan` (
    |       ^
  2 |     `id` text PRIMARY KEY NOT NULL,
  3 |     `type` text NOT NULL,
  4 |     `title` text NOT NULL,

SyntaxError: .../drizzle/0000_crazy_prodigy.sql: Missing semicolon. (1:6)

> 1 | CREATE TABLE `plan` (
    |       ^
  2 |     `id` text PRIMARY KEY NOT NULL,
  3 |     `type` text NOT NULL,
  4 |     `title` text NOT NULL,

4 replies

Gaming

Programming