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

Threaded Mode
database mysql no load invalid datatype
Izaki
Big Clucker
***
Posts: 81
Threads: 38
Joined: Sep 2014
Reputation: 0
#1

14.07.2016, 19:08
DEBUG MYSQL
PHP Code:
[02:01:55] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "database", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[02:01:55] [DEBUG] CMySQLHandle::Create - creating new connection..
[02:01:55] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[02:01:55] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[02:01:55] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[02:01:55] [DEBUG] CMySQLConnection::Connect - connection was successful
[02:01:55] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[02:01:55] [DEBUG] mysql_errno - connection: 1
[02:01:55] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[02:01:55] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[02:01:55] [DEBUG] CMySQLConnection::Connect - connection was successful
[02:01:55] [DEBUG] CMySQLConnection::Connect - connection was successful
[02:01:55] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[02:01:55] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[02:01:55] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[02:02:22] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `users` WHERE `Name` = '%e' LIMIT 1"
[02:02:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `users` WHERE `Name` = 'damar' LIMI", callback: "OnAccountCheck", format: "i"
[02:02:22] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[02:02:22] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 1.174 milliseconds
[02:02:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[02:02:22] [DEBUG] Calling callback "OnAccountCheck"..
[02:02:22] [DEBUG] cache_get_data - connection: 1
[02:02:22] [DEBUG] cache_get_field_content - row: 0, field_name: "Password", connection: 1, max_len: 129
[02:02:22] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Password", data: "FD9D94340DBD72C11B37EBB0D2A19B4D05E00FD78E4E2CE8923B9EA3A54E900DF181CFB112A8A73228D1F3551680E2AD9701A4FCFB248FA7FA77B95180628BB2"
[02:02:22] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[02:02:22] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "2"
[02:02:22] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[02:02:27] [DEBUG] mysql_format - connection: 1, len: 214, format: "SELECT * FROM `users` WHERE `Name` = '%e'"
[02:02:27] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `users` WHERE `Name` = ''", callback: "OnAccountLoad", format: "i"
[02:02:27] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - starting query execution
[02:02:27] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - query was successfully executed within 0.479 milliseconds
[02:02:27] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[02:02:27] [DEBUG] Calling callback "OnAccountLoad"..
[02:02:27] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[02:02:27] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[02:02:27] [ERROR] cache_get_field_content_int - invalid datatype
[02:02:27] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pEXP", connection: 1
[02:02:27] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[02:02:27] [ERROR] cache_get_field_content_int - invalid datatype
[02:02:27] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pAdminLevel", connection: 1
[02:02:27] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[02:02:27] [ERROR] cache_get_field_content_int - invalid datatype
[02:02:27] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Premium", connection: 1
[02:02:27] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[02:02:27] [ERROR] cache_get_field_content_int - invalid datatype
[02:02:27] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[02:02:57] [DEBUG] mysql_format - connection: 1, len: 526, format: "UPDATE `users` SET `pEXP` = '%d', `Premium` = %d, `pAdminLevel` = %d WHERE `Name` = '%s'"
[02:02:57] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `users` SET `pEXP` = '10000', `Premium` = 0, `pAdminLevel", callback: "(null)", format: "(null)"
[02:02:57] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[02:02:57] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 55.29 milliseconds
[02:02:57] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving 
scipt AccountLoad
PHP Code:
forward OnAccountLoad(playerid);
public OnAccountLoad(playerid)
{
    pInfo[playerid][ID] = cache_get_field_content_int(0, "ID");
    pInfo[playerid][pEXP] = cache_get_field_content_int(0, "pEXP");
    pInfo[playerid][pAdminLevel] = cache_get_field_content_int(0, "pAdminLevel");
    pInfo[playerid][Premium] = cache_get_field_content_int(0, "Premium");
    TogglePlayerSpectating(playerid, false);
    GivePlayerMoney(playerid, pInfo[playerid][pEXP]);
    SendClientMessage(playerid, -1, "You have successfully logged in.");
    SpawnPlayer(playerid);
    return 1;
} 
scipt save player
PHP Code:
stock SaveStats(playerid)
{
    new query[526];
    mysql_format(mysql, query, sizeof(query), "UPDATE `users` SET `pEXP` = '%d', `Premium` = %d, `pAdminLevel` = %d WHERE `Name` = '%s'",
    pInfo[playerid][pEXP], pInfo[playerid][Premium], pInfo[playerid][pAdminLevel], PlayerName(playerid));
    mysql_tquery(mysql, query);
    return 1;
} 
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#2

14.07.2016, 21:31
Code:
"SELECT * FROM `users` WHERE `Name` = ''"
Name is empty. That also causes the invalid row as there are no records for that.
Re-look your code when selecting all the data and since you have loaded the ID along with password, use that in the WHERE clause instead of the name.
Find
Reply
Izaki
Big Clucker
***
Posts: 81
Threads: 38
Joined: Sep 2014
Reputation: 0
#3

14.07.2016, 21:34
PHP Code:
stock SaveStats(playerid)
{
    new query[2048];
    format(query, sizeof(query), "UPDATE `users` SET `pEXP` = '%d', `Premium` = %d, `pAdminLevel` = %d WHERE `Name` = ''",
    pInfo[playerid][pEXP], pInfo[playerid][Premium], pInfo[playerid][pAdminLevel], PlayerName(playerid));
    mysql_tquery(mysql, query, "","");
    return 1;
} 
so ?
Find
Reply
Izaki
Big Clucker
***
Posts: 81
Threads: 38
Joined: Sep 2014
Reputation: 0
#4

14.07.2016, 21:36
PHP Code:
[04:34:30] [DEBUG] Calling callback "LoadAkun"..
[04:34:30] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[04:34:30] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[04:34:30] [ERROR] cache_get_field_content_int - invalid datatype
[04:34:30] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pEXP", connection: 1
[04:34:30] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[04:34:30] [ERROR] cache_get_field_content_int - invalid datatype
[04:34:30] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pAdminLevel", connection: 1
[04:34:30] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[04:34:30] [ERROR] cache_get_field_content_int - invalid datatype
[04:34:30] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Premium", connection: 1
[04:34:30] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[04:34:30] [ERROR] cache_get_field_content_int - invalid datatype
[04:34:30] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[04:34:39] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `users` SET `pEXP` = '123124', `Premium` = 0, `pAdminLeve", callback: "(null)", format: "(null)"
[04:34:39] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[04:34:39] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.601 milliseconds
[04:34:39] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving 
Still not fix
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#5

14.07.2016, 21:40
I pointed out what is wrong (what is written in mysql logs), not that it should be empty.. Change the above as it was and the problem is here:
pawn Code:
"SELECT * FROM `users` WHERE `Name` = '%e'"
When formatting, name is empty so you don't get the player's name. A better option is to use:
pawn Code:
..., "SELECT * FROM `users` WHERE `ID` = %i LIMIT 1", pInfo[playerid][ID]);
Find
Reply
Izaki
Big Clucker
***
Posts: 81
Threads: 38
Joined: Sep 2014
Reputation: 0
#6

14.07.2016, 21:49
PHP Code:
[04:46:35] [DEBUG] Calling callback "LoadAkun"..
[04:46:35] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[04:46:35] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "3"
[04:46:35] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pEXP", connection: 1
[04:46:35] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pEXP", data: "0"
[04:46:35] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pAdminLevel", connection: 1
[04:46:35] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pAdminLevel", data: "10"
[04:46:35] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Premium", connection: 1
[04:46:35] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Premium", data: "0"
[04:46:35] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called 
Thanks Konstatinopel i REP ++++ SOLVED OMG
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