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=582190)


Mysql error - danielpalade - 18.07.2015

So, whenever I try and join my server I get this mysql popup with an error.
I check mysql.log and I see this.

Код:
[21:15:52] [ERROR] CMySQLQuery::Execute[] - (error #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 '`0', name = '' WHERE carID = '218'' at line 1
[21:15:52] [ERROR] CMySQLQuery::Execute[] - (error #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 '`0', name = '' WHERE carID = '219'' at line 1
[21:15:52] [ERROR] CMySQLQuery::Execute[] - (error #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 '`0', name = '' WHERE carID = '220'' at line 1
[21:15:52] [ERROR] CMySQLQuery::Execute[] - (error #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 '`0', name = '' WHERE carID = '221'' at line 1
[21:15:52] [ERROR] CMySQLQuery::Execute[] - (error #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 '`0', name = '' WHERE carID = '222'' at line 1
[21:15:52] [ERROR] CMySQLQuery::Execute[] - (error #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 '`0', name = '' WHERE carID = '223'' at line 1
[21:15:52] [ERROR] CMySQLQuery::Execute[] - (error #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 '`0', name = '' WHERE carID = '224'' at line 1
[21:15:52] [ERROR] CMySQLQuery::Execute[] - (error #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 '`0', name = '' WHERE carID = '225'' at line 1
[21:15:53] [ERROR] CMySQLQuery::Execute[] - (error #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 '`0', name = '' WHERE carID = '226'' at line 1
[21:15:53] [ERROR] CMySQLQuery::Execute[] - (error #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 '`0', name = '' WHERE carID = '227'' at line 1
[21:15:53] [ERROR] CMySQLQuery::Execute[] - (error #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 '`0', name = '' WHERE carID = '228'' at line 1
[21:15:53] [ERROR] CMySQLQuery::Execute[] - (error #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 '`0', name = '' WHERE carID = '229'' at line 1
So I checked:

Код:
stock saveDealer(const id)
{
	format(szLargeString, sizeof(szLargeString), "UPDATE dealer SET stock = '%d', price = '%d', Pprice = `%d', name = '%s' WHERE carID= '%d'", vehSlots[id],vehPrice[id],vehPprice[id],vehName[id],id);
	mysql_tquery(handle,szLargeString);
	return 1;
}
But I couldn't find the error. Can you guys help me?

Re: Mysql error - zPain - 18.07.2015

Here:
Код:
Pprice = `%d'