[30-Jul-2012 12:59:57] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2))>0) OR (productRestrictions='producttypes' AND productCondition='1' AND (SELE' at line 3 (SELECT * FROM tl_iso_rules r WHERE type='cart' AND enableCode='' AND enabled='1' AND (startDate='' OR FROM_UNIXTIME(startDate,GET_FORMAT(DATE,'INTERNAL' )) <= FROM_UNIXTIME(UNIX_TIMESTAMP(),GET_FORMAT(DATE,'IN TERNAL'))) AND (endDate='' OR FROM_UNIXTIME(endDate,GET_FORMAT(DATE,'INTERNAL')) >= FROM_UNIXTIME(UNIX_TIMESTAMP(),GET_FORMAT(DATE,'IN TERNAL'))) AND (startTime='' OR FROM_UNIXTIME(startTime,GET_FORMAT(TIME,'INTERNAL' )) <= FROM_UNIXTIME(UNIX_TIMESTAMP(),GET_FORMAT(TIME,'IN TERNAL'))) AND (endTime='' OR FROM_UNIXTIME(endTime,GET_FORMAT(TIME,'INTERNAL')) >= FROM_UNIXTIME(UNIX_TIMESTAMP(),GET_FORMAT(TIME,'IN TERNAL'))) AND (limitPerConfig=0 OR limitPerConfig>(SELECT COUNT(*) FROM tl_iso_rule_usage WHERE pid=r.id AND config_id=1 AND order_id NOT IN (SELECT id FROM tl_iso_orders WHERE cart_id=3))) AND (configRestrictions=''
OR (configRestrictions='1' AND configCondition='' AND (SELECT COUNT(*) FROM tl_iso_rule_restrictions WHERE pid=r.id AND type='configs' AND object_id=1)>0)
OR (configRestrictions='1' AND configCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restrictions WHERE pid=r.id AND type='configs' AND object_id=1)=0)) AND (memberRestrictions='none' OR (memberRestrictions='guests' AND memberCondition='')) AND (productRestrictions='none' OR (productRestrictions='producttypes' AND productCondition='' AND (SELECT COUNT(*) FROM tl_iso_rule_restrictions WHERE pid=r.id AND type='producttypes' AND object_id IN (,2))>0) OR (productRestrictions='producttypes' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restrictions WHERE pid=r.id AND type='producttypes' AND object_id IN (,2))=0) OR (productRestrictions='products' AND productCondition='' AND (SELECT COUNT(*) FROM tl_iso_rule_restrictions WHERE pid=r.id AND type='products' AND object_id IN (1,4))>0) OR (productRestrictions='products' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restrictions WHERE pid=r.id AND type='products' AND object_id IN (1,4))=0) OR (productRestrictions='variants' AND productCondition='' AND (SELECT COUNT(*) FROM tl_iso_rule_restrictions WHERE pid=r.id AND type='variants' AND object_id IN (1,4))>0) OR (productRestrictions='variants' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restrictions WHERE pid=r.id AND type='variants' AND object_id IN (1,4))=0) OR (productRestrictions='pages' AND productCondition='' AND (SELECT COUNT(*) FROM tl_iso_rule_restrictions WHERE pid=r.id AND type='pages' AND object_id IN (SELECT page_id FROM tl_iso_product_categories WHERE pid IN (1,4)))>0) OR (productRestrictions='pages' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restrictions WHERE pid=r.id AND type='pages' AND object_id IN (SELECT page_id FROM tl_iso_product_categories WHERE pid IN (1,4)))=0)) ORDER BY sorting)' thrown in /html/fdt/system/libraries/Database.php on line 686
Lesezeichen