Error ID: 1064, You have an error in your SQL syntax
#1

Код:
[21:11:59] >> mysql_query( Connection handle: 1 )

[21:11:59] CMySQLHandler::Query(INSERT INTO `BanNames` (`Name`,`BanAdmin`,`BanReason`,`BanSeconds`,`BanMinutes`,`BanHours`,`BanDay`,`BanMonth`,`BanYear`) VALUES ('Mantvis_Sireika','Mantvis_Sireika','TESTAS','59','11','21','13','11') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1)

[21:11:59] >> mysql_query( Connection handle: 1 )
mysql log

Код:
stock BanName(name[],reason[],admin[])
{
    new string[200];
	if(!IsBannedName(name))
	{
	    new day, month, year, seconds, minutes, hours;
	    gettime(hours,minutes,seconds);
		getdate(year,month,day);
	    format(string, sizeof(string), "INSERT INTO `BanNames` (`Name`,`BanAdmin`,`BanReason`,`BanSeconds`,`BanMinutes`,`BanHours`,`BanDay`,`BanMonth`,`BanYear`) VALUE ('%s','%s','%s','%d','%d','%d','%d','%d','%d')",name,admin,reason,seconds,minutes,hours,day,month,year);
	    mysql_query(string);
	}
	return true;
}
I can't ban. Bans won't save in Mysql DB
Reply


Messages In This Thread
Error ID: 1064, You have an error in your SQL syntax - by cickis3 - 13.11.2014, 18:39
Re: Error ID: 1064, You have an error in your SQL syntax - by TakeiT - 13.11.2014, 19:00
Re: Error ID: 1064, You have an error in your SQL syntax - by Dziugsas - 13.11.2014, 19:03
Re: Error ID: 1064, You have an error in your SQL syntax - by TakeiT - 13.11.2014, 19:20

Forum Jump:


Users browsing this thread: 2 Guest(s)