#ERROR (payload): error: column …._uuid does not exist on Server, lovalhost works

3 messages · Page 1 of 1 (latest)

stoic marlin
#

Hi,

I’ve got the problem that on my localhost, the content of my global works fine. As soon as I deploy the CMS to my server, I get the following error:

[15:29:33] ERROR (payload): error: column _landingpage_v_version_Services_serviceCards._uuid does not exist
    at /home/node/app/node_modules/pg/lib/client.js:526:17
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async /home/node/app/node_modules/drizzle-orm/node-postgres/index.cjs:41:28
    at async find (/home/node/app/node_modules/@payloadcms/db-postgres/dist/find/findMany.js:167:21)
    at async findVersions (/home/node/app/node_modules/payload/dist/globals/operations/findVersions.js:47:31)
    at async handler (/home/node/app/node_modules/payload/dist/globals/requestHandlers/findVersions.js:38:28)
  • I am sure, that it’s the same version of the code
  • Both localhost and the server connect to the same database

The issue is, that the entire content of my global is empty, even though it’s populated on dev, and was populated before.

The error suggests that the uuid is missing from a service card, to which a relationship field exists on my global »landingpage«.

When I try to access those Servicecards on my Server, that also works fine. It’s just that global.

When I then try to populate the content, I get the same error again and a »Something went wrong« error in the frontend.

What are steps I can take to fix this?
Thank you all!!

graceful nicheBOT
stoic marlin
#
    "@aws-sdk/client-s3": "^3.429.0",
    "@aws-sdk/lib-storage": "^3.429.0",
    "@payloadcms/bundler-vite": "^0.1.5",
    "@payloadcms/bundler-webpack": "^1.0.0",
    "@payloadcms/db-postgres": "^0.x",
    "@payloadcms/plugin-cloud": "^2.0.0",
    "@payloadcms/plugin-cloud-storage": "^1.1.1",
    "@payloadcms/plugin-seo": "^2.0.0",
    "@payloadcms/richtext-lexical": "^0.1.13",
    "@payloadcms/richtext-slate": "^1.0.0",
    "cross-env": "^7.0.3",
    "dotenv": "^8.2.0",
    "express": "^4.17.1",
    "payload": "^2.0.0"

These are my dependencies