[Obcido]

I am using a mysql server in my VPS. I have uploaded my database to it. Something's wrong with it, when i log in, it says "This player is registered", when i put the correct password, it says it's the wrong password, and even if the player isn't registered, it says that it is.

Mysql_log

Код:

[12:59:42] >> mysql_connect(localhost, root, osrp, ******) on port 3306
[12:59:42] CMySQLHandler::CMySQLHandler() - constructor called.
[12:59:42] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "osrp" | Username: "root"
[12:59:42] CMySQLHandler::Connect() - Connection was successful.
[12:59:42] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[12:59:42] >> mysql_ping( Connection handle: 1 )
[12:59:42] CMySQLHandler::Ping() - Connection is still alive.
[12:59:43] [ERROR] "mysql_query" - invalid connection handle (ID = 9789868)
[12:59:43] >> mysql_store_result( Connection handle: 1 )
[12:59:43] CMySQLHandler::StoreResult() - No data to store.
[12:59:43] >> mysql_num_rows( Connection handle: 1 )
[12:59:43] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[12:59:43] >> mysql_retrieve_row( Connection handle: 1 )
[12:59:43] CMySQLHandler::RetrieveRow() - You cannot call this function now. (Reason: Empty Result)
[13:00:08] [ERROR] "mysql_query" - invalid connection handle (ID = 9789776)
[13:00:08] >> mysql_store_result( Connection handle: 1 )
[13:00:08] CMySQLHandler::StoreResult() - No data to store.
[13:00:08] >> mysql_num_rows( Connection handle: 1 )
[13:00:08] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[13:00:08] >> mysql_free_result( Connection handle: 1 )
[13:00:08] CMySQLHandler::FreeResult() - The result is already empty.
[13:00:11] [ERROR] "mysql_query" - invalid connection handle (ID = 9770396)
[13:00:11] >> mysql_store_result( Connection handle: 1 )
[13:00:11] CMySQLHandler::StoreResult() - No data to store.
[13:00:11] >> mysql_num_rows( Connection handle: 1 )
[13:00:11] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[13:00:11] >> mysql_free_result( Connection handle: 1 )
[13:00:11] CMySQLHandler::FreeResult() - The result is already empty.
[13:00:11] [ERROR] "mysql_query" - invalid connection handle (ID = 9769848)
[13:00:11] >> mysql_store_result( Connection handle: 1 )
[13:00:11] CMySQLHandler::StoreResult() - No data to store.
[13:00:11] >> mysql_retrieve_row( Connection handle: 1 )
[13:00:11] CMySQLHandler::RetrieveRow() - You cannot call this function now. (Reason: Empty Result)
[13:00:11] >> mysql_fetch_field_row( Connection handle: 1 )
[13:00:11] CMySQLHandler::FetchField(Key) - You cannot call this function now. (Reason: Fields/Rows are empty.)
[13:00:11] >> mysql_free_result( Connection handle: 1 )
[13:00:11] CMySQLHandler::FreeResult() - The result is already empty.
[13:00:20] [ERROR] "mysql_query" - invalid connection handle (ID = 9770396)
[13:00:20] >> mysql_store_result( Connection handle: 1 )
[13:00:20] CMySQLHandler::StoreResult() - No data to store.
[13:00:20] >> mysql_num_rows( Connection handle: 1 )
[13:00:20] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[13:00:20] >> mysql_free_result( Connection handle: 1 )
[13:00:20] CMySQLHandler::FreeResult() - The result is already empty.
[13:00:20] [ERROR] "mysql_query" - invalid connection handle (ID = 9769848)
[13:00:20] >> mysql_store_result( Connection handle: 1 )
[13:00:20] CMySQLHandler::StoreResult() - No data to store.
[13:00:20] >> mysql_retrieve_row( Connection handle: 1 )
[13:00:20] CMySQLHandler::RetrieveRow() - You cannot call this function now. (Reason: Empty Result)
[13:00:20] >> mysql_fetch_field_row( Connection handle: 1 )
[13:00:20] CMySQLHandler::FetchField(Key) - You cannot call this function now. (Reason: Fields/Rows are empty.)
[13:00:20] >> mysql_free_result( Connection handle: 1 )
[13:00:20] CMySQLHandler::FreeResult() - The result is already empty.
[13:00:20] [ERROR] "mysql_query" - invalid connection handle (ID = 9768644)
[13:00:20] >> mysql_store_result( Connection handle: 1 )
[13:00:20] CMySQLHandler::StoreResult() - No data to store.
[13:00:20] >> mysql_num_rows( Connection handle: 1 )
[13:00:20] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[13:00:20] >> mysql_free_result( Connection handle: 1 )
[13:00:20] CMySQLHandler::FreeResult() - The result is already empty.
[13:06:16] >> mysql_close( Connection handle: 1 )
[13:06:16] CMySQLHandler::~CMySQLHandler() - deconstructor called.
[13:06:16] CMySQLHandler::FreeResult() - The result is already empty.
[13:06:16] CMySQLHandler::Disconnect() - Connection was closed.
[13:06:16] Unloading Plugin

[Riddy]

How do you define connection handle?

Do you use a variable? or do you just put mysql_something(0 (connection handle))?

[Obcido]

I don't think i know what you mean. You see, i'm not the best in these things...

[Riddy]

Look for mysql_connect. Post the whole line here. Now, look for mysql_query and post one of the lines here.

[Obcido]

Like this?
mysql_connect(values[0], values[2], values[1], values[3]);

and this

mysql_query(query);

[Obcido]

bump

[Obcido]

bump