mysql_log warning - 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_log warning (/showthread.php?tid=464568)
+- 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_log warning (/showthread.php?tid=464568)
mysql_log warning - AphexCCFC - 17.09.2013
What is this?:
pawn Код:
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('4')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('5')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('6')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('7')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('8')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('9')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('10')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('11')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('12')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('13')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('14')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('15')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('16')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('17')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('18')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('19')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('20')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('21')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('25')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('26')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('27')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('28')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('29')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('30')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('31')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('32')
[18:09:30] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('33')
Code:
pawn Код:
PlayerInfo[playerid][pGender] = cache_get_row_int(0, 4, dbHandle);
PlayerInfo[playerid][pCash] = cache_get_row_int(0, 5, dbHandle);
PlayerInfo[playerid][pBank] = cache_get_row_int(0, 6, dbHandle);
PlayerInfo[playerid][pBankReg] = cache_get_row_int(0, 7, dbHandle);
PlayerInfo[playerid][pLevel] = cache_get_row_int(0, 8, dbHandle);
PlayerInfo[playerid][pSkin] = cache_get_row_int(0, 9, dbHandle);
PlayerInfo[playerid][pAdmin] = cache_get_row_int(0, 10, dbHandle);
PlayerInfo[playerid][pAdminDuty] = cache_get_row_int(0, 11, dbHandle);
PlayerInfo[playerid][pOwner] = cache_get_row_int(0, 12, dbHandle);
PlayerInfo[playerid][pJob] = cache_get_row_int(0, 13, dbHandle);
PlayerInfo[playerid][pInterior] = cache_get_row_int(0, 14, dbHandle);
PlayerInfo[playerid][pVirtualWorld] = cache_get_row_int(0, 15, dbHandle);
PlayerInfo[playerid][pNewbMute] = cache_get_row_int(0, 16, dbHandle);
PlayerInfo[playerid][pGetHouseID] = cache_get_row_int(0, 17, dbHandle);
PlayerInfo[playerid][pVehID] = cache_get_row_int(0, 18, dbHandle);
PlayerInfo[playerid][pVehName] = cache_get_row_int(0, 19, dbHandle);
PlayerInfo[playerid][pVehX] = cache_get_row_int(0, 20, dbHandle);
PlayerInfo[playerid][pVehY] = cache_get_row_int(0, 21, dbHandle);
PlayerInfo[playerid][pVehZ] = cache_get_row_int(0, 22, dbHandle);
PlayerInfo[playerid][pVehA] = cache_get_row_int(0, 23, dbHandle);
PlayerInfo[playerid][pVeh2ID] = cache_get_row_int(0, 24, dbHandle);
PlayerInfo[playerid][pVeh2Name] = cache_get_row_int(0, 25, dbHandle);
PlayerInfo[playerid][pVeh2X] = cache_get_row_int(0, 26, dbHandle);
PlayerInfo[playerid][pVeh2Y] = cache_get_row_int(0, 27, dbHandle);
PlayerInfo[playerid][pVeh2Z] = cache_get_row_int(0, 28, dbHandle);
PlayerInfo[playerid][pVeh2A] = cache_get_row_int(0, 29, dbHandle);
PlayerInfo[playerid][pPos][0] = cache_get_row_float(0, 30, dbHandle);
PlayerInfo[playerid][pPos][1] = cache_get_row_float(0, 31, dbHandle);
PlayerInfo[playerid][pPos][2] = cache_get_row_float(0, 32, dbHandle);
PlayerInfo[playerid][pPos][3] = cache_get_row_float(0, 33, dbHandle);
Thanks in advance
Re: mysql_log warning - Konstantinos - 17.09.2013
Do a debug:
pawn Код:
new rows, fields;
cache_get_data(rows, fields, dbHandle);
printf( "rows: %d | fields: %d", rows, fields );
if(rows)
{
PlayerInfo[playerid][pGender] = cache_get_row_int(0, 4, dbHandle);
// rest
Re: mysql_log warning - AphexCCFC - 17.09.2013
It says:
rows: 1 | fields: 34
I'm guessing that would be correct cause only one account is registered and there are 34 fields (starting from 0 using cache_get_row)
Re: mysql_log warning - Konstantinos - 17.09.2013
What have you selected? All (*) or specific fields?
Also, try running the query via phpMyAdmin and see if it returns the correct values.
Re: mysql_log warning - AphexCCFC - 17.09.2013
All (*), yeah.