MySQL input line too long
#1

Code:
format(string, sizeof(string), "INSERT INTO `accounts` ( `Username`, `Key`, `RegiDate`, `BirthDate`, `Ammo1`, `Ammo2`, `Ammo3`, `Ammo4`, `Ammo5`, `Ammo6`, `Ammo7`, `Ammo8`, `wSaveSlot1`, `wSaveSlot2`, `wSaveSlot3`, `wSaveSlot4`, `wSaveSlot5`, `wSaveSlot6`, `wSaveSlot7`, `wSaveSlot8`, `aSaveSlot1`, `aSaveSlot2`, `aSaveSlot3`, `aSaveSlot4`, `aSaveSlot5`, `aSaveSlot6`, `aSaveSlot7`, `aSaveSlot8`, `FacGuns1`, `FacGuns2`, `FacGuns3`, `FacGuns4`, `FacGuns5`, `FacGuns6`, `FacGuns7`, `FacGuns8`, `Hambuger`, `Pizza`, `BanhMi`, `Hyperion`, `ThanhGo`, `HopGiay`, `TuaVitHP`, `ThungXang`, `ThungXangHP`, `JModel`, `Neon`, `C4Robbank`, `SuaBo`, `FacAmmo1`, `FacAmmo2`, `FacAmmo3`, `FacAmmo4`, `FacAmmo5`, `FacAmmo6`, `FacAmmo7`, `FacAmmo8`, `Balo`) VALUES ('%s', '%s', '2015-08-03 15:47:22', '2015-08-03 15:47:22', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')", GetPlayerNameExt(playerid), passbuffer);
Code:
./includes/gvc.pwn(96606) : error 075: input line too long (after substitutions)
./includes/gvc.pwn(96607) : error 037: invalid string (possibly non-terminated string)
./includes/gvc.pwn(96607) : error 017: undefined symbol "INSERT"
./includes/gvc.pwn(96607) : error 029: invalid expression, assumed zero
./includes/gvc.pwn(96607) : fatal error 107: too many error messages on one line
Reply
#2

Your input is too long, use strcat to separate the lines.
Reply
#3

...... -.-
Reply
#4

Use default values and normalize. If you need to add a number to a column name then you're doing databases wrong. Tutorials linked in my sig.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)