All of a sudden a client of us has MAJOR problems with their webshop: Payments are not getting through in their mailbox nor in the OC store. This is major because clients don't receive mails and the webmaster of the shop isn't able to proccess the orders.
The errors are:
Code: Select all
Exception: Error: Invalid default value for 'date_available'<br />Error No: 1067<br />ALTER TABLE `oc_product` ADD `voucher_category` VARCHAR(20) NULL in /var/www/vhosts/xxx.store/httpdocs/system/library/db/mysqli.php:41\nStack trace:\n#0 /var/www/vhosts/xxx.store/httpdocs/system/library/db.php(45): DB\\MySQLi->query()\n#1 /var/www/vhosts/xxx.store/httpdocs/admin/controller/payment/mollie/base.php(265): DB->query()\n#2 /var/www/vhosts/xxx.store/httpdocs/admin/controller/payment/mollie/base.php(781): ControllerPaymentMollieBase->install()\n#3 /var/www/vhosts/xxx.store/httpdocs/vqmod/vqcache/vq2-_var_www_vhosts_xxx.store_storage_modification_system_engine_action.php(79): ControllerPaymentMollieBase->index()\n#4 /var/www/vhosts/xxx.store/httpdocs/admin/controller/startup/router.php(26): Action->execute()\n#5 /var/www/vhosts/xxx.store/httpdocs/vqmod/vqcache/vq2-_var_www_vhosts_xxx.store_st...', referer: https://www.xxx.store/admin/index.php?route=marketplace/extension&type=payment&user_token=qTpzzcjHG67FMF5W0oAQ62N238PwCtvJ
Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE pd.`language_id` = '2' AND p.`date_available` <= NOW() AND p2s.`store_i...' at line 1<br />Error No: 1064<br />SELECT DISTINCT ps.`product_id`, (SELECT AVG(`rating`) FROM `oc_review` r1 WHERE r1.`product_id` = ps.`product_id` AND r1.`status` = '1' GROUP BY r1.`product_id`) AS rating FROM `oc_product_special` ps LEFT JOIN `oc_product_to_store` p2s ON (ps.`product_id` = p2s.`product_id`) LEFT JOIN `oc_product_to_category` p2c LEFT JOIN `oc_product` p ON (p2c.`product_id` = p.`product_id`) LEFT JOIN `oc_product_description` pd ON (ps.`product_id` = pd.`product_id`) WHERE pd.`language_id` = '2' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0' AND ps.`customer_group_id` = '1' AND ((ps.`date_start` = '0000-00-00' OR ps.`date_star...', referer: https://www.anotherstore.nl/OC 3.0.3.7
Standard version
Lastest VQMOD
Latest Mollie module
Kind regards,
Kec
