MySQL

[28]

Приветствую, так как я не особо разбираюсь в MySQL, решил попросить у вас помощи.
Суть проблемы такова: При входе на сервер появляются ошибки в Mysql.LOG.

  MySQL.LOG (открыть спойлер)

[15:54:33] [ERROR] cache_get_row_int - invalid datatype
[15:54:33] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('154')
[15:54:33] [ERROR] cache_get_row_int - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_int - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_int - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_int - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_int - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_int - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_int - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_int - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_int - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_int - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_int - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_int - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_float - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_float - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_float - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_float - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_int - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_int - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_int - invalid datatype
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:33] [ERROR] cache_get_field_content_int - invalid datatype

 

  Code (открыть спойлер)

	new string[2100], style, name[60], pass[70];
	AntiCheatsOFF(playerid, 2);
	PlayerInfo[playerid][pID] = cache_get_row_int(0, 0, mysql); //ID 1
	cache_get_row(0, 1, name, mysql); //NickName2
	cache_get_row(0, 2, pass, mysql); //Password3
	cache_get_row(0, 3, PlayerRegIP[playerid], mysql,16); //RegIP4
	cache_get_row(0, 4, PlayerIp[playerid], mysql,16); //OldIP5
	cache_get_row(0, 5, PlayerCheckIP1[playerid], mysql,16); //CheckIP6
	cache_get_row(0, 6, PlayerCheckIP2[playerid],  mysql,16);//CheckIP7
	cache_get_row(0, 7, PlayerReferal[playerid],  mysql,24);//Referal8
	cache_get_row(0, 8, PlayerMail[playerid], mysql,50); //Mail9
	cache_get_row(0, 9, PlayerTelephone[playerid], mysql,20); //Telephone0
	cache_get_row(0, 10, PlayerFName[playerid], mysql,30); //Name1

	PlayerInfo[playerid][pLevel] = cache_get_row_int(0, 11, mysql); //Level2
	PlayerInfo[playerid][pExp] = cache_get_row_int(0, 12, mysql); //Exp3
	PlayerInfo[playerid][pPlayHours] = cache_get_row_int(0, 13, mysql); //PlayHours4
	PlayerInfo[playerid][pSex] = cache_get_row_int(0, 14, mysql); //Sex5
	PlayerInfo[playerid][pAge] = cache_get_row_int(0, 15, mysql); //Age6
	PlayerInfo[playerid][pRace] = cache_get_row_int(0, 16, mysql); //Rce7
	PlayerInfo[playerid][pAdmin] = cache_get_row_int(0, 17, mysql); //Admin8
	PlayerInfo[playerid][pHelper] = cache_get_row_int(0, 18, mysql); //Helper <= hec  19
	PlayerInfo[playerid][pMoney] = cache_get_row_int(0, 19, mysql); //Money
	PlayerInfo[playerid][pBank] = cache_get_row_int(0, 20, mysql); //Bank
	PlayerInfo[playerid][pWanted] = cache_get_row_int(0, 21, mysql); //Wanted
	PlayerInfo[playerid][pVIP] = cache_get_row_int(0, 22, mysql); //VIP
	PlayerInfo[playerid][pLeader] = cache_get_row_int(0, 23, mysql); //Leader
	PlayerInfo[playerid][pMember] = cache_get_row_int(0, 24, mysql); //Member
	PlayerInfo[playerid][pRank] = cache_get_row_int(0, 25, mysql); //Rank
	PlayerInfo[playerid][pGunLic] = cache_get_row_int(0, 26, mysql); //GunLic
	PlayerInfo[playerid][pBoatLic] = cache_get_row_int(0, 27, mysql); //BoatLic
	PlayerInfo[playerid][pFishLic] = cache_get_row_int(0, 28, mysql); //FishLic
	PlayerInfo[playerid][pFlyLic] = cache_get_row_int(0, 29, mysql); //FlyLic
	PlayerInfo[playerid][pCarLic] = cache_get_row_int(0, 30, mysql); //CarLic
	PlayerInfo[playerid][pBikeLic] = cache_get_row_int(0, 31,mysql); //BikeLic
	PlayerInfo[playerid][pD_Packets] = cache_get_row_int(0, 32, mysql); //D_Packets
	PlayerInfo[playerid][pWarns] = cache_get_row_int(0, 33, mysql); //Warns
	PlayerInfo[playerid][pPayDay] = cache_get_row_int(0, 34, mysql); //PayDay
	PlayerInfo[playerid][pHouseKey] = cache_get_row_int(0, 35, mysql); //HouseKey
	PlayerInfo[playerid][pBizKey] = cache_get_row_int(0, 36, mysql); //BizKey
	PlayerInfo[playerid][pFWarns] = cache_get_row_int(0, 37, mysql); //FWarns
	PlayerInfo[playerid][pSkin] = cache_get_row_int(0, 38, mysql); //Skin
	PlayerInfo[playerid][pTelNum] = cache_get_row_int(0, 39, mysql); //TelNum
	PlayerInfo[playerid][pPhone] = cache_get_row_int(0, 40, mysql); //Phone
	PlayerInfo[playerid][pMats] = cache_get_row_int(0, 41, mysql); //Mats
	PlayerInfo[playerid][pPackets] = cache_get_row_int(0, 42, mysql); //Packets
	PlayerInfo[playerid][pDrugs] = cache_get_row_int(0, 43, mysql); //Drugs
	PlayerInfo[playerid][pJob] = cache_get_row_int(0, 44, mysql); //Job
	PlayerInfo[playerid][pMuteTime] = cache_get_row_int(0, 45, mysql); //MuteTime
	PlayerInfo[playerid][pFMuteTime] = cache_get_row_int(0, 46, mysql); //FMuteTime
	PlayerInfo[playerid][pJailTime] = cache_get_row_int(0, 47, mysql); //JailTime
	PlayerInfo[playerid][pBailPrice] = cache_get_row_int(0, 48, mysql); //BailPrice
	PlayerInfo[playerid][pKungfu] = cache_get_row_int(0, 49, mysql); //KungfuStyle
	PlayerInfo[playerid][pKneehead] = cache_get_row_int(0, 50, mysql); //KneeheadStyle
	PlayerInfo[playerid][pBoxing] = cache_get_row_int(0, 51, mysql); //BoxingStyle
	PlayerInfo[playerid][pElbow] = cache_get_row_int(0, 52, mysql); //ElbowStyle
	style = cache_get_row_int(0, 53, mysql); //Style
	PlayerInfo[playerid][pSpawned] = cache_get_row_int(0, 54, mysql); //Spawned
	NeSdal[playerid] = cache_get_row_int(0, 55, mysql); //NeSdal
	PlayerInfo[playerid][pDCTime] = cache_get_row_int(0, 56, mysql); //DropCarTime
	PlayerDrunkLevel[playerid] = cache_get_row_int(0, 57, mysql); //Drunk
	PlayerInfo[playerid][pSpining] = cache_get_row_int(0, 58, mysql); //Spining
	PlayerInfo[playerid][pWorms] = cache_get_row_int(0, 59, mysql); //Worms
	PlayerInfo[playerid][pLotto] = cache_get_row_int(0, 60, mysql); //Lotto
	PlayerInfo[playerid][pMask] = cache_get_row_int(0, 61, mysql); //Mask
	PlayerInfo[playerid][pRoliki] = cache_get_row_int(0, 62, mysql); //Roliki
	PlayerInfo[playerid][pFuel] = cache_get_row_int(0, 63, mysql); //Fuel
	PlayerInfo[playerid][pPhoneBook] = cache_get_row_int(0, 64, mysql); //PhoneBook
	PlayerInfo[playerid][pPistol_Skill] = cache_get_row_int(0, 65, mysql); //Pistol_Skill
	PlayerInfo[playerid][pSDPistol_Skill] = cache_get_row_int(0, 66, mysql); //SDPistol_Skill
	PlayerInfo[playerid][pEagle_Skill] = cache_get_row_int(0, 67, mysql); //Eagle_Skill
	PlayerInfo[playerid][pShotGun_Skill] = cache_get_row_int(0, 68, mysql); //ShotGun_Skill
	PlayerInfo[playerid][pUZI_Skill] = cache_get_row_int(0, 69, mysql); //UZI_Skill
	PlayerInfo[playerid][pMP5_Skill] = cache_get_row_int(0, 70, mysql); //MP5_Skill
	PlayerInfo[playerid][pAK47_Skill] = cache_get_row_int(0, 71, mysql); //AK47_Skill
	PlayerInfo[playerid][pM4_Skill] = cache_get_row_int(0, 72, mysql); //M4_Skill
	PlayerInfo[playerid][pSniper_Skill] = cache_get_row_int(0, 73, mysql); //Sniper_Skill
	PlayerInfo[playerid][pGlasses] = cache_get_row_int(0, 74, mysql); //Glasses
	PlayerInfo[playerid][pBandans] = cache_get_row_int(0, 75, mysql); //Bandans
	PlayerInfo[playerid][pHats] = cache_get_row_int(0, 76, mysql); //Hats
	IncReset[playerid] = cache_get_row_int(0, 77, mysql); //IncReset
	PlayerInfo[playerid][pSyringe] = cache_get_row_int(0, 78, mysql); //Syringe
	PlayerInfo[playerid][pPoison] = cache_get_row_int(0, 79, mysql); //Poison
	PlayerInfo[playerid][pSigs] = cache_get_row_int(0, 80, mysql); //Smokes
	PlayerInfo[playerid][pLighter] = cache_get_row_int(0, 81, mysql); //Lighter
	PlayerInfo[playerid][pFrom] = cache_get_row_int(0, 82, mysql); //From
	PlayerInfo[playerid][pBL] = cache_get_row_int(0, 83, mysql); //BlackList
	PlayerInfo[playerid][pOOC] = cache_get_row_int(0, 84, mysql); //OOC
	PlayerInfo[playerid][pZKP] = cache_get_row_int(0, 85, mysql); //ZKP
	CarPoundTime[playerid] = cache_get_row_int(0, 86, mysql); //CarPoundTime
	PlayerInfo[playerid][pHeal] = cache_get_row_int(0, 87, mysql); //Heal
	Fullness[playerid] = cache_get_row_int(0, 88, mysql); //Fullness
	PlayerInfo[playerid][pPack] = cache_get_row_int(0, 89, mysql); //Pack
	PlayerInfo[playerid][pSprunks] = cache_get_row_int(0, 90, mysql); //Sprunks
	PlayerInfo[playerid][pCheepses] = cache_get_row_int(0, 91, mysql); //Cheeps
	PlayerInfo[playerid][pRadio] = cache_get_row_int(0, 92, mysql); //Radio
	TruckReset[playerid] = cache_get_row_int(0, 93, mysql); //TruckReset
	PlayerInfo[playerid][pSnow] = cache_get_row_int(0, 94, mysql); //Snow
	PlayerInfo[playerid][pDonate] = cache_get_row_int(0, 95, mysql); //Donate
	PlayerInfo[playerid][pOldRepl] = cache_get_row_int(0, 96, mysql); //OldRepl
	PlayerInfo[playerid][pAllRepl] = cache_get_row_int(0, 97, mysql); //AllRepl
	PlayerInfo[playerid][pGetBonus] = cache_get_row_int(0, 98, mysql); //GetBonus
	PlayerInfo[playerid][pKey] = cache_get_row_int(0, 99, mysql); //Key
	PlayerInfo[playerid][pKeyCheck] = cache_get_row_int(0, 100, mysql); //KeyCheck
	PlayerInfo[playerid][pStatsStyle] = cache_get_row_int(0, 101, mysql); //StatsStyle
	PlayerInfo[playerid][pCredit] = cache_get_row_int(0, 102, mysql); //Credit
	PlayerInfo[playerid][pEnterKey] = cache_get_row_int(0, 103, mysql); //EnterKey
	PlayerInfo[playerid][pView] = cache_get_row_int(0, 105, mysql);  //View
	PlayerInfo[playerid][pFeFinder] = cache_get_row_int(0, 106, mysql); //FeFinder
	PlayerInfo[playerid][pGold] = cache_get_row_int(0, 107, mysql); //Gold
	PlayerInfo[playerid][pRepBan] = cache_get_row_int(0, 108, mysql);
	PlayerInfo[playerid][pArmours] = cache_get_row_int(0, 109, mysql);
	PlayerInfo[playerid][pClip] = cache_get_row_int(0, 110, mysql);
	PlayerInfo[playerid][pContractTime] = cache_get_row_int(0, 111, mysql);
	ResetGunsUP[playerid] = cache_get_row_int(0, 112, mysql);
	ResetBuyGuns[playerid] = cache_get_row_int(0, 113, mysql);
	PlayerInfo[playerid][pRPTest] = cache_get_row_int(0, 114, mysql);
	PlayerInfo[playerid][pEnergy] = cache_get_row_int(0, 115, mysql);
	PlayerInfo[playerid][pRepPack] = cache_get_row_int(0, 116, mysql);

	new weaponsstr[500];
	/* Проверить полную поочерёдность бд*/
	PlayerInfo[playerid][pF_Skill] = cache_get_row_int(0, 117, mysql);
	PlayerInfo[playerid][pP_Skill] = cache_get_row_int(0, 118, mysql);// переписать
	PlayerInfo[playerid][pZ_Skill] = cache_get_row_int(0, 119, mysql);
	PlayerInfo[playerid][pZa_Skill] = cache_get_row_int(0, 120, mysql);
	PlayerInfo[playerid][pIn_Skill] = cache_get_row_int(0, 121, mysql);// переписать
	PlayerInfo[playerid][pMy_Skill] = cache_get_row_int(0, 122, mysql);
	PlayerInfo[playerid][pBy_Skill] = cache_get_row_int(0, 123, mysql);
	PlayerInfo[playerid][pVipTime] = cache_get_row_int(0, 125, mysql);
	cache_get_row(0, 126, PlayerInfo[playerid][pMerrit],mysql, 25);
	PlayerInfo[playerid][pSprunk] = cache_get_row_int(0, 127, mysql);
	PlayerInfo[playerid][pBeer] = cache_get_row_int(0, 128, mysql); // переписать
	PlayerInfo[playerid][pShowCase] = cache_get_row_int(0, 129, mysql);
	cache_get_row(0, 130, PlayerInfo[playerid][pLastIP],mysql, 25);
	cache_get_row(0, 131, PlayerInfo[playerid][pLastLogin],mysql, 45);
	PlayerInfo[playerid][pHavePassword] = cache_get_row_int(0, 132, mysql);
	PlayerInfo[playerid][pHealth] = cache_get_row_int(0, 133, mysql);
	PlayerInfo[playerid][pWalentin] = cache_get_row_int(0, 134, mysql);// переписать
	PlayerInfo[playerid][pBuyWalent] = cache_get_row_int(0, 135, mysql);
	PlayerInfo[playerid][pTimeToLastWarn] = cache_get_row_int(0, 136, mysql);
	PlayerInfo[playerid][pHospital] = cache_get_row_int(0, 137, mysql);
	PlayerInfo[playerid][pSlotItem][0] = cache_get_row_int(0, 138, mysql);
	PlayerInfo[playerid][pSlotItem][1] = cache_get_row_int(0, 139, mysql);
	PlayerInfo[playerid][pSlotItem][2] = cache_get_row_int(0, 140, mysql);
	PlayerInfo[playerid][pSlotItem][3] = cache_get_row_int(0, 141, mysql);
	PlayerInfo[playerid][pSlotItem][4] = cache_get_row_int(0, 142, mysql);// переписать
	PlayerInfo[playerid][pSlotItem][5] = cache_get_row_int(0, 143, mysql);
	PlayerInfo[playerid][pRedio] = cache_get_row_int(0, 144, mysql);
	PlayerInfo[playerid][pMore] = cache_get_row_int(0, 145, mysql);
	PlayerInfo[playerid][pCheeps] = cache_get_row_int(0, 146, mysql);// переписать
	PlayerInfo[playerid][pAmountSex] = cache_get_row_int(0, 148, mysql);
	PlayerInfo[playerid][pDisease] = cache_get_row_int(0, 149, mysql);
	PlayerInfo[playerid][pWhore] = cache_get_row_int(0, 150, mysql);
	PlayerInfo[playerid][pMesh] = cache_get_row_int(0, 151, mysql);
 	PlayerInfo[playerid][FamilyID] = cache_get_row_int(0, 152, mysql);
    PlayerInfo[playerid][FamilyMute] = cache_get_row_int(0, 153, mysql);
    PlayerInfo[playerid][pReputation] = cache_get_row_int(0, 154, mysql);

 

 

Отредактировано 8 октября, 2018 пользователем Andy

[28]

up

[558]

@Andy, данный Вами код точно связан с ошибками MySQL? Вы уверены, что в нем проблема?

[28]

@odosenok Данный ошибки появляются при авторизации на сервере, я вам скинул загрузку данных из БД при авторизации.

[28]

up

[1 033]

@Andy Эти ошибки появились сразу или же Вы перед этим что-то изменяли? Если добавляли какие-то столбцы в БД, то удалите их и попробуйте еще раз. 

[28]

@DEST Ничего не менял, лишних столбцов в БД нету.

[1 033]

@Andy я бы советовал вам переписать этот код на более понятный. Т.е. заменить cache_get_row_int на cache_get_field_content_int для типов int, cache_get_row_float на cache_get_field_float для типа float, и cache_get_row на cache_get_field_content для всех остальных соответственно.