PDA

Просмотр полной версии : [Вопрос] Ошибки в логах Mysql



ALIT13
03.05.2018, 22:18
Проблемы в загрузке
[01:05:52] [ERROR] cache_get_value_name_int: invalid row index '1' (number of rows: '1') (C:\Users\User\Desktop\X-NetRP\gamemodes\new.pwn:12280)
[01:05:52] [ERROR] cache_get_value_name_int: invalid row index '1' (number of rows: '1') (C:\Users\User\Desktop\X-NetRP\gamemodes\new.pwn:12281)
[01:05:52] [ERROR] cache_get_value_name_int: invalid row index '1' (number of rows: '1') (C:\Users\User\Desktop\X-NetRP\gamemodes\new.pwn:12235)
[01:05:52] [ERROR] cache_get_value_name_int: invalid row index '1' (number of rows: '1') (C:\Users\User\Desktop\X-NetRP\gamemodes\new.pwn:12236)
[01:06:19] [ERROR] cache_get_value_name_int: field 'Exp' not found (C:\Users\User\Desktop\X-NetRP\gamemodes\new.pwn:8369)
[01:06:19] [ERROR] cache_get_value_name_int: field 'Smoke' not found (C:\Users\User\Desktop\X-NetRP\gamemodes\new.pwn:8400)


Строчки в которых ошибки
new time = GetTickCount();
new rows;
cache_get_row_count(rows);
if(rows)
{
for(new idx = 1; idx <= rows; idx++)
{
cache_get_value_name_int(idx,"bID", BizzInfo[idx][bID]); //тут 12280
cache_get_value_name_int(idx,"bOwned", BizzInfo[idx][bOwned]);//тут 12281

public OnBizzLoad()
{
new time = GetTickCount();
new bizmsg[126];
new rows;
cache_get_row_count(rows);
if(rows)
{
for(new idx = 1; idx <= rows; idx++)
{
cache_get_value_name_int(idx,"oID", OtelInfo[idx][oID]); // 12235
cache_get_value_name_int(idx,"oOwned", OtelInfo[idx][oOwned]); // 12236


cache_get_value_name_int(0,"admin",PlayerInfo[i][Admin]);
cache_get_value_name_int(0,"score",PlayerInfo[i][Level]);
cache_get_value_name_int(0,"Exp",PlayerInfo[i][Exp]);// 8369
cache_get_value_name_int(0,"Smoke",PlayerInfo[i][Smoke]);//8400

StevenH
03.05.2018, 22:23
cache_get_value_name_int(0,"Exp",PlayerInfo[i][Exp]);// 8369
cache_get_value_name_int(0,"Smoke",PlayerInfo[i][Smoke]);//8400


Колонок Exp и Smoke нет в таблице

ALIT13
03.05.2018, 22:29
Всё есть !

- - - Добавлено - - -

Правильно же перевёл
PlayerInfo[i][Admin] = cache_get_field_content_int(0, "admin", connectsql);
PlayerInfo[i][Level] = cache_get_field_content_int(0, "score", connectsql);
PlayerInfo[i][Exp] = cache_get_field_content_int(0, "Exp", connectsql);
PlayerInfo[i][Money] = cache_get_field_content_int(0, "money", connectsql);
PlayerInfo[i][Sex] = cache_get_field_content_int(0, "sex", connectsql);
PlayerInfo[i][Skin] = cache_get_field_content_int(0, "skin", connectsql);
cache_get_field_content(0, "mail",PlayerInfo[i][Mail],connectsql,32);
PlayerInfo[i][Member] = cache_get_field_content_int(0, "member", connectsql);
PlayerInfo[i][Rasa] = cache_get_field_content_int(0, "rasa", connectsql);
PlayerInfo[i][Reg] = cache_get_field_content_int(0, "reg", connectsql);
cache_get_field_content(0, "adminkey", PlayerInfo[i][Adminkey],connectsql,32);
PlayerInfo[i][Housekey] = cache_get_field_content_int(0, "housekey", connectsql);
cache_get_field_content(0, "rip", PlayerInfo[i][Ip],connectsql,16);
cache_get_field_content(0, "lip", PlayerInfo[i][lIp],connectsql,16);
PlayerInfo[i][Mute] = cache_get_field_content_int(0, "mute", connectsql);
PlayerInfo[i][Moneyhouse] = cache_get_field_content_int(0, "moneyhouse", connectsql);
PlayerInfo[i][Rentkey] = cache_get_field_content_int(0, "rentkey", connectsql);
PlayerInfo[i][Bank] = cache_get_field_content_int(0, "bank", connectsql);
PlayerInfo[i][Bizzkey] = cache_get_field_content_int(0, "bizzkey", connectsql);
PlayerInfo[i][Rang] = cache_get_field_content_int(0, "rang", connectsql);
PlayerInfo[i][Leader] = cache_get_field_content_int(0, "leader", connectsql);
PlayerInfo[i][Fracskin] = cache_get_field_content_int(0, "fracskin", connectsql);
PlayerInfo[i][Warn] = cache_get_field_content_int(0, "warn", connectsql);
PlayerInfo[i][WarnTime] = cache_get_field_content_int(0, "warntime", connectsql);
cache_get_field_content(0, "gun", guns,connectsql,sizeof(guns));
cache_get_field_content(0, "gunammo", ammo,connectsql,sizeof(ammo));
cache_get_field_content(0, "crimewho", PlayerInfo[i][CrimeWho],connectsql,32);
cache_get_field_content(0, "crime", PlayerInfo[i][Crime],connectsql,32);
PlayerInfo[i][JailTime] = cache_get_field_content_int(0, "jailtime", connectsql);
PlayerInfo[i][WantedLevel] = cache_get_field_content_int(0, "wantedlevel", connectsql);
PlayerInfo[i][Jail] = cache_get_field_content_int(0, "jail", connectsql);
PlayerInfo[i][Clock] = cache_get_field_content_int(0, "clock", connectsql);
PlayerInfo[i][Phone] = cache_get_field_content_int(0, "Phone", connectsql);
PlayerInfo[i][PhoneNumber] = cache_get_field_content_int(0, "PhoneNumber", connectsql);
PlayerInfo[i][Smoke] = cache_get_field_content_int(0, "Smoke", connectsql);
PlayerInfo[i][DeadSpawn] = cache_get_field_content_int(0, "DeadSpawn", connectsql);
PlayerInfo[i][Heal] = cache_get_field_content_float(0, "Heal", connectsql);
PlayerInfo[i][Armour] = cache_get_field_content_float(0, "Armour", connectsql);
PlayerInfo[i][PhoneBalance] = cache_get_field_content_int(0, "PhoneBalance", connectsql);

на
cache_get_value_name_int(0,"admin",PlayerInfo[i][Admin]);
cache_get_value_name_int(0,"score",PlayerInfo[i][Level]);
cache_get_value_name_int(0,"exp",PlayerInfo[i][Exp]);
cache_get_value_name_int(0,"money",PlayerInfo[i][Money]);
cache_get_value_name_int(0,"sex",PlayerInfo[i][Skin]);
cache_get_value_name(0, "mail", PlayerInfo[i][Mail],32);
cache_get_value_name_int(0,"member",PlayerInfo[i][Member]);
cache_get_value_name_int(0,"rasa",PlayerInfo[i][Rasa]);
cache_get_value_name_int(0,"reg",PlayerInfo[i][Reg]);
cache_get_value_name(0, "adminkey", PlayerInfo[i][Adminkey],32);
cache_get_value_name_int(0,"housekey",PlayerInfo[i][Housekey]);
cache_get_value_name(0, "rip", PlayerInfo[i][Ip],16);
cache_get_value_name(0, "lip", PlayerInfo[i][lIp],16);
cache_get_value_name_int(0,"mute",PlayerInfo[i][Mute]);
cache_get_value_name_int(0,"moneyhouse",PlayerInfo[i][Moneyhouse]);
cache_get_value_name_int(0,"rentkey",PlayerInfo[i][Rentkey]);
cache_get_value_name_int(0,"bank",PlayerInfo[i][Bank]);
cache_get_value_name_int(0,"bizzkey",PlayerInfo[i][Bizzkey]);
cache_get_value_name_int(0,"rang",PlayerInfo[i][Leader]);
cache_get_value_name_int(0,"leader",PlayerInfo[i][Leader]);
cache_get_value_name_int(0,"fracskin",PlayerInfo[i][Fracskin]);
cache_get_value_name_int(0,"warn",PlayerInfo[i][Warn]);
cache_get_value_name_int(0,"warntime",PlayerInfo[i][WarnTime]);
cache_get_value_name(0, "gun", guns, sizeof(guns));
cache_get_value_name(0, "gunammo", ammo, sizeof(ammo));
cache_get_value_name(0, "crimewho", PlayerInfo[i][CrimeWho], 32);
cache_get_value_name(0, "crime", PlayerInfo[i][Crime], 32);
cache_get_value_name_int(0,"jailtime",PlayerInfo[i][JailTime]);
cache_get_value_name_int(0,"wantedlevel",PlayerInfo[i][WantedLevel]);
cache_get_value_name_int(0,"jail",PlayerInfo[i][Jail]);
cache_get_value_name_int(0,"clock",PlayerInfo[i][Clock]);
cache_get_value_name_int(0,"Phone",PlayerInfo[i][Phone]);
cache_get_value_name_int(0,"PhoneNumber",PlayerInfo[i][PhoneNumber]);
cache_get_value_name_int(0,"Smoke",PlayerInfo[i][Smoke]);
cache_get_value_name_int(0,"DeadSpawn",PlayerInfo[i][DeadSpawn]);
cache_get_value_name_float(0,"Heal",PlayerInfo[i][Heal]);
cache_get_value_name_float(0,"Armour",PlayerInfo[i][Armour]);
cache_get_value_name_int(0,"PhoneBalance",PlayerInfo[i][PhoneBalance]);

StevenH
03.05.2018, 22:57
ALIT13, однако в логах пишется обратное. Да даже в Google Translate ты мог спокойно перевести: поле «Exp» не найдено, поле «Smoke» не найдено

pawnoholic
04.05.2018, 22:27
for(new idx = 1; idx <= rows; idx++)

Отчет rows начинается с нуля.

for (new i; i < rows; i++)