Drizzle Team•3d ago

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

Am getting this error since last 2 days and i literally cant figure out what is wrong there is no any error in any schema and relation defination

TypeError: Cannot read properties of undefined (reading 'referencedTable')
    at normalizeRelation (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/relations.js:212:56)
    at PgDialect.buildRelationalQueryWithoutPK (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/dialect.js:972:36)
    at QueryPromise._getQuery (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:84:25)
    at QueryPromise._toSQL (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:99:24)
    at file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:62:42
    at Object.startActiveSpan (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/tracing.js:8:14)
    at QueryPromise._prepare (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:61:19)
    at file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:108:19
    at Object.startActiveSpan (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/tracing.js:8:14)
    at QueryPromise.execute (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:107:19)

TypeError: Cannot read properties of undefined (reading 'referencedTable')
    at normalizeRelation (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/relations.js:212:56)
    at PgDialect.buildRelationalQueryWithoutPK (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/dialect.js:972:36)
    at QueryPromise._getQuery (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:84:25)
    at QueryPromise._toSQL (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:99:24)
    at file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:62:42
    at Object.startActiveSpan (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/tracing.js:8:14)
    at QueryPromise._prepare (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:61:19)
    at file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:108:19
    at Object.startActiveSpan (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/tracing.js:8:14)
    at QueryPromise.execute (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:107:19)

12 Replies

⚡Z.E.U.S⚡•3d ago

Hey! Can you provide your drizzle schema?

buckwheatOP•3d ago

schema.zip

buckwheatOP•3d ago

new changes was creating role_apps table error message could have been more clearer so that debugging would be easier

⚡Z.E.U.S⚡•3d ago

First, user_app_preference_relations has 3 one relationships with ai_model but ai_model has only one many. You need to add it like this:

export const user_app_preference_relations = relations(user_app_preference, ({ one }) => ({
    app: one(app, {
        fields: [user_app_preference.app_id],
        references: [app.id]
    }),
    profile: one(profile, {
        fields: [user_app_preference.user_id],
        references: [profile.user_id]
    }),
    text_model: one(ai_model, {
        fields: [user_app_preference.text_model_id],
        references: [ai_model.id],
        relationName: 'text_model'
    }),
    image_model: one(ai_model, {
        fields: [user_app_preference.image_model_id],
        references: [ai_model.id],
        relationName: 'image_model'
    }),
    voice_model: one(ai_model, {
        fields: [user_app_preference.voice_model_id],
        references: [ai_model.id],
        relationName: 'voice_model'
    })
}));

export const ai_model_relations = relations(ai_model, ({ many }) => ({
    text_model: many(user_app_preference, {
        relationName: 'text_model'
    }),
    image_model: many(user_app_preference, {
        relationName: 'image_model'
    }),
    voice_model: many(user_app_preference, {
        relationName: 'voice_model'
    }),
    usages: many(usage_log)
}));

export const user_app_preference_relations = relations(user_app_preference, ({ one }) => ({
    app: one(app, {
        fields: [user_app_preference.app_id],
        references: [app.id]
    }),
    profile: one(profile, {
        fields: [user_app_preference.user_id],
        references: [profile.user_id]
    }),
    text_model: one(ai_model, {
        fields: [user_app_preference.text_model_id],
        references: [ai_model.id],
        relationName: 'text_model'
    }),
    image_model: one(ai_model, {
        fields: [user_app_preference.image_model_id],
        references: [ai_model.id],
        relationName: 'image_model'
    }),
    voice_model: one(ai_model, {
        fields: [user_app_preference.voice_model_id],
        references: [ai_model.id],
        relationName: 'voice_model'
    })
}));

export const ai_model_relations = relations(ai_model, ({ many }) => ({
    text_model: many(user_app_preference, {
        relationName: 'text_model'
    }),
    image_model: many(user_app_preference, {
        relationName: 'image_model'
    }),
    voice_model: many(user_app_preference, {
        relationName: 'voice_model'
    }),
    usages: many(usage_log)
}));

Secondly, content_generation_accounts_relations has many scripts but you can't link them so it's probably not needed. The same applies to associated_users in user_roles_relations. After these fixes the studio should start.

buckwheatOP•3d ago

made all the changes still the same

TypeError: Cannot read properties of undefined (reading 'referencedTable')
    at normalizeRelation (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/relations.js:212:56)
    at PgDialect.buildRelationalQueryWithoutPK (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/dialect.js:972:36)
    at QueryPromise._getQuery (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:84:25)
    at QueryPromise._toSQL (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:99:24)
    at file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:62:42
    at Object.startActiveSpan (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/tracing.js:8:14)
    at QueryPromise._prepare (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:61:19)
    at file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:108:19
    at Object.startActiveSpan (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/tracing.js:8:14)
    at QueryPromise.execute (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:107:19)

TypeError: Cannot read properties of undefined (reading 'referencedTable')
    at normalizeRelation (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/relations.js:212:56)
    at PgDialect.buildRelationalQueryWithoutPK (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/dialect.js:972:36)
    at QueryPromise._getQuery (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:84:25)
    at QueryPromise._toSQL (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:99:24)
    at file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:62:42
    at Object.startActiveSpan (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/tracing.js:8:14)
    at QueryPromise._prepare (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:61:19)
    at file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:108:19
    at Object.startActiveSpan (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/tracing.js:8:14)
    at QueryPromise.execute (file:///Users/nirajkafle/Desktop/niraj/work-projects/appcafe/FunApps.ai/node_modules/drizzle-orm/pg-core/query-builders/query.js:107:19)