SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 08/11/2018, 01:04 PM   #1
rOps
Big Clucker
 
Join Date: Apr 2014
Posts: 70
Reputation: 0
Default MySQL Error ID: 1064

Hello, exactly one hour I'm trying to fix this error, I've tried a lot of different options, but still the same..

Code:
GetPlayerPos(playerid, PropertyPos[0], PropertyPos[1], PropertyPos[2]);

format(Query, sizeof(Query), "INSERT INTO `propertys` (ID, PosX, PosY, PosZ) VALUES ('%d', '%f', '%f, '%f')", PropertyID, PropertyPos[0], PropertyPos[1], PropertyPos[2]);
mysql_query(Query);
Code:
CMySQLHandler::Query(INSERT INTO `propertys` (ID, PosX, PosY, PosZ) VALUES ('0', '-218.448944', '1093.840209, '19.600383')) - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '19.600383')' at line 1)
rOps is offline   Reply With Quote
Old 08/11/2018, 01:07 PM   #2
PawelQ
Big Clucker
 
PawelQ's Avatar
 
Join Date: Jun 2013
Posts: 108
Reputation: 2
Default Re: MySQL Error ID: 1064

Does this row in your database is formatted to be a float?
PawelQ is offline   Reply With Quote
Old 08/11/2018, 01:07 PM   #3
rOps
Big Clucker
 
Join Date: Apr 2014
Posts: 70
Reputation: 0
Default Re: MySQL Error ID: 1064

Yes.
rOps is offline   Reply With Quote
Old 08/11/2018, 01:12 PM   #4
PawelQ
Big Clucker
 
PawelQ's Avatar
 
Join Date: Jun 2013
Posts: 108
Reputation: 2
Default Re: MySQL Error ID: 1064

What version of plugin are You using?
PawelQ is offline   Reply With Quote
Old 08/11/2018, 01:12 PM   #5
Rolux
Big Clucker
 
Rolux's Avatar
 
Join Date: Jun 2013
Location: u2mu7c7ttj8qt
Posts: 71
Reputation: 20
Default Re: MySQL Error ID: 1064

Code:
GetPlayerPos(playerid, PropertyPos[0], PropertyPos[1], PropertyPos[2]);

format(Query, sizeof(Query), "INSERT INTO `propertys` (ID, PosX, PosY, PosZ) VALUES ('%d', '%f', '%f', '%f')", PropertyID, PropertyPos[0], PropertyPos[1], PropertyPos[2]);
mysql_query(Query);
Rolux is offline   Reply With Quote
Old 08/11/2018, 01:15 PM   #6
PawelQ
Big Clucker
 
PawelQ's Avatar
 
Join Date: Jun 2013
Posts: 108
Reputation: 2
Default Re: MySQL Error ID: 1064

Well it's sad to tell that we are blind.
PawelQ is offline   Reply With Quote
Old 08/11/2018, 01:16 PM   #7
rOps
Big Clucker
 
Join Date: Apr 2014
Posts: 70
Reputation: 0
Default Re: MySQL Error ID: 1064



Thanks, and sorry for my stupidity level over 9999
rOps is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MYSQL error 1064 Alex_T Scripting Help 2 06/12/2015 06:55 PM
(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for t SandKing94 Scripting Help 3 22/05/2015 08:53 AM
MySQL - Log error #1064 Saize Scripting Help 5 09/02/2015 09:21 PM
MySQL Error: #1064 benel1 Scripting Help 4 07/02/2015 07:49 AM
MySQL Error ID: 1064 TudvariHUN Scripting Help 11 19/01/2014 06:32 PM


All times are GMT. The time now is 06:36 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.