Hallo zusammen,
unter Bestellungen sind ja nun zwei neue icons mit den Links zu payment und shipping dazugekommen!
Was haben diese icons für eine Funktion? Bei mir kommt beim Klick auf beide der jeweilige Fehler:
Shipping module not found!
Payment module not found!
Beim Klick auf das Icon Tools und dort auf Print invoices kommt nach der Auswahl eines Statuses die Fehlermeldung:
Code:
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 ')) AND (configRestrictions='' OR (configRestrictions='1' AND (SELECT COUNT(*) FR' at line 1 (SELECT * FROM tl_iso_rules r WHERE type='product' AND enabled='1' AND archive<2 AND (startDate='' OR FROM_UNIXTIME(startDate,GET_FORMAT(DATE,'INTERNAL')) <= FROM_UNIXTIME(UNIX_TIMESTAMP(),GET_FORMAT(DATE,'INTERNAL'))) AND (endDate='' OR FROM_UNIXTIME(endDate,GET_FORMAT(DATE,'INTERNAL')) >= FROM_UNIXTIME(UNIX_TIMESTAMP(),GET_FORMAT(DATE,'INTERNAL'))) AND (startTime='' OR FROM_UNIXTIME(startTime,GET_FORMAT(TIME,'INTERNAL')) <= FROM_UNIXTIME(UNIX_TIMESTAMP(),GET_FORMAT(TIME,'INTERNAL'))) AND (endTime='' OR FROM_UNIXTIME(endTime,GET_FORMAT(TIME,'INTERNAL')) >= FROM_UNIXTIME(UNIX_TIMESTAMP(),GET_FORMAT(TIME,'INTERNAL'))) AND (limitPerConfig=0 OR limitPerConfig>(SELECT COUNT(*) FROM tl_iso_rule_usage WHERE pid=r.id AND config_id=2)) AND (limitPerMember=0 OR limitPerMember>(SELECT COUNT(*) FROM tl_iso_rule_usage WHERE pid=r.id AND member_id=)) AND (configRestrictions='' OR (configRestrictions='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restrictions WHERE pid=r.id AND type='configs' AND object_id=2)>0)) AND (memberRestrictions='none' OR (memberRestrictions='members' AND (SELECT COUNT(*) FROM tl_iso_rule_restrictions WHERE pid=r.id AND type='members' AND object_id=)>0) ) AND (productRestrictions='none' OR (productRestrictions='producttypes' AND (SELECT COUNT(*) FROM tl_iso_rule_restrictions WHERE pid=r.id AND type='producttypes' AND object_id IN (1))>0) OR (productRestrictions='products' AND (SELECT COUNT(*) FROM tl_iso_rule_restrictions WHERE pid=r.id AND type='products' AND object_id IN (11))>0) OR (productRestrictions='pages' 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 (11))))) ORDER BY sorting) thrown in /Applications/MAMP/htdocs/contao/system/libraries/Database.php on line 642
#0 /Applications/MAMP/htdocs/contao/system/libraries/Database.php(589): Database_Statement->query()
#1 /Applications/MAMP/htdocs/contao/system/modules/isotope_rules/IsotopeRules.php(356): Database_Statement->execute(Array)
#2 /Applications/MAMP/htdocs/contao/system/modules/isotope_rules/IsotopeRules.php(85): IsotopeRules->findRules(Array, Array, Array)
#3 /Applications/MAMP/htdocs/contao/system/modules/isotope/Isotope.php(163): IsotopeRules->calculatePrice('2.50', Object(IsotopeProduct), 'price', '1')
#4 /Applications/MAMP/htdocs/contao/system/modules/isotope/IsotopeProduct.php(195): Isotope->calculatePrice('2.50', Object(IsotopeProduct), 'price', '1')
#5 /Applications/MAMP/htdocs/contao/system/modules/isotope/IsotopePOS.php(365): IsotopeProduct->__get('price')
#6 /Applications/MAMP/htdocs/contao/system/modules/isotope/IsotopePOS.php(177): IsotopePOS->generateContent('4c1e59242b00c1....')
#7 /Applications/MAMP/htdocs/contao/system/modules/isotope/IsotopePOS.php(97): IsotopePOS->printInvoices(Array)
#8 /Applications/MAMP/htdocs/contao/system/modules/backend/Backend.php(193): IsotopePOS->printInvoicesInterface(Object(DC_Table), 'tl_iso_orders', Array)
#9 /Applications/MAMP/htdocs/contao/contao/main.php(101): Backend->getBackendModule('iso_orders')
#10 /Applications/MAMP/htdocs/contao/contao/main.php(297): Main->run()
#11 {main}
Danke
Gruß
Matu
Lesezeichen