migrate error | Payload | Page 1

raw viper Dec 20, 2024, 3:38 PM

#

hey
i deleted the searach plugin from the website template. and now if i push to vercel i get this error ERROR: Error running migration 20241220_151850 constraint "payload_locked_documents_rels_search_fk" of relation "payload_locked_documents_rels" does not exist.

i tried to generate a new migration but nothing seems to work

pliant scrollBOT Dec 20, 2024, 3:38 PM

#

New Community-Help Thread Created!

Help is on the way! To mark it as solved, use the /solve command. In the meantime, here are some existing threads that may help you:

Documentation:

pliant trout Dec 20, 2024, 4:13 PM

#

@raw viper
Are you using the laravel?

raw viper Dec 20, 2024, 4:14 PM

#

no using the vercel postgres db

#

seems that i broke my database entirely now 😄

#

i deleted all my migration file for now.

echo geyser Dec 20, 2024, 4:42 PM

#

did you generate a new migration after deleting the search plugin?

#

if not i would expect some db errors to follow since the search plugin creates tables / columns in your db

raw viper Dec 20, 2024, 5:25 PM

#

yes i did but even with a migration file at hand it had erros. trying to test another way

#

maybe switch to a mongodb. good thing that the site is still in development 😂

slow hill Dec 20, 2024, 6:13 PM

#

I broke my db lots during development around the 3.0 launch. The last few versions of payload seem to handle local db schema changes better though, so make sure you're on the latest payload release

#

(sorry I don't have more concrete answers/advice)

#migrate error

Documentation: