Hallo zusammen,
ich bin gerade dabei am Testsystem die Upgrades von der Version 13.0.4 auf die aktuelle 18.0.1 Version durchzuführen.
Bei dem Update über das Setup auf der Weboberfläche hab ich jedoch folgende SQL Error bekommen und bin mir nicht sicher wie ich das am besten lösen kann.
Laut „select schema_name from information_schema.schemata;“ gibt es in der datenbank aktuell kein schema namens dolibarr.
Fehler DB_ERROR_ERROR: 3F000: schema "dolibarr" does not exist LOCATION: get_namespace_oid, namespace.c:3051 (Req 1): CREATE SEQUENCE dolibarr.llx_c_civility_rowid_seq OWNED BY llx_c_civility.rowid;
ERROR: 3F000: schema "dolibarr" does not exist LOCATION: get_namespace_oid, namespace.c:3051
Fehler DB_ERROR_ERROR: 3F000: schema "dolibarr" does not exist LOCATION: get_namespace_oid, namespace.c:3051 (Req 5): CREATE SEQUENCE dolibarr.llx_c_payment_term_rowid_seq OWNED BY llx_c_payment_term.rowid;
ERROR: 3F000: schema "dolibarr" does not exist LOCATION: get_namespace_oid, namespace.c:3051
Fehler DB_ERROR_ERROR: 3F000: schema "dolibarr" does not exist LOCATION: get_namespace_oid, namespace.c:3051 (Req 75): CREATE SEQUENCE dolibarr.llx_c_type_contact_rowid_seq OWNED BY llx_c_type_contact.rowid;
ERROR: 3F000: schema "dolibarr" does not exist LOCATION: get_namespace_oid, namespace.c:3051
Fehler DB_ERROR_23502 (Req 79): insert into llx_c_type_contact(element, source, code, libelle, active ) values ('conferenceorbooth', 'internal', 'MANAGER', 'Conference or Booth manager', 1);
ERROR: 23502: null value in column "rowid" of relation "llx_c_type_contact" violates not-null constraint DETAIL: Failing row contains (null, conferenceorbooth, internal, MANAGER, Conference or Booth manager, 1, null, 0). SCHEMA NAME: public TABLE NAME: llx_c_type_contact COLUMN NAME: rowid LOCATION: ExecConstraints, execMain.c:1947
Fehler DB_ERROR_23502 (Req 80): insert into llx_c_type_contact(element, source, code, libelle, active ) values ('conferenceorbooth', 'external', 'SPEAKER', 'Conference Speaker', 1);
ERROR: 23502: null value in column "rowid" of relation "llx_c_type_contact" violates not-null constraint DETAIL: Failing row contains (null, conferenceorbooth, external, SPEAKER, Conference Speaker, 1, null, 0). SCHEMA NAME: public TABLE NAME: llx_c_type_contact COLUMN NAME: rowid LOCATION: ExecConstraints, execMain.c:1947
Fehler DB_ERROR_23502 (Req 81): insert into llx_c_type_contact(element, source, code, libelle, active ) values ('conferenceorbooth', 'external', 'RESPONSIBLE', 'Booth responsible', 1);
ERROR: 23502: null value in column "rowid" of relation "llx_c_type_contact" violates not-null constraint DETAIL: Failing row contains (null, conferenceorbooth, external, RESPONSIBLE, Booth responsible, 1, null, 0). SCHEMA NAME: public TABLE NAME: llx_c_type_contact COLUMN NAME: rowid LOCATION: ExecConstraints, execMain.c:1947
Vielen Dank schonmal im voraus!
Lg Nicolas