Delete spam messages Prestashop 1.6

[PrestaSam]

Hi,

 

Our shop was spammed by some Chinese spam bot (messages from qq.com) via the contact form. I managed to stop it by deleting the specific contact it was sent to.

 

But in the last 3 days more than 130.000 messages were sent and I need to delete them. Prestashop allows only a view with 1000 messages to delete at once. It's cost me hours...

 

Does somebody know how to delete all messages at once? You would really help me a lot.

[vekia]

you've got an access to database manager like phpMyAdmin ?

[PrestaSam]

Hi Vekia,

 

I have no experience with that. Could I used Dreamweaver for that too?

[PrestaSam]

Isn't it possible to add for instance 100.000 in the selection dropbox that manages how many messages can be viewed at once?

[vekia]

no, you cant do this with dreamviewer.

if you want to remove these spam emails in bulk it will be necessary to do it with some database manager software

where you can do it in bulk.

 

i think that this can be done with free (30 days) store manager

http://addons.prestashop.com/en/2937-store-manager-for-prestashop.html

[PrestaSam]

Ok, I entered my Cpanel and I do have access to phpMyAdmin. In fact: I'm viewing my database right now. Which table do I need to look at?

[milaonline]

I you are familiar in PHP you can make script - something like:

$id_customer_thread = SELECT id_customer_thread FROM ps_customer_thread WHERE email LIKE '%qq.com';

then

DELETE FROM ps_customer_message where id_customer_thread = ".$id_customer_thread."

DELETE FROM ps_customer_thread where id_customer_thread = ".$id_customer_thread."

This script is not complete.

[Vince]

If you only delete in database, it should not resolve your problem 100%. What is after deleting the spam emails, then tomorrow it should back again?

 

I think you should do two things:

1. In contact form: You should add a captcha option to avoid spam.

2. Delete all the old spam message.

You can use this SQL command to delete all of them: 

DELETE FROM ps_customer_thread WHERE email LIKE '%qq.com';

 

becareful if your db have another prefix, you should replace "ps_" to your prefix.

 

 

Hope this help!

[milaonline]

Vince you are right.

Here is solution for No 1 - stop sending messages:

https://github.com/PrestaShop/PrestaShop/pull/8168

It works great

[LauraPresta]

Hello Guys,

Same problem here (we added recaptacha so problem is half solved)

We cleared table ps_customer_message and ps_customer_thread but i check it is not enough. There is some others things to clear because i still check the database is 17mB too big

Any idea ?

 

[LauraPresta]

ok so there is also : ps_mail to clear, and we added ps_gest, ps_connections and ps_logs

good luck