error during execution of query: Unknown column 'clear.gif' in 'where clause

[peterle]

Hi,

I see some errors from time to time and don't know why.
It looks always like that:

An error was encountered during execution of the query:

SELECT id,user,userid,cat,date,title,description,keywords,bigimage,views,approved,rating,price,status,extra1,extra2,extra3,extra4,extra5,extra6,disporder,zipcode,adoptions,isauction,enddate,highbidder,maxbid,currency FROM pp_products WHERE approved=1 AND cat IN (clear.gif) AND (user LIKE '%stebo79%') ORDER BY disporder,views DESC

The query returned with an errorcode of:

Unknown column 'clear.gif' in 'where clause'

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.

I use classifieds 3.02 and photopost pro 6.11.
Classifieds give the error photopost pro doesn't do anything like that.

Looks for me like someone searching, but I don't know much about sql querries, so any help is appreciated.

[Chuck S]

Well I dont know how someone would do that without playing with search urls which is probally the case.

In showcat.php find this line

Content visible to verified customers only.

change to this

Content visible to verified customers only.

[peterle]

Originally Posted by Chuck S

Well I dont know how someone would do that without playing with search urls which is probally the case.

Could you please tell me more about it - could be via PM if you don't like it here.

I changed your code and I if it doesn't work, I will tell you.

[Chuck S]

It should easily work since they can not enter a string variable for mcats

All I am saying is most likely its a bot trying to spoof things.

[peterle]

Originally Posted by Chuck S

All I am saying is most likely its a bot trying to spoof things.

Ah, I get used to things like that ...
Thanks again for the fast help!

[Chuck S]

Not a problem glad to help