SA-MP Forums Archive
MYSQL ERROR - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MYSQL ERROR (/showthread.php?tid=575928)


MYSQL ERROR - sscarface - 31.05.2015

PHP код:
(211) : error 075: input line too long (after substitutions)
(212) : error 037: invalid string (possibly non-terminated string)
(212) : error 017: undefined symbol "INSERT"
(212) : error 017: undefined symbol "INTO"
(212) : fatal error 107: too many error messages on one line 
PHP код:
case DIALOG_REGISTER:
        {
            if(!response) return Kick(playerid);
            if(strlen(inputtext) < 6) return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "Registration", "{FFFFFF}Your account does not exist. Please register below\nbefore playing so your statistics save.\n\nYour password must be at least {F05151}6 characters{FFFFFF} long!", "Next", "Quit");
            WP_Hash(Player[playerid][Pass], 129, inputtext); //hashing inputtext
            
            Logged[playerid] = true;
            Newreg[playerid] = true;
            
            mysql_format(mysql, query, sizeof(query), "INSERT INTO `players` (`ID`, `User`, `Pass`, `IP`, `Admin`, `SkinID`, `AccountLocked`, `AccountBanned`, `BanningAdmin`, `BannedReason`, `MoneyHand`, `MoneyBank`,`Health`, `Armour`, `LastActivity`, `WeaponSlot1`, `WepSlotAmmo1`, `WeaponSlot2`, `WepSlotAmmo2`, `WeaponSlot3`, `WepSlotAmmo3`, `WeaponSlot4`, `WepSlotAmmo4`, `WeaponSlot5`, `WepSlotAmmo5`) VALUES ('', '%e', '%s', '%s', 0, 299, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 5000, 0, 0, 0, 100.0, 0.0, 0, 0)", GetUserName(playerid), Player[playerid][Pass], IP[playerid]);
            mysql_tquery(mysql, query, "CreateUser", "i", playerid);
        }
    }
    return false;
} 
It doesn't make sense for me. Anyone?

Re: MYSQL ERROR - !damo!spiderman - 31.05.2015

Your query string is too long. Most of your values you're setting as default values, so you should setup your table to have those values as their defaults and just remove them from the insert query