SA-MP Forums Archive
Mysql problem rows - 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 problem rows (/showthread.php?tid=605205)



Mysql problem rows - ShoortyFl - 15.04.2016

I have a huge problem, something is being messed up while loading from mysql base,
look at th elog:

http://imgur.com/a/4uUE2

Quote:

[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')

Pictures:


This is loading:
pawn Code:
case THREAD_UCITAJSTANOVE:
        {
            if(szRows)
            {
                new temp[64];
                for(new i = 0; i <= szRows; i++)
                {
                    cache_get_field_content(i, "ID",  temp);
                    SInfo[i][sID] = strval(temp);

                    cache_get_field_content(i, "ImaVlasnika", temp);
                    SInfo[i][ImaVlasnika] = strval(temp);

                    cache_get_field_content(i, "Vlasnik", temp);
                    format(SInfo[i][Vlasnik], 50, "%s", temp);

                    cache_get_field_content(i, "Adresa", temp);
                    format(SInfo[i][Adresa], 32, "%s", temp);

                    cache_get_field_content(i, "UlazX", temp);
                    SInfo[i][UlazX] = floatstr(temp);

                    cache_get_field_content(i, "UlazY", temp);
                    SInfo[i][UlazY] = floatstr(temp);

                    cache_get_field_content(i, "UlazZ", temp);
                    SInfo[i][UlazZ] = floatstr(temp);

                    cache_get_field_content(i, "UlazA", temp);
                    SInfo[i][UlazA] = floatstr(temp);

                    cache_get_field_content(i, "IzlazX", temp);
                    SInfo[i][IzlazX] = floatstr(temp);

                    cache_get_field_content(i, "IzlazY", temp);
                    SInfo[i][IzlazY] = floatstr(temp);

                    cache_get_field_content(i, "IzlazZ", temp);
                    SInfo[i][IzlazZ] = floatstr(temp);

                    cache_get_field_content(i, "IzlazA", temp);
                    SInfo[i][IzlazA] = floatstr(temp);

                    cache_get_field_content(i, "Zakljucano", temp);
                    SInfo[i][Zakljucano] = strval(temp);

                    cache_get_field_content(i, "Cena", temp);
                    SInfo[i][Cena] = strval(temp);

                    cache_get_field_content(i, "VW", temp);
                    SInfo[i][VW] = strval(temp);

                    cache_get_field_content(i, "Interior", temp);
                    SInfo[i][Interior] = strval(temp);

                    cache_get_field_content(i, "sLevel", temp);
                    SInfo[i][Level] = strval(temp);

                    new str[269];
                    if(SInfo[i][ImaVlasnika] == 0)
                    {
                        format(str, sizeof(str), "{F3FF02}Stan na prodaju\n{FFFFFF}Cena: {F3FF02}$%d\n{FFFFFF}Level: {F3FF02}%d\n{FFFFFF}Adresa: {F3FF02}%s", SInfo[i][Cena], SInfo[i][Level], SInfo[i][Adresa]);

                        StanLabel[i] = CreateDynamic3DTextLabel(str, 0x00FF00AA, SInfo[i][UlazX], SInfo[i][UlazY], SInfo[i][UlazZ], 10, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);
                        StanPickup[i] = CreateDynamicPickup(1273, 1, SInfo[i][UlazX], SInfo[i][UlazY], SInfo[i][UlazZ]);
                    }
                    else if(SInfo[i][ImaVlasnika] == 1)
                    {
                        format(str, sizeof(str), "{FFFFFF}Vlasnik Stana: {F3FF02}%s\n{FFFFFF}Level: {F3FF02}%d\n{FFFFFF}Adresa: {F3FF02}%s", SInfo[i][Vlasnik], SInfo[i][Level], SInfo[i][Adresa]);

                        StanLabel[i] = CreateDynamic3DTextLabel(str, 0x00FF00AA, SInfo[i][UlazX], SInfo[i][UlazY], SInfo[i][UlazZ], 10, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);
                        StanPickup[i] = CreateDynamicPickup(1273, 1, SInfo[i][UlazX], SInfo[i][UlazY], SInfo[i][UlazZ]);
                    }
                }
                printf("Elite Team - Server je ucitao %d stanova", szRows);
                SpawnedStanova = szRows;
            }
        }
IDs are not AI, and idk if they should be, please help


Re: Mysql problem rows - Konstantinos - 16.04.2016

Replace:
pawn Code:
for(new i = 0; i <= szRows; i++)
to:
pawn Code:
for(new i = 0; i < szRows; i++)