El Patron (and vekia)-
The only way I could find to enable debug mode was to change a line in /defines.inc.php
if (!defined('_PS_MODE_DEV_')) { define('_PS_MODE_DEV_', false);
to:
if (!defined('_PS_MODE_DEV_')) { define('_PS_MODE_DEV_', true);
I signed out of admin and logged back in -
I didn't get an error when I went to the prices page, BUT, now it won't accept any new specific price rules at all. I can still go to "Add new specific price" and enter all the options. I make SURE they are new options/entirely new rules (new customer/group, price/% etc) - just like I could before enabling debug - but now when I hit save, I get this:
[ 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 'ON DUPLICATE KEY UPDATE id_product = id_product # avoid duplicate keys' at line 3 INSERT INTO `vlt_layered_price_index` (id_product, id_currency, id_shop, price_min, price_max) VALUES ON DUPLICATE KEY UPDATE id_product = id_product # avoid duplicate keys ]