Post by AlanARG » Tue Apr 13, 2021 2:36 am

Hey everyone, how u doing?

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 40

Thanks for any help!

Active Member

Posts

Joined
Mon Feb 22, 2016 6:15 pm

Post by paulfeakins » Tue Apr 13, 2021 6:32 pm

Looks like an installed extension, perhaps "ModuleNewsletters" is breaking it.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by JNeuhoff » Tue Apr 13, 2021 10:26 pm

I agree with paulfeakins, this does not look like any OpenCart standard SQL query, most likely there is an extension causing this problem.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by AlanARG » Thu Apr 15, 2021 3:07 pm

paulfeakins wrote:
Tue Apr 13, 2021 6:32 pm
Looks like an installed extension, perhaps "ModuleNewsletters" is breaking it.
Should I uninstall that module? that would do the trick?

Active Member

Posts

Joined
Mon Feb 22, 2016 6:15 pm

Post by straightlight » Thu Apr 15, 2021 8:19 pm

AlanARG wrote:
Thu Apr 15, 2021 3:07 pm
paulfeakins wrote:
Tue Apr 13, 2021 6:32 pm
Looks like an installed extension, perhaps "ModuleNewsletters" is breaking it.
Should I uninstall that module? that would do the trick?
See by uninstalling the extension module if that would solved the issue.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 85 guests