Help for Aimeos

Code: Select all

An exception occurred while executing ' SELECT msupli."id" AS "supplier.lists.id", msupli."parentid" AS "supplier.lists.parentid", msupli."siteid" AS "supplier.lists.siteid", msupli."typeid" AS "supplier.lists.typeid", msupli."domain" AS "supplier.lists.domain", msupli."refid" AS "supplier.lists.refid", msupli."start" AS "supplier.lists.datestart", msupli."end" AS "supplier.lists.dateend", msupli."config" AS "supplier.lists.config", msupli."pos" AS "supplier.lists.position", msupli."status" AS "supplier.lists.status", msupli."mtime" AS "supplier.lists.mtime", msupli."editor" AS "supplier.lists.editor", msupli."ctime" AS "supplier.lists.ctime" FROM "mshop_supplier_list" AS msupli WHERE ( msupli."siteid" IN (1) AND ( msupli."refid" IN ('1') AND msupli."domain" = 'product' AND ( msupli."status" = 1 AND ( msupli."start" <= '2018-09-10 12:15:00' OR msupli."start" IS NULL ) AND ( msupli."end" >= '2018-09-10 12:15:00' OR msupli."end" IS NULL ) ) ) ) GROUP BY msupli."id", msupli."parentid", msupli."siteid", msupli."typeid", msupli."domain", msupli."refid", msupli."start", msupli."end", msupli."config", msupli."pos", msupli."status", msupli."mtime", msupli."editor", msupli."ctime" LIMIT 2147483647 OFFSET 0 ': SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block