Any of you computer savvy folks out there have any clue as to what the following error message is caused by and how to fix it? Seems I can't view anyone's pics any longer when i click the gallery button in posts. The message i see in place of the gallery images is: 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 AND cat !='537' AND cat !='538' AND cat !='539' AND cat !='540' AND cat !='541' AND cat !='542' AND cat !='543' AND userid=9764 AND cat !='537' AND cat !='538' AND cat !='539' AND cat !='540' AND cat !='541' AND cat !='542' AND cat !='543' AND cat != 521 AND cat != 537 AND cat != 546 AND cat != 548 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 'AND cat !='537' AND cat !='538' AND cat !='539' AND cat !='540' Database handle: Resource id #7 It's all greek to me! lol.
i'd go with restarting your computer. i don't think that's a problem on your side.......could be...but doesn't seem like it
I restarted the comp and still get the same message. If its not a problem with my computer or browser configuration then I should ask, is anyone else getting this message when they click on anyone's "gallery" button?
Hmm, it sounds to me like a serverside problem, or perhaps a browser conflict. What kind of browser do you have? Also, have you tried going to the hipgallery homepage and navigating through that way?
you know, i can view anybody's gallery, except yours. seems fishy. when i click your gallery, it gives that mySQL error. hm.
LickHERish, It is a corrupted SQL statement used in the accessing of data from the forums database. You should post this in the support forum. It's a problem only the webmaster and designates can fix.
Thanks for the replies, the problems seem to have been corrected. I wasn't sure where to post such questions and didnt notice the support forums. That's the only reason I posted in here since it seemed the place to discuss computer related questions. Ill note what you've said for future reference nonetheless. Thanks again!