Strange problem I never encountered here before

Discussion in 'Computers and The Internet' started by LickHERish, Feb 3, 2005.

  1. LickHERish

    LickHERish Senior Member

    Messages:
    2,009
    Likes Received:
    2
    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.
     
  2. Trotsky311

    Trotsky311 Supporters HipForums Supporter

    Messages:
    749
    Likes Received:
    2
    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
     
  3. LickHERish

    LickHERish Senior Member

    Messages:
    2,009
    Likes Received:
    2
    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?
     
  4. AreYouExperienced

    AreYouExperienced American Victim

    Messages:
    1,089
    Likes Received:
    2
    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?
     
  5. Trotsky311

    Trotsky311 Supporters HipForums Supporter

    Messages:
    749
    Likes Received:
    2
    you know, i can view anybody's gallery, except yours.

    seems fishy. when i click your gallery, it gives that mySQL error. hm.
     
  6. luvndrumn

    luvndrumn Hip Forums Supporter HipForums Supporter

    Messages:
    1,903
    Likes Received:
    1
    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.
     
  7. LickHERish

    LickHERish Senior Member

    Messages:
    2,009
    Likes Received:
    2
    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!
     
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice