Post by westie99 » Mon Nov 04, 2024 5:20 pm

I am running a website using opencart 2.3.0.2 and I've recently had an issue with hundreds of testimonials being sent to my website that need to be approved. These consist of random letters, numbers and symbols and my son has suggested they might be some sort of sql injection attempt.

After the first batch were received about a week ago , I disabled the ability to add testimonials and thought that this would resolve the problem. Despite this change, I have another batch of several hundred appear today in my admin panel as needing to be approved.

I would appreciate any advice on how I can stop these from being submitted, and if it is possible to delete them from the backend of the site, as there are over 600 showing as waiting to be approved, and there doesn't seem to be any option to delete them.
Last edited by westie99 on Tue Nov 05, 2024 7:21 pm, edited 1 time in total.

Newbie

Posts

Joined
Mon Jul 03, 2017 10:59 pm

Post by ADD Creative » Mon Nov 04, 2024 5:25 pm

Are you talking about the built in OpenCart reviews or an extension that adds testimonials?

Have you tried enabling a CAPTCHA?

www.add-creative.co.uk


Guru Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by johnp » Mon Nov 04, 2024 5:39 pm

ADD Creative wrote:
Mon Nov 04, 2024 5:25 pm
Are you talking about the built in OpenCart reviews or an extension that adds testimonials?

Have you tried enabling a CAPTCHA?
Try installing these two scripts as they will help:

Ninja Firewall
https://nintechnet.com/ninjafirewall/pro-edition

The free version of Ninja Firewall is fine.

Cidram
https://github.com/CIDRAM/CIDRAM

Not perfect but gives valuable extra protection.

Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk


User avatar
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK

Post by westie99 » Mon Nov 04, 2024 5:46 pm

I disabled the built in reviews option which had CAPCHA enabled after the first incident, but I've just realised that I also had a separate testimonials extension on the site, that I've now also disabled. It's probably this extension that has been used to add the testimonials.

Hopefully this will stop any further problems, but it would have been good to have this still enabled and somehow block malicious fake testimonials from being submitted. I suppose I'll just have to wait and see if I get any further problems, but I would still like to delete the ones I have already received if this is possible.

Newbie

Posts

Joined
Mon Jul 03, 2017 10:59 pm

Post by by mona » Mon Nov 04, 2024 6:09 pm

Contact the extension developer - It sounds odd to have a reviews/testimonial extension without the ability for captcha.
As for deleting them just go into the backend and delete them (top right corner)
You can multiple delete by pressing the top checkbox on the left.
You can edit the number on the page in admin => system => settings => options tab I think => number of items on admin page.

DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.


https://www.youtube.com/watch?v=zXIxDoCRc84


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am

Post by khnaz35 » Mon Nov 04, 2024 10:39 pm

westie99 wrote:
Mon Nov 04, 2024 5:46 pm
Hopefully this will stop any further problems, but it would have been good to have this still enabled and somehow block malicious fake testimonials from being submitted.
Generally, when an attacker or spammer discovers your URL and receives a successful response, they’re likely to continue spamming. I recommend addressing the issue with the extension. If you can’t resolve it on your own, consider hiring a professional like myself to assist.

Got an urgent question that’s keeping you up at night? There might just be a magical inbox ready to help: khnaz35@gmail.com
Enjoy nature ;) :) :-*


User avatar
Active Member

Posts

Joined
Mon Aug 27, 2018 11:30 pm
Location - Malaysia

Post by JNeuhoff » Tue Nov 05, 2024 12:51 am

You might consider the SpamBot Buster which we can also modify for a small extra charge to cover your testimonials page, too.

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 westie99 » Tue Nov 05, 2024 7:20 pm

Thank you for all the advice and help. I've managed to get the google recapcha sorted out and I will look at some of the other spam prevention suggestions.

Newbie

Posts

Joined
Mon Jul 03, 2017 10:59 pm
Who is online

Users browsing this forum: Google [Bot] and 71 guests