Search Error


Status
Not open for further replies.

yanyewkay

Senior Member
Hello,

I did a search in Gallery for a username Br'yan and I got the below error.
I then tried to do a search in the forums with the above user name, I got a message telling me "Invalid User specified". I sure this user exists and I'm trying to locate a post from him.


the error message:
-----------------------------------------------------------
MySQL error reported!

Script: showgallery

Query: SELECT id,user,userid,cat,storecat,date,title,description,keywords,bigimage,width,height,filesize,views,medwidth,medheight,medsize,approved,rating,allowprint FROM photos WHERE approved='1' AND (user LIKE '%br'yan%') ORDER BY disporder,lastpost DESC

Result: 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 'yan%') ORDER BY disporder,lastpost DESC' at line 1

Database handle: Resource id #7
 

Status
Not open for further replies.
Back
Top