Ugh, silly me. I'm running opencart on my subdomain (for testing purposes so I don't accidentaly break the live site) and I think I found the correct error log.
Code: Select all
PHP Fatal error: Uncaught 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 '0' at line 1<br />Error No: 1064<br />0 in .../system/library/db/mysqli.php:40
Stack trace:
#0 .../system/library/db.php(45): DB\MySQLi->query(0)
#1 .../admin/model/marketing/coupon.php(52): DB->query(0)
#2 .../vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(259): ModelMarketingCoupon->editCoupon('17', Array)
#3 .../system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#4 .../admin/controller/marketing/coupon.php(55): Proxy->__call('editCoupon', Array)
#5 .../vqmod/vqcache/vq2-syste in .../system/library/db/mysqli.php on line 40
As for the "-" instead of ".", I'm blaming my new keyboard and I made the correction, thanks for pointing it out. And by correcting this, I can now successfully edit the coupon.
I checked the error log again and can't see any new records, so I'm willing to bet that it was just a typo that caused problems. Typical.
Thanks for the help!
edit:
Ok so after a bit of testing I found out that the coupon by manufacturer works for all products / all manufacturers, not just assigned ones. Any tips on where I should look to correct this behaviour?