input line too long (after substitutions) - invalid string (possibly non-terminated string)
#1

solved
Reply
#2

pawn Code:
new EscPass[38], Query[ 1500 ];

    mysql_real_escape_string(password, EscPass);

    format(Query ,600,"SELECT pSQLID,pKey,pLevel,pAdmin,pDonateRank,gPupgrade,pConnectTime,pReg,pSex,pAge,pOrigin,pCK,pMuted,pExp,pCash,pAccount,pCrimes,pKills,pDeaths,pArrested,pWantedDeaths,pPhoneBook,pLottoNr,pFishes,pBiggestFish,pJob,pPayCheck,pHeadValue,pJailed,pJailTime,pMats,pDrugs,pLeader,pMember,pFMember,pRank,pChar,pContractTime,pDetSkill,pSexSkill,pLawSkill,pMechSkill,pJackSkill,pCarSkill,pNewsSkill,pDrugsSkill,pFishSkill,pHealth,pSHealth,pInt,pLocal,pTeam,pModel,pPnumber,pPhousekey,pPcarkey,pPcarkey2,pPcarkey3,pGangKey,pPbiskey,pPos_x,pPos_y,pPos_z,pCarLic,pFlyLic,pBoatLic,pFishLic,pGunLic,pGun1,pGun2");
    format(Query ,600, "%s,pGun3,pGun4,pAmmo1,pAmmo2,pAmmo3,pAmmo4,pCarTime,pPayDay,pPayDayHad,pWatch,pCrashed,pWins,pLoses,pAlcoholPerk,pDrugPerk,pMiserPerk,pPainPerk,pTraderPerk,pTut,pWarns,pVirWorld,pFuel,pMarried,pMarriedTo,pFishTool,pInvWeapon,pInvAmmo,pLighter,pCigarettes,pRequestingBackup,pRoadblock,pMask,pMaskuse,pHideNumber,pSpeaker,pLocked FROM `information` WHERE `pUsername` = '%s' AND `pKey` = md5('%s')",Query, PlayerName(playerid), EscPass );
Pawn can't handle large strings.
Reply
#3

It can, it's just that the shitty compiler can't.
Reply
#4

Use "\" for new line, it means that the line is too long, you could use:
pawn Code:
format(Query,sizeof(Query),"SELECT pSQLID,pKey,pLevel,pAdmin,pDonateRank,gPupgrade,pConnectTime, \
    pReg,pSex,pAge,pOrigin,pCK,pMuted,pExp,pCash\
    ,pAccount,pCrimes,pKills,pDeaths,pArrested,pWantedDeaths,pPhoneBook,pLottoNr,pFishes,pBiggestFish,pJob,pPayCheck,pHeadValue,pJailed,pJailTime,pMats,pDrugs,pLeader,pMember\
    ,pFMember,pRank,pChar,pContractTime,pDetSkill,pSexSkill,pLawSkill,pMechSkill,pJackSkill,pCarSkill,pNewsSkill,pDrugsSkill,pFishSkill,pHealth,pSHealth,pInt,pLocal,pTeam,pModel,pPnumber,pPhousekey,pPcarkey,pPcarkey2,pPcarkey3,pGangKey,pPbiskey,pPos_x,pPos_y,pPos_z,\
    pCarLic,pFlyLic,pBoatLic,pFishLic,pGunLic,pGun1,pGun2,pGun3,pGun4,pAmmo1,pAmmo2,pAmmo3,pAmmo4,pCarTime,pPayDay,pPayDayHad,pWatch,pCrashed,pWins,pLoses,pAlcoholPerk,pDrugPerk,pMiserPerk,pPainPerk,pTraderPerk,pTut,pWarns,pVirWorld,pFuel,pMarried,\
    pMarriedTo,pFishTool,pInvWeapon,pInvAmmo,pLighter,pCigarettes,pRequestingBackup,pRoadblock,pMask,pMaskuse,pHideNumber,pSpeaker,pLocked FROM `information` WHERE `pUsername` = '%s' AND `pKey` = md5('%s')"
, PlayerName(playerid), EscPass);
Because I think Zh3r0s one is too long too.
Reply
#5

It means that your line is too long.

It also sends a "Posibly non-terminated string" error and "Undefined Symbol, "Select"" Error, but the cause is only the string.
Reply
#6

I fixed previous error, I take this error another line... please help me again
Reply
#7

help??
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)