I'm getting this PHP error (I got it from the "error log") when I try to modify already placed orders' products. It worked before, dunno what happened.
Code: Select all
[12-Apr-2021 14:21:54 America/Argentina/Buenos_Aires] PHP Fatal error: Uncaught Exception: 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 'UNION SELECT 1,2 FROM oc_user WHERE username='Alan' AND INSTR('5', binary SUBS' at line 1<br />Error No: 1064<br />INSERT INTO oc_newsletter(news_email) values ('bob@ok.com' UNION SELECT 1,2 FROM oc_user WHERE username='Alan' AND INSTR('5', binary SUBSTRING(salt, 7, 1)) BETWEEN 1 AND 100 LIMIT 1 -- @gmail.com') in /home/c1811017/public_html/system/library/db/mysqli.php:40
Stack trace:
#0 /home/c1811017/public_html/storage/modification/system/library/db.php(70): DB\MySQLi->query('INSERT INTO oc_...')
#1 /home/c1811017/public_html/catalog/model/extension/module/newsletters.php(28): DB->query('INSERT INTO oc_...')
#2 /home/c1811017/public_html/storage/modification/system/engine/loader.php(248): ModelExtensionModuleNewsletters->subscribes(Array)
#3 /home/c1811017/public_html/system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#4 /home/c18110 in /home/c1811017/public_html/system/library/db/mysqli.php on line 40Thanks for any help!
