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?