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 = '2021050701' WHERE keytype = 'dbversion'

BŁĄD:  bieżąca transakcja została przerwana, polecenia ignorowane do końca bloku transakcji