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

PhotoPost Community (http://www.photopost.com/forum/)

- Classifieds Bug Reports (http://www.photopost.com/forum/classifieds-bug-reports/)

- - error during execution of query: Unknown column 'clear.gif' in 'where clause (http://www.photopost.com/forum/classifieds-bug-reports/137431-error-during-execution-query-unknown-column-clear-gif-where-clause.html)

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

Hi,

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

Quote:

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. :p

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

Code:

Content visible to verified customers only.

change to this

Code:

Content visible to verified customers only.

Quote:

Originally Posted by Chuck S (Post 1229449)

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. :o

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.

Quote:

Originally Posted by Chuck S (Post 1229469)

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! :)

Not a problem glad to help