URGENT: Fix Magento 1.9.3.8 Site Issue - cannot add to cart and other maintenance tasks
Budget: $30 – $250 AUD
Our website Magento 1.9.3.8 doesn't add products to cart - It stopped working a few days ago. We haven't applied any patches or made any code changes.
We've also found out that someone has been spammily creating customers in the tables
customer_entity
customer_entity_varchar
My thought is that these can be picked up as the lastname (attribute_id 7) is over 30 characters in length and few genuine customers are, so we need all the customers and associated records to be deleted. I can do this via SQL but need to know if any other related tables have records in as a result
example
select * from customer_entity_varchar where attribute_id = 7 and length(value) >25
then delete these records from both tables by the entity_id
We also need any uptodate security patches applying.
So in summary:
1. Fix the add to cart option so the store can start selling again.
2. Delete the customers that are spam
3. Stop spammers from creating further customers
4. Apply all recent security patches
Extract from log file is attached
We've also found out that someone has been spammily creating customers in the tables
customer_entity
customer_entity_varchar
My thought is that these can be picked up as the lastname (attribute_id 7) is over 30 characters in length and few genuine customers are, so we need all the customers and associated records to be deleted. I can do this via SQL but need to know if any other related tables have records in as a result
example
select * from customer_entity_varchar where attribute_id = 7 and length(value) >25
then delete these records from both tables by the entity_id
We also need any uptodate security patches applying.
So in summary:
1. Fix the add to cart option so the store can start selling again.
2. Delete the customers that are spam
3. Stop spammers from creating further customers
4. Apply all recent security patches
Extract from log file is attached