1 Attachment(s)
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:
Attachment 115618
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.
Re: I have an SQL syntax error in my database, need help correcting it?
What exactly were you trying to do?
Re: I have an SQL syntax error in my database, need help correcting it?
Keep track of recorded users who register.
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.
Re: I have an SQL syntax error in my database, need help correcting it?
Re: I have an SQL syntax error in my database, need help correcting it?
Quote:
Originally Posted by
Sin0xFF
Nothing appears still.
Hmm, Ive never heard of that happening before o.o
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 :(
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;