[BUG]: TypeError: Cannot read properties of undefined (reading 'primaryKey') about drizzle-orm

[matannahmani]

hey please don't close this, this is a huge problem.

[chocokrizpis]

I am experiencing the same error.

[vladisavage]

Same error, please reopen!

[mrwokkel]

I am having the same issue:
drizzle-kit 0.24.2
drizzle-orm 0.33.0

[vincent-thomas]

Same problem!

[AndriiSherman]

This should be fixed in [email protected]. If the issue persists, feel free to reopen it!

[evanlong0803]

Hi, @AndriiSherman

When I executed pnpm db:push, it prompted me:

TypeError: Cannot read properties of undefined (reading 'primaryKey')

But in fact, I just deleted a field. I deleted the embedding field.

export const products = sqliteTable('products', {
  id: text('id')
    .$default(() => createId())
    .primaryKey(),
  ...
  embedding: blob('embedding', { mode: 'buffer' }),
  ...
})

drizzle-kit -> 0.24.2
drizzle-orm -> 0.33.0

[tinsever]

Same error!

[tinsever]

Hi, @AndriiSherman

When I executed pnpm db:push, it prompted me:

TypeError: Cannot read properties of undefined (reading 'primaryKey')

But in fact, I just deleted a field. I deleted the embedding field.

export const products = sqliteTable('products', {
  id: text('id')
    .$default(() => createId())
    .primaryKey(),
  ...
  embedding: blob('embedding', { mode: 'buffer' }),
  ...
})

drizzle-kit -> 0.24.2 drizzle-orm -> 0.33.0

Hi, @evanlong0803

I removed the column inside my SQLite using SQLiteStudio. Then I pushed it again and it worked. I mean it's not ideal but yeah.