PDA

View Full Version : error 075: input line too long


Stefand
10/05/2013, 06:59 AM
Well I have to split again but I already did that, and still getting errors


new query[2000];

format(query, sizeof(query), "INSERT INTO `Houses` (`hInteriorID`, `hInteriorX`, `hInteriorY`, `hInteriorZ`, `hInteriorA`, `hExteriorID`, `hExteriorX`, `hExteriorY`, `hExteriorZ`, `hExteriorA`, `hSpawnID`, ");
format(query, sizeof(query), "%s`hSpawnX`, `hSpawnY`, `hSpawnZ`, `hSpawnA`, `hOwner`, `hAddress`, `HousePrice`, `hLockStatus`, `hType`) VALUES ", query);
format(query, sizeof(query), "%s(%d, '%f', '%f', '%f', '%f', %d, '%f', '%f', '%f', '%f', %d, '%f', '%f', '%f', '%f', '%s', '%s', %d, %d, '%s')", query, Houses[houseid][hInteriorID], Houses[houseid][hInteriorX], Houses[houseid][hInteriorY], Houses[houseid][hInteriorZ], Houses[houseid][hInteriorA], Houses[houseid][hExteriorID], Houses[houseid][hExteriorX], Houses[houseid][hExteriorY], Houses[houseid][hExteriorZ], Houses[houseid][hExteriorA], Houses[houseid][hSpawnID], Houses[houseid][hSpawnX], Houses[houseid][hSpawnY], Houses[houseid][hSpawnZ], Houses[houseid][hSpawnA], Houses[houseid][hOwner], Houses[houseid][hAddress], -1, 1, Houses[houseid][hType],);
mysql_function_query(connectionHandle, query, false, "DefaultCallback", "");



C:\Users\Stefan Laptop\Desktop\GTA RP Script\gamemodes\RolePlay.pwn(7176) : error 075: input line too long (after substitutions)
C:\Users\Stefan Laptop\Desktop\GTA RP Script\gamemodes\RolePlay.pwn(7177) : error 017: undefined symbol "hous"
C:\Users\Stefan Laptop\Desktop\GTA RP Script\gamemodes\RolePlay.pwn(7178) : warning 217: loose indentation
C:\Users\Stefan Laptop\Desktop\GTA RP Script\gamemodes\RolePlay.pwn(7178) : error 017: undefined symbol "eid"
C:\Users\Stefan Laptop\Desktop\GTA RP Script\gamemodes\RolePlay.pwn(7178) : error 029: invalid expression, assumed zero
C:\Users\Stefan Laptop\Desktop\GTA RP Script\gamemodes\RolePlay.pwn(7178) : error 029: invalid expression, assumed zero
C:\Users\Stefan Laptop\Desktop\GTA RP Script\gamemodes\RolePlay.pwn(7178) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase


6 Errors.

mineralo
10/05/2013, 07:03 AM
new query[2000];

format(query, sizeof(query), "INSERT INTO `Houses` (`hInteriorID`, `hInteriorX`, `hInteriorY`, `hInteriorZ`, `hInteriorA`, `hExteriorID`, `hExteriorX`, `hExteriorY`, `hExteriorZ`, `hExteriorA`, `hSpawnID`, ");
format(query, sizeof(query), "%s`hSpawnX`, `hSpawnY`, `hSpawnZ`, `hSpawnA`, `hOwner`, `hAddress`, `HousePrice`, `hLockStatus`, `hType`) VALUES ", query);
format(query, sizeof(query), "%s(%d, '%f', '%f', '%f', '%f', %d, '%f', '%f', '%f', '%f', %d, '%f', '%f', '%f', '%f', '%s', '%s', %d, %d, '%s')",
query, Houses[houseid][hInteriorID], Houses[houseid][hInteriorX], Houses[houseid][hInteriorY], Houses[houseid][hInteriorZ], Houses[houseid][hInteriorA], Houses[houseid][hExteriorID], Houses[houseid][hExteriorX], Houses[houseid][hExteriorY],
Houses[houseid][hExteriorZ], Houses[houseid][hExteriorA], Houses[houseid][hSpawnID], Houses[houseid][hSpawnX], Houses[houseid][hSpawnY], Houses[houseid][hSpawnZ], Houses[houseid][hSpawnA], Houses[houseid][hOwner], Houses[houseid][hAddress], -1, 1, Houses[houseid][hType],);
mysql_function_query(connectionHandle, query, false, "DefaultCallback", "");

[HiC]TheKiller
10/05/2013, 07:05 AM
format(query, sizeof(query), "INSERT INTO `Houses` (`hInteriorID`, `hInteriorX`, `hInteriorY`, `hInteriorZ`, `hInteriorA`, `hExteriorID`, `hExteriorX`, `hExteriorY`, `hExteriorZ`, `hExteriorA`, `hSpawnID`, ");
format(query, sizeof(query), "%s`hSpawnX`, `hSpawnY`, `hSpawnZ`, `hSpawnA`, `hOwner`, `hAddress`, `HousePrice`, `hLockStatus`, `hType`) VALUES ", query);
format(query, sizeof(query), "%s(%d, '%f', '%f', '%f', '%f', %d, '%f', '%f', '%f', '%f', %d, '%f', '%f', '%f', '%f', '%s', '%s', %d, %d, '%s')", query, Houses[houseid][hInteriorID], Houses[houseid][hInteriorX], Houses[houseid][hInteriorY], Houses[houseid][hInteriorZ], Houses[houseid][hInteriorA], Houses[houseid][hExteriorID], Houses[houseid][hExteriorX], Houses[houseid][hExteriorY], Houses[houseid][hExteriorZ], Houses[houseid][hExteriorA], Houses[houseid][hSpawnID], Houses[houseid][hSpawnX], Houses[houseid][hSpawnY], Houses[houseid][hSpawnZ], Houses[houseid][hSpawnA], Houses[houseid][hOwner], Houses[houseid][hAddress], -1, 1, Houses[houseid][hType]);
mysql_function_query(connectionHandle, query, false, "DefaultCallback", "");


If that does not fix it, you're going to need to split it further. You had an extra comma on the end of the last format.