I have an SQL syntax error in my database, need help correcting it?

Results 1 to 8 of 8
  1. #1
    Newbie Sin0xFF is offline
    MemberRank
    Sep 2012 Join Date
    21Posts

    I have an SQL syntax error in my database, need help correcting it?

    My habbo retro stills works, thats not a problem at all. Im using a phoenixEMU.
    The problem is stated in the "users" section of the database. It states:

    #1064 - 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 '`2000` WHERE `Sin`' at line 1

    By the way, Sin is my user name. What can I do to fix
    ______________
    Here is the picture:

    mysql_syntax_error.jpg

    I can still register an account, and it would be able to access the hotel, but if I am not mistaken, shouldn't of the field boxes disapear by now? It was like that with my holocms hotel, as soon as I register an account the field boxes would disapear, and it would show the users information and email etc.


  2. #2
    Elite Member Whale is offline
    Member +Rank
    Jun 2012 Join Date
    United KingdomLocation
    234Posts

    Re: I have an SQL syntax error in my database, need help correcting it?

    What exactly were you trying to do?

  3. #3
    Newbie Sin0xFF is offline
    MemberRank
    Sep 2012 Join Date
    21Posts

    Re: I have an SQL syntax error in my database, need help correcting it?

    Keep track of recorded users who register.

  4. #4
    Elite Member Whale is offline
    Member +Rank
    Jun 2012 Join Date
    United KingdomLocation
    234Posts

    Re: I have an SQL syntax error in my database, need help correcting it?

    If you go into the users table then click 'browse' it will show you all registered users.

  5. #5
    Newbie Sin0xFF is offline
    MemberRank
    Sep 2012 Join Date
    21Posts

    Re: I have an SQL syntax error in my database, need help correcting it?

    Nothing appears still.

  6. #6
    Elite Member Whale is offline
    Member +Rank
    Jun 2012 Join Date
    United KingdomLocation
    234Posts

    Re: I have an SQL syntax error in my database, need help correcting it?

    Quote Originally Posted by Sin0xFF View Post
    Nothing appears still.
    Hmm, Ive never heard of that happening before o.o

  7. #7
    Newbie Sin0xFF is offline
    MemberRank
    Sep 2012 Join Date
    21Posts

    Re: I have an SQL syntax error in my database, need help correcting it?

    Ok weird, but if I type in: SELECT * FROM `users` WHERE 1 It eventually goes into the users content, but then once I exit off, it continues to display the Error message. Thats means if i wanted look at the recorded database of users I would have to keep typing in SELECT * FROM `users` WHERE 1 :(

  8. #8
    Sorcerer Supreme Dysfunctional is offline
    Member +Rank
    Jul 2012 Join Date
    AustraliaLocation
    391Posts

    Re: I have an SQL syntax error in my database, need help correcting it?

    as I've said try this;

    UPDATE `users` SET `rank` = '2000' WHERE `username` =Sin;



Advertisement