SQL Problem on Photo Gallery...

Discussion in 'Suggestions, Problems and Tests' started by surgingshark, Apr 24, 2004.

  1. surgingshark

    surgingshark Valued Member

    Just got this lovely message while uploading a few photos...

    MySQL error reported!

    Script:

    Query: INSERT INTO notify (id,userid,photo) values(NULL,3237,)

    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 ')' at line 1

    Database handle: Resource id #17

    *confused*
     
    surgingshark, Apr 24, 2004
    #1
  2. Saz

    Saz Nerd Admin

    At a guess I'd say its missing ' ' from the variables (id,userid,photo). Am I right? (testing my SQL knowledge, I'm learning)

    HKF will sort it in a flash :)
     
    Saz, Apr 24, 2004
    #2
  3. Nukie

    Nukie New Member

    yea .. i'm not so sure but have been usin oracle 9i in the past few days and we had ' ' in the values tag??
     
    Nukie, Apr 24, 2004
    #3
  4. Nukie

    Nukie New Member

    oh and check your constraints as well..
     
    Nukie, Apr 24, 2004
    #4
  5. surgingshark

    surgingshark Valued Member

    Arigatou Gozaimasu *bows*
     
    surgingshark, Apr 24, 2004
    #5
  6. Nukie

    Nukie New Member

    um watishiwa nukie des, hajemashite!? ah i forget my japanese... i used to study it but forget it all now.. sayonara? :)
     
    Nukie, Apr 24, 2004
    #6
  7. surgingshark

    surgingshark Valued Member

    You're not that rusty at all :)

    Watashi = I
    Wa = Am
    Nukie = Nukie
    Desu = (means that the previous words are part of a fact)
    Hajimemashite = Pleased To Meet You
     
    surgingshark, Apr 24, 2004
    #7
  8. hongkongfuey

    hongkongfuey Kung Fu Geek

    SS - was this a 'one off' or has it repeated? Anyone else tried uploading photos since the site update?
     
    hongkongfuey, Apr 24, 2004
    #8
  9. surgingshark

    surgingshark Valued Member

    Happened to me only once, hongkongfuey...
     
    surgingshark, Apr 24, 2004
    #9
  10. Saz

    Saz Nerd Admin

    The problem lies somewhere between the keyboard and the chair then :D
     
    Saz, Apr 24, 2004
    #10
  11. surgingshark

    surgingshark Valued Member

    What chair? I''m on the carpet :)
     
    surgingshark, Apr 24, 2004
    #11
  12. Saz

    Saz Nerd Admin

    Ok, I'll say it less subtley.

    Its your fault, na na na nanana! :D
     
    Saz, Apr 24, 2004
    #12
  13. surgingshark

    surgingshark Valued Member

    Sure, pick on the Californian :cry:
     
    surgingshark, Apr 25, 2004
    #13
  14. La Mancha

    La Mancha Valued Member

    Works for me. Doesnt like my popup stopper though.

    David
     

    Attached Files:

    La Mancha, Apr 26, 2004
    #14

Share This Page