Heres my server - 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: Heres my server (/showthread.php?tid=302803)

---

Heres my server - FreedomtoLive - 10.12.2011

Heres what my , Mysql players table looks like,

Can anyone find a reason, why they can register? but when they type /login the server crashes and restarts?

---

Re: Heres my server - Dark_Kostas - 10.12.2011

It would be good to show us your login and register commands(or at least how do you parse the data). Also you can use prints to see which was the last "place" the code worked or even better use Crash detect plugin

EDIT: One topic is enough... https://sampforum.blast.hk/showthread.php?tid=302584

---

Re: Heres my server - Johnson_boy - 10.12.2011

1. Encrypt your passwords
2. It's not mysql server/table related, it's about your script/plugin.

I suggest you to check your mysql log for query errors.

---

Re: Heres my server - FreedomtoLive - 10.12.2011

[21:58:00] CMySQLHandler::Connect() - Connection was successful.

[21:58:00] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[21:58:00] >> mysql_ping( Connection handle: 7557736 )

[21:58:00] >> mysql_ping() - Invalid connection handle. (You set: 7557736, Highest connection handle ID is 1).

[21:58:00] >> mysql_connect( )

[21:58:00] CMySQLHandler::Connect() - Connection was successful.

[21:58:00] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[21:58:00] >> mysql_ping( Connection handle: 7557736 )

[21:58:00] >> mysql_ping() - Invalid connection handle. (You set: 7557736, Highest connection handle ID is 1).

[21:58:32] >> mysql_ping( Connection handle: 7557732 )

[21:58:32] >> mysql_ping() - Invalid connection handle. (You set: 7557732, Highest connection handle ID is 1).

[21:58:32] >> mysql_close( Connection handle: 7557620 )

[21:58:32] >> mysql_close() - Invalid connection handle. (You set: 7557620, Highest connection handle ID is 1).

[21:58:32] >> mysql_connect( )

[21:58:32] CMySQLHandler::Connect() - Connection was successful.

[21:58:32] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[21:58:32] >> mysql_ping( Connection handle: 7557620 )

[21:58:32] >> mysql_ping() - Invalid connection handle. (You set: 7557620, Highest connection handle ID is 1).

[21:58:32] >> mysql_connect( )

[21:58:33] CMySQLHandler::Connect() - Connection was successful.

[21:58:33] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[21:58:33] >> mysql_ping( Connection handle: 7557620 )

[21:58:33] >> mysql_ping() - Invalid connection handle. (You set: 7557620, Highest connection handle ID is 1).

[21:58:33] >> mysql_ping( Connection handle: 7557732 )

[21:58:33] >> mysql_ping() - Invalid connection handle. (You set: 7557732, Highest connection handle ID is 1).

[21:58:33] >> mysql_real_escape_string( Connection handle: 0 )

[21:58:33] >> mysql_real_escape_string() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:58:33] >> mysql_query( Connection handle: 0 )

[21:58:33] >> mysql_query() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:58:33] >> mysql_store_result( Connection handle: 0 )

[21:58:33] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:58:33] >> mysql_num_rows( Connection handle: 0 )

[21:58:33] >> mysql_num_rows() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:58:40] >> mysql_ping( Connection handle: 7557344 )

[21:58:40] >> mysql_ping() - Invalid connection handle. (You set: 7557344, Highest connection handle ID is 1).

[21:58:40] >> mysql_close( Connection handle: 7557332 )

[21:58:40] >> mysql_close() - Invalid connection handle. (You set: 7557332, Highest connection handle ID is 1).

[21:58:40] >> mysql_connect( )

[21:58:41] CMySQLHandler::Connect() - Connection was successful.

[21:58:41] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[21:58:41] >> mysql_ping( Connection handle: 7557332 )

[21:58:41] >> mysql_ping() - Invalid connection handle. (You set: 7557332, Highest connection handle ID is 1).

[21:58:41] >> mysql_connect( )

[21:58:41] CMySQLHandler::Connect() - Connection was successful.

[21:58:41] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[21:58:41] >> mysql_ping( Connection handle: 7557332 )

[21:58:41] >> mysql_ping() - Invalid connection handle. (You set: 7557332, Highest connection handle ID is 1).

[21:58:41] >> mysql_ping( Connection handle: 7557344 )

[21:58:41] >> mysql_ping() - Invalid connection handle. (You set: 7557344, Highest connection handle ID is 1).

[21:58:41] >> mysql_real_escape_string( Connection handle: 0 )

[21:58:41] >> mysql_real_escape_string() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:58:41] >> mysql_real_escape_string( Connection handle: 0 )

[21:58:41] >> mysql_real_escape_string() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:58:41] >> mysql_query( Connection handle: 0 )

[21:58:41] >> mysql_query() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:58:41] >> mysql_real_escape_string( Connection handle: 0 )

[21:58:41] >> mysql_real_escape_string() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:58:41] >> mysql_query( Connection handle: 0 )

[21:58:41] >> mysql_query() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:58:41] >> mysql_store_result( Connection handle: 0 )

[21:58:41] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:58:41] >> mysql_num_rows( Connection handle: 0 )

[21:58:41] >> mysql_num_rows() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:58:57] >> mysql_ping( Connection handle: 7557344 )

[21:58:57] >> mysql_ping() - Invalid connection handle. (You set: 7557344, Highest connection handle ID is 1).

[21:58:57] >> mysql_close( Connection handle: 7557332 )

[21:58:57] >> mysql_close() - Invalid connection handle. (You set: 7557332, Highest connection handle ID is 1).

[21:58:57] >> mysql_connect( )

[21:58:57] CMySQLHandler::Connect() - Connection was successful.

[21:58:57] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[21:58:57] >> mysql_ping( Connection handle: 7557332 )

[21:58:57] >> mysql_ping() - Invalid connection handle. (You set: 7557332, Highest connection handle ID is 1).

[21:58:57] >> mysql_connect( )

[21:58:57] CMySQLHandler::Connect() - Connection was successful.

[21:58:57] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[21:58:57] >> mysql_ping( Connection handle: 7557332 )

[21:58:57] >> mysql_ping() - Invalid connection handle. (You set: 7557332, Highest connection handle ID is 1).

[21:58:57] >> mysql_ping( Connection handle: 7557344 )

[21:58:57] >> mysql_ping() - Invalid connection handle. (You set: 7557344, Highest connection handle ID is 1).

[21:58:57] >> mysql_real_escape_string( Connection handle: 0 )

[21:58:57] >> mysql_real_escape_string() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:58:57] >> mysql_real_escape_string( Connection handle: 0 )

[21:58:57] >> mysql_real_escape_string() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:58:57] >> mysql_query( Connection handle: 0 )

[21:58:57] >> mysql_query() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:58:57] >> mysql_real_escape_string( Connection handle: 0 )

[21:58:57] >> mysql_real_escape_string() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:58:57] >> mysql_query( Connection handle: 0 )

[21:58:57] >> mysql_query() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:58:57] >> mysql_store_result( Connection handle: 0 )

[21:58:57] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:58:57] >> mysql_num_rows( Connection handle: 0 )

[21:58:57] >> mysql_num_rows() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:59:07] >> mysql_ping( Connection handle: 7557344 )

[21:59:07] >> mysql_ping() - Invalid connection handle. (You set: 7557344, Highest connection handle ID is 1).

[21:59:07] >> mysql_close( Connection handle: 7557332 )

[21:59:07] >> mysql_close() - Invalid connection handle. (You set: 7557332, Highest connection handle ID is 1).

[21:59:07] >> mysql_connect( )

[21:59:07] CMySQLHandler::Connect() - Connection was successful.

[21:59:07] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[21:59:07] >> mysql_ping( Connection handle: 7557332 )

[21:59:07] >> mysql_ping() - Invalid connection handle. (You set: 7557332, Highest connection handle ID is 1).

[21:59:07] >> mysql_connect( )

[21:59:08] CMySQLHandler::Connect() - Connection was successful.

[21:59:08] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[21:59:08] >> mysql_ping( Connection handle: 7557332 )

[21:59:08] >> mysql_ping() - Invalid connection handle. (You set: 7557332, Highest connection handle ID is 1).

[21:59:08] >> mysql_ping( Connection handle: 7557344 )

[21:59:08] >> mysql_ping() - Invalid connection handle. (You set: 7557344, Highest connection handle ID is 1).

[21:59:08] >> mysql_real_escape_string( Connection handle: 0 )

[21:59:08] >> mysql_real_escape_string() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:59:08] >> mysql_real_escape_string( Connection handle: 0 )

[21:59:08] >> mysql_real_escape_string() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:59:08] >> mysql_query( Connection handle: 0 )

[21:59:08] >> mysql_query() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:59:08] >> mysql_real_escape_string( Connection handle: 0 )

[21:59:08] >> mysql_real_escape_string() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:59:08] >> mysql_query( Connection handle: 0 )

[21:59:08] >> mysql_query() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:59:08] >> mysql_store_result( Connection handle: 0 )

[21:59:08] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:59:08] >> mysql_num_rows( Connection handle: 0 )

[21:59:08] >> mysql_num_rows() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[23:36:07]

---

Re: Heres my server - Deltac0_ - 10.12.2011

Theres your problem.

---

Re: Heres my server - FreedomtoLive - 10.12.2011

Can you help me fix it Deltac0?

---

Re: Heres my server - FreedomtoLive - 10.12.2011

Looked through the Database.SQL nothing is set at 7557332? wtf? How do I fix it?

---

Re: Heres my server - Johnson_boy - 11.12.2011

have you defined the connection variable?

new connection;
connection = mysql_connect...

Might be wrong syntax depending on your plugin but gives the idea

---