Keyword

Too many database connections

  • Christian Rerucha
  • Christian Rerucha's Avatar Topic Author
  • Offline
  • New Member
More
11 years 2 months ago #116271 by Christian Rerucha
Too many database connections was created by Christian Rerucha
HELP!

Every Friday morning between 2:00 and 3:00 my website shuts down. According to GoDaddy, there are 200+ simultaneous connections to the server, and so they shut down the database. They sent me the following SQL query, and said that this is what is causing it:

SELECT i.* ,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged ,
c.name as categoryname ,
c.id as categoryid ,
c.alias as categoryalias ,
c.params as categoryparams
FROM jos_k2_items as i LEFT JOIN jos_k2_categories AS c ON c.id = i.catid
WHERE i.published = 1 AND
i.access IN(1 , 1 ) AND
i.trash = 0 AND
c.published = 1 AND
c.access IN(1 , 1 ) AND
c.trash = 0 AND
( i.publish_up = '0000-00-00 00:00:00' OR
i.publish_up <= '2013-08-02 09:57:35' ) AND
( i.publish_down = '0000-00-00 00:00:00' OR
i.publish_down >= '2013-08-02 09:57:35' ) AND
MATCH(i.title ,
i.introtext ,
i.`fulltext` ,
i.image_caption ,
i.image_credits ,
i.video_caption ,
i.video_credits ,
i.extra_fields_search ,
i.metadesc ,
i.metakey) AGAINST ('??alert(203)*' IN BOOLEAN MODE)
ORDER BY i.id DESC
LIMIT 0 , 10

UPDATE jos_k2_items SET `hits` = (`hits` + 1) WHERE id = '19'

I know that programmatical text is sometimes stripped out of messages, so I have attached a screen shot of what it looks like.

Can anyone tell me what is going on, and how to fix this?

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum