MySQL Error
#1

Hey, when Im logout from the server, there's a query error, this is the error
Код:
[2013/2/15 - 12:55:13]  `pt7ModelId` = 0, `pt7Bone` = 0, `pt7PosX` = 0.000000, `pt7PosY` = 0.000000, `pt7PosZ` = 0.000000, `pt7RotX` = 0.000000, `pt7RotY` [2013/2/15 - 12:55:13] OnQueryFinish
[2013/2/15 - 12:55:13] Lost connection to MySQL server during query
[2013/2/15 - 12:55:13] SET SQL_SAFE_UPDATES=0;
[2013/2/15 - 12:55:13] NULL
[2013/2/15 - 12:55:13] Lost connection to MySQL server during query
[2013/2/15 - 12:55:13]  `pt7ModelId` = 0, `pt7Bone` = 0, `pt7PosX` = 0.000000, `pt7PosY` = 0.000000, `pt7PosZ` = 0.000000, `pt7RotX` = 0.000000, `pt7RotY` [2013/2/15 - 12:55:13] OnQueryFinish
[2013/2/15 - 12:55:13] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use nea
The Query:
Код:
	format(query, sizeof(query), "%s \
	    `pt7ModelId` = %d, \
	    `pt7Bone` = %d, \
		`pt7PosX` = %f, \
		`pt7PosY` = %f, \
		`pt7PosZ` = %f, \
		`pt7RotX` = %f, \
		`pt7RotY` = %f, \
		`pt7RotZ` = %f, \
		`pt7ScaleX` = %f, \
		`pt7ScaleY` = %f, \
		`pt7ScaleZ` = %f, \
		WHERE `Username` = '%s'",
		PlayerToyInfo[playerid][7][ptModelID],
		PlayerToyInfo[playerid][7][ptBone],
		PlayerToyInfo[playerid][7][ptPosX],
		PlayerToyInfo[playerid][7][ptPosY],
		PlayerToyInfo[playerid][7][ptPosZ],
		PlayerToyInfo[playerid][7][ptRotX],
		PlayerToyInfo[playerid][7][ptRotY],
		PlayerToyInfo[playerid][7][ptRotZ],
		PlayerToyInfo[playerid][7][ptScaleX],
		PlayerToyInfo[playerid][7][ptScaleY],
		PlayerToyInfo[playerid][7][ptScaleZ],
		accountName
	);

	mysql_query(query, SENDUSERDATA_THREAD, playerid, MainPipeline);
Reply


Messages In This Thread
MySQL Error - by RenovanZ - 15.02.2013, 04:34
Re: MySQL Error - by PaulDinam - 15.02.2013, 05:25
Re: MySQL Error - by RenovanZ - 15.02.2013, 05:30
Re: MySQL Error - by Scenario - 15.02.2013, 05:34
Re: MySQL Error - by RenovanZ - 15.02.2013, 05:37
Re: MySQL Error - by RenovanZ - 15.02.2013, 05:53
Re: MySQL Error - by RenovanZ - 15.02.2013, 10:20
Re: MySQL Error - by Scenario - 15.02.2013, 14:01
Re: MySQL Error - by RenovanZ - 15.02.2013, 14:07
Re: MySQL Error - by SuperViper - 15.02.2013, 14:19

Forum Jump:


Users browsing this thread: 1 Guest(s)