Weird MySQL Issue - Printable Version

Weird MySQL Issue - 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: Weird MySQL Issue (/showthread.php?tid=470028)

Weird MySQL Issue - UnknownGamer - 15.10.2013

pawn Код:

[ERROR] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - (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 'id ASC' at line 1

What does this stand for? It doesn't explain where the issue is?

Re: Weird MySQL Issue - EvanA - 15.10.2013

It says to read the manual to find the right syntax. Can you show us your line 1 its referring to?

Re: Weird MySQL Issue - UnknownGamer - 15.10.2013

Quote:

Originally Posted by EvanA

It says to read the manual to find the right syntax. Can you show us your line 1 its referring to?

How do you know which line it's refeering to... It doesn't tell you.

Re: Weird MySQL Issue - -Prodigy- - 15.10.2013

Well, what queries do you run that use "id ASC"?

Re: Weird MySQL Issue - Ayumi - 15.10.2013

Quote:

Originally Posted by UnknownGamer

How do you know which line it's refeering to... It doesn't tell you.

It says "1" after "line" it the message you displayed in your thread.

However, so us the relevant code and we will point out factors of it that make it wrong and/or enefficient.