|
![]() |
|
Thread Tools | Display Modes |
![]() |
#1 |
Banned
![]() Join Date: Jan 2013
Posts: 738
Reputation: 0
|
![]()
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 |
![]() |
![]() |
![]() |
#2 |
High-roller
![]() ![]() ![]() ![]() ![]() Join Date: Nov 2011
Location: Turkey
Posts: 1,184
Reputation: 169
|
![]()
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? |
![]() |
![]() |
![]() |
#3 |
Godfather
![]() ![]() ![]() ![]() ![]() ![]() Join Date: Feb 2007
Location: Groningen/Netherlands
Posts: 5,839
Reputation: 2246
|
![]()
The error message is cut off. The real query is shown after it and you can guess based on that query.
|
![]() |
![]() |
![]() |
#4 |
Banned
![]() Join Date: Feb 2013
Location: 629
Posts: 166
Reputation: 88
|
![]()
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.
|
![]() |
![]() |
![]() |
#5 |
Banned
![]() Join Date: Jan 2013
Posts: 738
Reputation: 0
|
![]()
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
|
![]() |
![]() |
![]() |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
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 |