SQL Help? - 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: SQL Help? (/showthread.php?tid=533773)
+- 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: SQL Help? (/showthread.php?tid=533773)
SQL Help? - Keyhead - 26.08.2014
Basically, On my server. Players creating a new account, can create the account, but then not login. But, players who were already registered before, can login. Could this be a MySQL error or would it be in the script? It's only just started happening.
Re: SQL Help? - Dotayuri - 26.08.2014
With no code all I see is: your creating a new account. But you don't update the info. So unless the player uses,
/q then opens your server again. they cannot log in because the system still thinks they have no account.
Re: SQL Help? - Keyhead - 26.08.2014
No, What I'm saying is. It worked, perfectly, they register then login. Now, the screen just goes blank with the arrow and spawn button. Would that indicate an error in the SQL?
Re: SQL Help? - Dotayuri - 26.08.2014
so everything was good and working but recently, this started to happen?
also could you post a screenshot?
Re: SQL Help? - Keyhead - 26.08.2014
pawn Код:
[12:09:26] Passing query INSERT INTO `accounts` (`username`,`password`,`securepass`) VALUES("Kyle2","C8CD595951B6C28957DA631933100D37922CA87F393BCB1074D646608C116D62A91384CB8504CE6878F60A625459A7A93D1BA87C2853D6650CD8386B67D2D972",1); | dd
[12:09:26] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[12:09:26] OnQueryError() - Called.