Witam Mamy błąd przy aktualizacji z wersji 26 na 27 przy uruchomieniu upgradedb.php wyskakuje błąd SQL:
DB schema upgrade errors:
ALTER TABLE customerassignments ADD COLUMN startdate integer DEFAULT EXTRACT(EPOCH FROM CURRENT_TIMESTAMP(0))::integer; ALTER TABLE customerassignments ADD COLUMN enddate integer DEFAULT 0 NOT NULL; CREATE INDEX customerassignments_startdate_idx ON customerassignments (startdate); CREATE INDEX customerassignments_enddate_idx ON customerassignments (enddate); ALTER TABLE customerassignments DROP CONSTRAINT customerassignments_customergroupid_key; ALTER TABLE customerassignments ADD CONSTRAINT customerassignments_customergroupid_ukey UNIQUE (customergroupid, customerid, enddate); CREATE VIEW vcustomerassignments AS SELECT ca.* FROM customerassignments ca WHERE (startdate IS NULL OR startdate <= EXTRACT(EPOCH FROM CURRENT_TIMESTAMP(0))::integer) AND (enddate = 0 OR enddate > EXTRACT(EPOCH FROM CURRENT_TIMESTAMP(0))::integer); DROP VIEW customerview; CREATE VIEW customerview AS SELECT c.*, cc.consentdate AS consentdate, cc.invoicenotice AS invoicenotice, cc.mailingnotice AS mailingnotice, cc.smsnotice AS smsnotice, cc.einvoice AS einvoice, a1.country_id as countryid, a1.ccode, a1.zip as zip, a1.city as city, a1.street as street,a1.house as building, a1.flat as apartment, a2.country_id as post_countryid, a2.ccode AS post_ccode, a2.zip as post_zip, a2.city as post_city, a2.street as post_street, a2.name as post_name, a2.house as post_building, a2.flat as post_apartment, a1.address as address, a1.location AS full_address, a1.postoffice AS postoffice, a2.address as post_address, a2.location AS post_full_address, a2.postoffice AS post_postoffice FROM customers c JOIN customer_addresses ca1 ON c.id = ca1.customer_id AND ca1.type = 1 LEFT JOIN vaddresses a1 ON ca1.address_id = a1.id LEFT JOIN customer_addresses ca2 ON c.id = ca2.customer_id AND ca2.type = 0 LEFT JOIN vaddresses a2 ON ca2.address_id = a2.id LEFT JOIN customerconsentview cc ON cc.customerid = c.id WHERE NOT EXISTS ( SELECT 1 FROM vcustomerassignments a JOIN excludedgroups e ON (a.customergroupid = e.customergroupid) WHERE e.userid = lms_current_user() AND a.customerid = c.id) AND (lms_current_user() = 0 OR c.divisionid IN ( SELECT ud.divisionid FROM userdivisions ud WHERE ud.userid = lms_current_user())) AND c.type < 2; UPDATE customerassignments SET startdate = NULL
BŁĄD: ograniczenie "customerassignments_customergroupid_key" relacji "customerassignments" nie istnieje UPDATE dbinfo SET keyvalue = ' [ callto:2021050701 | 2021050701 ] ' WHERE keytype = 'dbversion' BŁĄD: bieżąca transakcja została przerwana, polecenia ignorowane do końca bloku transakcji
Proszę o pomoc.
