SA-MP Forums

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

Reply
 
Thread Tools Display Modes
Old 07/03/2014, 03:31 PM   #1
audriuxxx
Banned
 
Join Date: Jan 2013
Posts: 738
Reputation: 0
Default Mysql queriesYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th

Hi,

Code:
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
I want to ask. It'is possible to know in what querie is that problem? because i have hundred of different queries, and it'is impossible to check everything, or it's take a very a lot of time. I mean i want to print, in mysql.log how i wrote it'is can?
audriuxxx is offline   Reply With Quote
Old 07/03/2014, 03:38 PM   #2
Tamer
High-roller
 
Tamer's Avatar
 
Join Date: Nov 2011
Location: Turkey
Posts: 1,183
Reputation: 169
Default Re: Mysql queriesYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo

Hmm, you may re-define your mysql_query() function with a macro and make query string print that is sent. Then you may check out when did you get the error from the mysql_log and then check the same time from the server_log.txt and find which query has an issue.

But as far as I know it should write after the error message on mysql_log, which plugin version are you on?
__________________
The three stages of truth:

- Ridicule.
- Violent opposition.
- Acceptance.


Quote:
The greatest hypnotist on the planet Earth is an oblong box in the corner of the room. It is constantly telling us what to believe is real. If you can persuade people that what they see with their eyes is what there is to see you've got them. you know because they'll laugh in your face of an explanation that portrays the biggest picture of what's happening... and they have.
Tamer is offline   Reply With Quote
Old 07/03/2014, 03:40 PM   #3
mamorunl
Godfather
 
mamorunl's Avatar
 
Join Date: Feb 2007
Location: Groningen/Netherlands
Posts: 5,841
Reputation: 2246
Default Re: Mysql queriesYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo

The error message is cut off. The real query is shown after it and you can guess based on that query.
mamorunl is offline   Reply With Quote
Old 07/03/2014, 05:13 PM   #4
ColeMiner
Banned
 
Join Date: Feb 2013
Location: 629
Posts: 166
Reputation: 88
Default Re: Mysql queriesYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo

Generally people write a piece of code then test it, so the problem os in the small area you just wrote and are currently testing.
ColeMiner is offline   Reply With Quote
Old 11/04/2014, 07:42 PM   #5
audriuxxx
Banned
 
Join Date: Jan 2013
Posts: 738
Reputation: 0
Default Re: Mysql queriesYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo

There is a lot of ways, maybe if you test in one way it will be okay, but can happin some ways, and there can be wrong, and when you are doing this a lot of, creating a lof of queries, when gamemodeinit, when player write commands, loading from database, where name='%s', player writed test and so on... And it's really to be good, if i get error in mysql.log to know in what querie was syntax error
audriuxxx 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 Syntax Admigo Scripting Help 2 28/04/2013 12:57 AM
An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds.... rati555 Scripting Help 1 14/09/2012 08:45 PM
MySQL Syntax error - wtf? fordawinzz Scripting Help 2 06/08/2012 11:57 AM
[MySQL] Syntax error, what? DVDK Help Archive 17 22/12/2010 05:59 PM
[MYSQL] Syntax error - PLEASE help me... ||| 4#Future Help Archive 3 07/07/2010 09:59 AM


All times are GMT. The time now is 12:16 AM.


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