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.

For quick, professional OpenCart support please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - Reigate, Surrey, 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.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member
Online

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.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


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: thekrotek and 38 guests