UPDATES EasyBlog 6.0.14 Released! Joomla 5.x and PHP 8.x compatible now!

Helpdesk

Your Time
Our Time
Response Time
24 — 48 hours
We strive to provide the fastest ever response possible. However, we are not super beings.

Allow at least 24 — 48 hours
  Support is offline
Our team is away during the weekend. Some answers may already be available on our documentation

Rest assured that we will get back to your posts as soon as the week starts!
  Support is offline

Photos causing site CPU overrun

Rod Suskin · ·
6:59 PM Friday, 04 April 2014
None
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
The replies under this section are restricted to logged in users or users with an active subscription with us