object(QueryException)#10 (7) { ["message":protected]=> string(166) "QueryException : ERROR: invalid input syntax for integer: "" LINE 6: AND "CODE_POSTAL"='' LIMIT 1) AND cat3."URL" = 'FOURNIT... ^" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(0) ["file":protected]=> string(90) "/var/www/vhosts/www.atoupro.com/system/application/includes/classes/database/Connexion.php" ["line":protected]=> int(240) ["trace":"Exception":private]=> array(3) { [0]=> array(6) { ["file"]=> string(84) "/var/www/vhosts/www.atoupro.com/system/application/includes/classes/pro/Campaign.php" ["line"]=> int(269) ["function"]=> string(8) "queryAll" ["class"]=> string(9) "Connexion" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(673) "SELECT campaign."ID_CAMPAIGN",product."CREDIT"-campaign."COUNT_DISPLAYS" AS display_left FROM "TIP_CAMPAIGNS" campaign JOIN "TC_PRODUCT" product ON(campaign."ID_PRODUCT"=product."ID_PROD") JOIN "TIP_CAMPAIGNS_CAT1" cat1 USING("ID_CAMPAIGN") JOIN "TIP_CAMPAIGNS_DEP" USING("ID_CAMPAIGN") JOIN "TR_CATEGORY2" cat2 USING("ID_CAT1") JOIN "TR_CATEGORY3" cat3 USING("ID_CAT2") WHERE "ID_DEP" IN (SELECT "ID_DEP" FROM "TR_COMMUNE" WHERE ( trim("ART_ER"|| ' ' || "NAME_ER")='' OR "NAME_ER"='' ) AND "CODE_POSTAL"='' LIMIT 1) AND cat3."URL" = 'FOURNITURES-MATERIEL-INDUSTRIELS' AND "STATE"='active' AND "COUNT_DISPLAYS"<"CREDIT" ORDER BY random() DESC;" } } [1]=> array(6) { ["file"]=> string(60) "/var/www/vhosts/www.atoupro.com/system/headers/pro/sheet.php" ["line"]=> int(26) ["function"]=> string(25) "getCommercialsFromLGAndLC" ["class"]=> string(8) "Campaign" ["type"]=> string(2) "::" ["args"]=> array(2) { [0]=> array(3) { ["cp_comm"]=> NULL ["name_comm"]=> NULL ["deep"]=> int(3) } [1]=> array(2) { ["url"]=> string(32) "FOURNITURES-MATERIEL-INDUSTRIELS" ["deep"]=> int(3) } } } [2]=> array(4) { ["file"]=> string(41) "/var/www/vhosts/www.atoupro.com/index.php" ["line"]=> int(55) ["args"]=> array(1) { [0]=> string(60) "/var/www/vhosts/www.atoupro.com/system/headers/pro/sheet.php" } ["function"]=> string(12) "require_once" } } ["previous":"Exception":private]=> NULL }