Script running mad - bad extention ??

Questions related to the configuration of Joomla, Templates, and Security related questions/issues
Rate this topic: Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.
GK User
Wed Oct 24, 2012 9:16 am
I need some help to find the extention that *** up my DB. The hoster of my site gave me this report this morning: (have set ? where the db extention is)
----
Executed 10 min ago for 1 sec on Database --> mittspan_?????.
SELECT DISTINCT cats.name AS cat_name, cats.alias AS cat_alias, content.catid AS cat_id, users.name AS author, users.email AS author_email, users.id AS author_id, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.id AS ID, content.alias AS alias, content.hits AS hits, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count, content.plugins AS plugins FROM sgj_k2_items AS content LEFT JOIN sgj_k2_categories AS cats ON cats.id = content.catid LEFT JOIN sgj_users AS users ON users.id = content.created_by LEFT JOIN sgj_k2_rating AS content_rating ON content.id = content_rating.itemID WHERE content.trash = 0 AND cats.access <= 0 AND content.access <= 0 AND content.published = 1 AND cats.published = 1 AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2012-10-24 06:39:06' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2012-10-24 06:39:06' ) AND ( content.catid = 3 OR content.catid = 4 OR content.catid = 5 OR content.catid = 6 OR content.catid = 7 OR content.catid = 8 OR content.catid = 9 OR content.catid = 10 OR content.catid = 12 OR content.catid = 13 OR content.catid = 14 OR content.catid = 15 OR content.catid = 16 OR content.catid = 17 OR content.catid = 18 OR content.catid = 19 OR content.catid = 20 OR content.catid = 21 OR content.catid = 22 OR content.catid = 23 OR content.catid = 26 OR content.catid = 27 OR content.catid = 28 OR content.catid = 29 OR content.catid = 30 OR content.catid = 31 OR content.catid = 32 OR content.catid = 33 OR content.catid = 34 OR content.catid = 36 OR content.catid = 37 OR content.catid = 38 OR content.catid = 39 OR content.catid = 41 OR content.catid = 44 OR content.catid = 45 OR content.catid = 54 OR content.catid = 56 OR content.catid = 58 OR content.catid = 60 ) ORDER BY content.created DESC LIMIT 0,900

----
Got also a siminlar just some minutes after.

Please help.
User avatar
Expert Boarder

GK User
Wed Oct 24, 2012 5:58 pm
This is probably query from News Show Pro module and it gets data from selected in backend configuration categories. I don't see any other way to ask database for this informations but if you know better way you can share your solution with us. Did you notice any problems with this query or simply you thought that there is something wrong while you are viewing log ?
User avatar
Platinum Boarder

GK User
Wed Oct 24, 2012 8:04 pm
I needed desperate help because the host company stopped my site because of this query.
I had no idea of what to do. My site is a living magazine with many readers.
Got some help from a former GavickPro developer, I very good friend, who helped me. Found the problem and saved my life.
First of all it was no cache in my system on. That alone helped.
Thanks anyhow for let me know you are spot on the case now.
I got 24 hours close watch from the system operators on my case.
User avatar
Expert Boarder

GK User
Thu Oct 25, 2012 8:57 am
Please try to decrease the amount of categories in News Show Pro - probably in one of the modules you have selected all categories and this run this long query. Then please try to configure cache - this will limit queries to database.
User avatar
Platinum Boarder


cron