Hey all, I'm trying to set up Prisma in an existing project (current just for database migrations). When running

npx prisma migrate dev

, I get an error:

Database error code: 1118

Database error:
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead,
check the manual. You have to change some columns to TEXT or BLOBs

Please check the query number 235 from the migration file.

I'm not sure why this would be in issue since the schema was generated from prisma's introspection command. Even worse. I don't know how to find query number

235

since they aren't numbered in the migration's

.sql

file. Can anyone point me in the right direction? Thanks

Hi Richard! So for the query number 

235

Unfortunately it’s the only info that we can give here you will need to count manually in the migration.sql file to find it. Maybe counting the 

;

 character could help here because each statement finish with it. About the error, are you using MySQL (which version?)

@Richard Dunlap 👋 It would be great if you could create an issue here with all info and the sql query. We would like to look into this 🙂

Thanks! I'm still looking into this. Need to do a few things to get my local db back into the correct state, first