Weird MySQL error!
#1

Solved, thanks to [HiC]TheKiller =]
Reply
#2

Remember that around every %s, you must have single quotes (' and '). So instead of %s, it will be '%s'.
Reply
#3

Код:
[22:07:55] CMySQLHandler::Query(UPDATE accounts SET Registered=1, Email='NULL', Password='Censored', IP='127.0.0.1', Ping=16, LoggedIn=0 WHERE Name='Allan_Mander') - Successfully executed.
Guess what that means =]


Thank you, [HiC]TheKiller! +rep

I didn't know that, you tutorial doesn't say anything about it, you should add that to your tutorial for noobs like me!
Reply
#4

Quote:
Originally Posted by TheLazySloth
Посмотреть сообщение
Код:
[22:07:55] CMySQLHandler::Query(UPDATE accounts SET Registered=1, Email='NULL', Password='Censored', IP='127.0.0.1', Ping=16, LoggedIn=0 WHERE Name='Allan_Mander') - Successfully executed.
Guess what that means =]


Thank you, [HiC]TheKiller! +rep

I didn't know that, you tutorial doesn't say anything about it, you should add that to your tutorial for noobs like me!
Added a note at the bottom about it .
Reply
#5

Quote:

CURRENT NOTES
1. Change the query sizes if you are using a lot of variables.
2. Field names are case sensitive
3. Post any bugs here .
4. All passwords are hashed with SHA1, that means you cannot decrypt SHA1 passwords once they are set. For more information, visit the Wikipedia Page
5. For all strings, you must surround them with ' and '. So a string would be represented as username = '%s' and not username = %s.

I honestly didn't see that =o, oh well then again I'm partially blind up close (far-sighted)
Reply
#6

Quote:
Originally Posted by TheLazySloth
Посмотреть сообщение
I honestly didn't see that =o, oh well then again I'm partially blind up close (far-sighted)
I just added that, don't worry, you're not blind .
Reply
#7

Oh okay. xD
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)