SA-MP Forums Archive
Mysql bug - 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: Mysql bug (/showthread.php?tid=640488)


Mysql bug - Klayton - 03.09.2017

Hello I have a problem with my script, after the dialog of register, the account its saved but the server crashed.

R41-3


https://pastebin.com/hc5NWiaA


Code:
[14:38:13] [plugins/mysql] error #1062 while executing query "INSERT INTO `players` (`username`, `password`, `salt`, `sexe`, `ethnie`, `age`, `skin`) VALUES ('Player_Random', 'BA0BE77D19D09DB5F79D6F483D70CC054AFD9564D64D44CDFBB847BAA2594B73', '>?/a4N+w|WT]3R^=', 'd', 'd', 'd', 'd')": Duplicate entry 'Player_Random' for key 'username'
[14:38:13] [log-core] exception 0XC0000005 (ACCESS_VIOLATION) from Vectored Exception Handler catched; shutting log-core down

Code:
[14:20:04] [ERROR] exception 0XC0000005 (ACCESS_VIOLATION) from Vectored Exception Handler catched; shutting log-core down
[14:21:34] [ERROR] exception 0XC0000005 (ACCESS_VIOLATION) from Vectored Exception Handler catched; shutting log-core down
[14:23:08] [ERROR] exception 0XC0000005 (ACCESS_VIOLATION) from Vectored Exception Handler catched; shutting log-core down
[14:24:18] [ERROR] exception 0XC0000005 (ACCESS_VIOLATION) from Vectored Exception Handler catched; shutting log-core down
[14:25:59] [ERROR] exception 0XC0000005 (ACCESS_VIOLATION) from Vectored Exception Handler catched; shutting log-core down
[14:28:13] [ERROR] exception 0XC0000005 (ACCESS_VIOLATION) from Vectored Exception Handler catched; shutting log-core down
[14:38:13] [ERROR] exception 0XC0000005 (ACCESS_VIOLATION) from Vectored Exception Handler catched; shutting log-core down
[14:48:38] [ERROR] exception 0XC0000005 (ACCESS_VIOLATION) from Vectored Exception Handler catched; shutting log-core down
[14:52:35] [INFO] received Windows console close event; shutting log-core down
[14:53:08] [ERROR] exception 0XC0000005 (ACCESS_VIOLATION) from Vectored Exception Handler catched; shutting log-core down


Re: Mysql bug - Luke_James - 03.09.2017

It's saying the player you're registering already exists. It's hard to tell if that's causing the crash.

Enable full SQL logging in your script with mysql_log(ALL); and reproduce the crash, then post the log here.

Re: Mysql bug - Klayton - 03.09.2017

Okay thanks ! I tell you in 10 minutes !

Re: Mysql bug - Klayton - 03.09.2017

fixed, stupid error of Dialog..