1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Heres my server
FreedomtoLive
Big Clucker
***
Posts: 70
Threads: 30
Joined: Nov 2011
Reputation: 0
#1

10.12.2011, 16:24
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?



Find
Reply
Dark_Kostas
Gangsta
****
Posts: 543
Threads: 7
Joined: Dec 2007
Reputation: 0
#2

10.12.2011, 17:01
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
Find
Reply
Johnson_boy
Huge Clucker
***
Posts: 215
Threads: 25
Joined: Mar 2011
Reputation: 0
#3

10.12.2011, 17:02
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.
Find
Reply
FreedomtoLive
Big Clucker
***
Posts: 70
Threads: 30
Joined: Nov 2011
Reputation: 0
#4

10.12.2011, 17:11
Quote:
Originally Posted by Johnson_boy
Посмотреть сообщение
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.
[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]
Find
Reply
Deltac0_
Little Clucker
**
Posts: 12
Threads: 1
Joined: Dec 2011
Reputation: 0
#5

10.12.2011, 17:17
Quote:
Originally Posted by FreedomtoLive
Посмотреть сообщение
[21:58:00] >> mysql_ping() - Invalid connection handle. (You set: 7557736, Highest connection handle ID is 1).
Theres your problem.
Find
Reply
FreedomtoLive
Big Clucker
***
Posts: 70
Threads: 30
Joined: Nov 2011
Reputation: 0
#6

10.12.2011, 17:20
Quote:
Originally Posted by Deltac0_
Посмотреть сообщение
Theres your problem.
Can you help me fix it Deltac0?
Find
Reply
FreedomtoLive
Big Clucker
***
Posts: 70
Threads: 30
Joined: Nov 2011
Reputation: 0
#7

10.12.2011, 17:29
Looked through the Database.SQL nothing is set at 7557332? wtf? How do I fix it?
Find
Reply
Johnson_boy
Huge Clucker
***
Posts: 215
Threads: 25
Joined: Mar 2011
Reputation: 0
#8

11.12.2011, 09:11
have you defined the connection variable?

new connection;
connection = mysql_connect...

Might be wrong syntax depending on your plugin but gives the idea
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help