View Single Post
Old June 19th, 2006, 07:31 AM   #1 (permalink)
cpmike
Member
Verified Customer
 
Join Date: Nov 2004
Posts: 59
MySql errors / Spam robots

Hi,

I get 100+ mails of these errors every day. Is there anything I can do about this?

I set $debug=0; in my config file, but still get the mails.

!! The url in the error is chanced every time !!

I use version 5.3 (VB).

------------------------

An error was encountered during execution of the query:

SELECT c.id,c.username,c.userid,c.date,c.rating,c.comment,c.cat,c.photo,p.bigimage,p.cat,p.userid FROM pp_comments c
LEFT JOIN pp_photos p ON p.id=c.photo WHERE c.comment != '' AND c.cat IN (http://xxxempire.net/viagra/3/lowest_prices_viagra.html) OR ((c.comment LIKE "% http://xxxempire.net/viagra/3/lowest_prices_viagra.html%") OR (c.comment LIKE "http://xxxempire.net/viagra/3/lowest_prices_viagra.html%")) AND (c.username LIKE '%lowest prices viagra%')

The query returned with an errorcode of:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '://xxxempire.net/viagra/3/lowest_prices_viagra.html) OR ((c.comment LIKE "% htt' at line 2

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.


---------------
cpmike is offline   Reply With Quote