Create table "strapi_ee_store_settings" ("id" serial primary key, "key" varchar(255) null, "value" text null) - relation "strapi_ee_store_settings" already exists

Questions and Answers
, ,
1
System Information
  • **Strapi Version4.6:
  • **Operating SystemUbuntu 18.04:
  • **DatabasePostgreSql:
  • **Node Versionv17.9.1:
  • **NPM Version8.11.0:
  • **Yarn Version1.22.19:

I haven’t changed anything since the last deployment and on launching today it shows
create table “strapi_ee_store_settings” (“id” serial primary key, “key” varchar(255) null, “value” text null) - relation
“strapi_ee_store_settings” already exists. The server returns null on a lot of collections and the data seems to be null. The server can’t start either so am stuck and this is a production server. Any assistance?