Weird MySQL error! - Printable Version

Weird MySQL error! - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Weird MySQL error! (/showthread.php?tid=289820)

Weird MySQL error! - TheLazySloth - 13.10.2011

Solved, thanks to [HiC]TheKiller =]

Re: Weird MySQL error! - [HiC]TheKiller - 13.10.2011

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

Re: Weird MySQL error! - TheLazySloth - 13.10.2011

Код:

[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!

Re: Weird MySQL error! - [HiC]TheKiller - 13.10.2011

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

Re: Weird MySQL error! - TheLazySloth - 13.10.2011

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)

Re: Weird MySQL error! - [HiC]TheKiller - 13.10.2011

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

Re: Weird MySQL error! - TheLazySloth - 13.10.2011

Oh okay. xD