Planetscale - New field with default(uuid) erroring out?

model Server {
***
apikey           String        @unique @default(uuid())
***
}

model Server {
***
apikey           String        @unique @default(uuid())
***
}

model Server {
***
apikey           String        @unique @default(uuid())
***
}

model Server {
***
apikey           String        @unique @default(uuid())
***
}

This is a new addition to my database, I can't seem to sync my planetscale database with this as it errors out, I also tried with

@unique

@unique

@unique

@unique removed and with

cuid()

cuid()

cuid()

cuid().

Field 'apikey' doesn't have a default value (errno 1364) (sqlstate HY000) during query: insert into Server

Field 'apikey' doesn't have a default value (errno 1364) (sqlstate HY000) during query: insert into Server

Field 'apikey' doesn't have a default value (errno 1364) (sqlstate HY000) during query: insert into Server

Field 'apikey' doesn't have a default value (errno 1364) (sqlstate HY000) during query: insert into Server

Googling error with 'planetscale' doesn't help. Thier help support has nothing either.. HELP!

Solution

FIXED!

Terrifying though, unsure if correct.

I updated the database to have the apikey field.

String?

String?

String?

String?.

Then added back the schema to my

dev

dev

branch in preperation.

Manually connected to my

main

main

db, updated existing values with raw SQL

UPDATE Server
SET apikey = UUID()
WHERE apikey IS NULL;

UPDATE Server
SET apikey = UUID()
WHERE apikey IS NULL;

UPDATE Server
SET apikey = UUID()
WHERE apikey IS NULL;

UPDATE Server
SET apikey = UUID()
WHERE apikey IS NULL;

Then synced the

dev

dev

branch. Fixed.

Jump to solution

DebaucusOP•6/21/23, 12:51 AM

-- The following SQL will run for this change
ALTER TABLE `Server` 
  ADD COLUMN `apikey` varchar(191) NOT NULL, 
  ADD UNIQUE KEY `Server_apikey_key` (`apikey`)

-- The following SQL will run for this change
ALTER TABLE `Server` 
  ADD COLUMN `apikey` varchar(191) NOT NULL, 
  ADD UNIQUE KEY `Server_apikey_key` (`apikey`)

This is what planetscale is telling me, but it doesn't have the default value.. why?

DebaucusOP•6/21/23, 12:57 AM

apikey String @unique @default("") apikey String @unique @default("")

This works correctly in the schema

`apikey` varchar(191) NOT NULL DEFAULT '',

`apikey` varchar(191) NOT NULL DEFAULT '',

Solution

Debaucus•6/21/23, 1:51 AM

FIXED!

Terrifying though, unsure if correct.

I updated the database to have the apikey field.

String?

String?

.

Then added back the schema to my

dev

dev

branch in preperation.

Manually connected to my

main

main

db, updated existing values with raw SQL

UPDATE Server
SET apikey = UUID()
WHERE apikey IS NULL;

UPDATE Server
SET apikey = UUID()
WHERE apikey IS NULL;

Then synced the

dev

dev

branch. Fixed.

Planetscale - New field with default(uuid) erroring out?

Similar Threads

Similar Threads

Similar Threads