Hi
Siteground closed down my easysocial site because SQL queries erre taking up too many resources. The code they identified as causing the problem is this:
SELECT * FROM `j32_social_photos` WHERE `state` = '1' AND `storage` = 'joomla' AND `id` != '5' AND `id` != '236' AND `id` != '243' AND `id` != '258' AND `id` != '268' AND `id` != '273' AND `id` != '278' AND `id` != '283' AND `id` != '288' AND `id` != '293' AND `id` != '298' AND `id` != '303' AND `id` != '308' AND `id` != '313' AND `id` != '318' AND `id` != '323' AND `id` != '3 ...
and it goes on through THOUSANDS of id numbers - basically causing continuous requests and requesting the whole list every few minutes.
Is this a bug on 1.2.3 ? Does upgrading to 1.2.5 fix this? (I performed the upgrade)
They can find no malicious code or entry to the site.
Can you help me understand what's going on and how I can prevent this happening again? I dont want to close the site down again!
THanks
Rod