SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help > Help Archive

 
 
Thread Tools Display Modes
Old 10/03/2011, 12:18 PM   #1
MahmutBey
Big Clucker
 
Join Date: Feb 2010
Posts: 74
Reputation: 0
Default input line too long (after substitutions) - invalid string (possibly non-terminated string)

solved

Last edited by MahmutBey; 10/03/2011 at 03:39 PM. Reason: updated
MahmutBey is offline  
Old 10/03/2011, 12:22 PM   #2
Zh3r0
High-roller
 
Join Date: Mar 2008
Posts: 4,513
Reputation: 398
Default Re: input line too long (after substitutions) - invalid string (possibly non-terminated string)

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.
__________________
Zh3r0 is offline  
Old 10/03/2011, 12:27 PM   #3
[03]Garsino
Guest
 
Posts: n/a
Default Re: input line too long (after substitutions) - invalid string (possibly non-terminated string)

It can, it's just that the shitty compiler can't.
 
Old 10/03/2011, 12:29 PM   #4
Mean
High-roller
 
Join Date: Jul 2010
Location: 14th annual lemon party
Posts: 2,727
Reputation: 229
Default Re: input line too long (after substitutions) - invalid string (possibly non-terminated string)

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.
__________________
I'm pretty much the creator of the PUB: macro used in many scripts today, therefore I'm a legitimate genius.

Ground breaking stuff
Quote:
Originally Posted by ******
I've met Mean on a few occasions in real life, a true genius and a 400 pound all-muscle gorilla alpha male. He has had a great influence on my life.
Quote:
Originally Posted by Kalcor
I don't know where I'd be today without Mean. He has helped me through some tough times in my life. He always brings a smile to my face. Such a positive lad!
Mean is offline  
Old 10/03/2011, 12:33 PM   #5
Sasino97
Banned
 
Join Date: Dec 2010
Location: Soon Banned...
Posts: 1,392
Reputation: 127
Default Re: input line too long (after substitutions) - invalid string (possibly non-terminated string)

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.
Sasino97 is offline  
Old 10/03/2011, 01:24 PM   #6
MahmutBey
Big Clucker
 
Join Date: Feb 2010
Posts: 74
Reputation: 0
Default Re: input line too long (after substitutions) - invalid string (possibly non-terminated string)

I fixed previous error, I take this error another line... please help me again
MahmutBey is offline  
Old 10/03/2011, 02:39 PM   #7
MahmutBey
Big Clucker
 
Join Date: Feb 2010
Posts: 74
Reputation: 0
Default Re: input line too long (after substitutions) - invalid string (possibly non-terminated string)

help??
MahmutBey is offline  
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
format - input line too long (after substitutions) ajwar Help Archive 8 21/03/2011 12:02 AM
[HELP] error 075: input line too long (after substitutions) Pooh7 Help Archive 3 20/11/2010 09:57 AM
input line too long (after substitutions) Kar Help Archive 3 11/08/2010 11:20 PM
error 075: input line too long (after substitutions) Calgon Help Archive 9 18/03/2009 06:45 PM


All times are GMT. The time now is 07:30 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.