[AphexCCFC]

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')

It still loads the database rows but this error always occurs in mysql_log.

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);

Database rows:





Thanks in advance

[Konstantinos]

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

[AphexCCFC]

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)

[Konstantinos]

What have you selected? All (*) or specific fields?

Also, try running the query via phpMyAdmin and see if it returns the correct values.

[AphexCCFC]

All (*), yeah.