T3 App type error

Hi guys, I just tried creating a new t3 app and I selected next-auth and drizzle. How can I fix this type error? TIA

Type 'PgTableWithColumns<{ name: "user"; schema: undefined; columns: { id: PgColumn<{ name: "id"; tableName: "user"; dataType: "string"; columnType: "PgVarchar"; data: string; driverParam: string; notNull: true; hasDefault: true; enumValues: [...]; baseColumn: never; }, {}, {}>; name: PgColumn<...>; email: PgColumn<...>; ...' is not assignable to type 'DefaultPostgresUsersTable'.
Type 'PgTableWithColumns<{ name: "user"; schema: undefined; columns: { id: PgColumn<{ name: "id"; tableName: "user"; dataType: "string"; columnType: "PgVarchar"; data: string; driverParam: string; notNull: true; hasDefault: true; enumValues: [...]; baseColumn: never; }, {}, {}>; name: PgColumn<...>; email: PgColumn<...>; ...' is not assignable to type 'PgTable<{ name: string; columns: { id: DefaultPostgresColumn<{ columnType: "PgVarchar" | "PgText" | "PgUUID"; isPrimaryKey: true; data: string; notNull: true; dataType: "string"; }>; name: DefaultPostgresColumn<...>; email: DefaultPostgresColumn<...>; emailVerified: DefaultPostgresColumn<...>; image: DefaultPostgres...'.
The types of '_.config.columns.id' are incompatible between these types.
Type 'PgColumn<{ name: "id"; tableName: "user"; dataType: "string"; columnType: "PgVarchar"; data: string; driverParam: string; notNull: true; hasDefault: true; enumValues: [string, ...string[]]; baseColumn: never; }, {}, {}>' is not assignable to type 'DefaultPostgresColumn<{ columnType: "PgVarchar" | "PgText" | "PgUUID"; isPrimaryKey: true; data: string; notNull: true; dataType: "string"; }>'.

Solution

nah, wans't really referring to t3 hahahaa. Its just an expression out of frustration. I did some research and I think my problem isn't caused by t3 at all, its because of the adapter just not having the right type.

Jump to solution

JulieCezar•7/30/24, 12:55 PM

How did you create the tables? Did you choose the right PG lib from Drizzle for creating tables?

Sidarth•7/30/24, 2:02 PM

Even I'm facing the same error. Used the exact adapter that is given in next auth documentation. By the way I did not even edit anything from the scaffolded code

JulieCezar•7/30/24, 4:42 PM

Idk if you are using the t3 template... If not, if you set it up through the CLI you will see a working solution

Sidarth•7/31/24, 1:08 AM

I set it with the CLI and nothing more

JustCodeItAll•7/31/24, 1:55 AM

I think this is the same error I’m having as well

JJulieCezar How did you create the tables? Did you choose the right PG lib from Drizzle for ...

SalumsuOP•7/31/24, 2:00 AM

haven't touched anything, its the default t3 app with next auth and drizzle

JJulieCezar Idk if you are using the t3 template... If not, if you set it up through the CLI...

SalumsuOP•7/31/24, 2:01 AM

I did use it

SSidarth I set it with the CLI and nothing more

SalumsuOP•7/31/24, 2:01 AM

same dude, I have no idea how to fix it

JustCodeItAll•7/31/24, 2:09 AM

I created the secret key, from the command it gives about the db url, it took other errors away. But still don’t login using discord

SalumsuOP•7/31/24, 2:26 AM

how did you do that?

SalumsuOP•7/31/24, 2:26 AM

have you added the client id and secret id?

SalumsuOP•7/31/24, 3:01 AM

I mean, how do you even use next auth properly? the setup in t3 app is different compared to what I'm used to.. the NextAuth is returning any, how do I get the handlers, signIn, signOut, etc.?

SalumsuOP•7/31/24, 3:01 AM

Can someone please teach me

JustCodeItAll•7/31/24, 3:06 AM

The T3app command, has a command for the db to run in the terminal, it creates a key to paste in

SalumsuOP•7/31/24, 6:21 AM

are you talking about the ?

SalumsuOP•7/31/24, 6:22 AM

The tables are declared like this

SalumsuOP•7/31/24, 6:22 AM

but even when I change it to pgTable, the error doesn't go away

JustCodeItAll•7/31/24, 12:00 PM

Yes

JustCodeItAll•7/31/24, 12:01 PM

Mine is erroring that “user” isn’t found

SalumsuOP•8/1/24, 3:44 AM

This sucks dude haahahha

JustCodeItAll•8/1/24, 2:40 PM

T3? I’ve pretty much abandoned it

Solution

Salumsu•8/3/24, 3:13 AM

SalumsuOP•8/3/24, 4:23 AM

Github issue: https://github.com/nextauthjs/next-auth/issues/11490?fbclid=IwZXh0bgNhZW0CMTEAAR0xoVNiHaH5QqQbKdl6Ntkc0dGxan6BO4368E1T7lmVunLAk3I4FIDFFSc_aem_43f3szrXH8MdLjQNRoFXhw

GitHub

Drizzle Adapter Postgres Broken – The types of _.config.columns.id ...

Adapter type @auth/drizzle-adapter Environment System: OS: macOS 14.5 CPU: (12) arm64 Apple M2 Max Memory: 3.54 GB / 64.00 GB Shell: 5.9 - /bin/zsh Binaries: Node: 18.17.1 - ~/.nvm/versions/node/v1...

Bloo•8/26/24, 1:20 PM

So I'm finding myself caught up in this I tried implementing the roll back as a fix but I'm still getting the error....