[BlueG R7] Syntax Error? - Printable Version

[BlueG R7] Syntax Error? - 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: [BlueG R7] Syntax Error? (/showthread.php?tid=390651)

[BlueG R7] Syntax Error? - 13th - 07.11.2012

Basically,
mysql_log:

Код:

[14:56:38] Passing query UPDATE vehicle_cache SET ID = 40653 WHERE cID = 41;UPDATE vehicle_cache SET ID = 25505 WHERE cID = 42;UPDATE vehicle_cache SET ID = 24043 WHERE cID = 43;UPDATE vehicle_cache SET ID = 29791 WHERE cID = 44;UPDATE vehicle_cache SET ID = 25260 WHERE cID = 45;UPDATE vehicle_cache SET ID = 24995 WHERE cID = 46;UPDATE vehicle_cache SET ID = 93630 WHERE cID = 47;UPDATE vehicle_cache SET ID = 17124 WHERE cID = 48;UPDATE vehicle_cache SET ID = 17332 WHERE cID = 49;UPDATE vehicle_cache SET ID = 1322 WHERE cID = 50;UPDATE vehicle_cache SET ID = 48261 WHERE cID = 51;UPDATE vehicle_cache SET ID = 51810 WHERE cID = 52;UPDATE vehicle_cache SET ID = 3741 WHERE cID = 53;UPDATE vehicle_cache SET ID = 15273 WHERE cID = 54;UPDATE vehicle_cache SET ID = 35273 WHERE cID = 55;UPDATE vehicle_cache SET ID = 52025 WHERE cID = 56;UPDATE vehicle_cache SET ID = 48859 WHERE cID = 57;UPDATE vehicle_cache SET ID = 11553 WHERE cID = 58;UPDATE vehicle_cache SET ID = 66916 WHERE cID = 59;UPDATE vehicle_cache SET ID = 70580 WHERE cID = 60; | i
[14:56:38] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

OnQueryError error[]:

Код:

[15:02:18] 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 'UPDATE vehicle_cache SET ID = 25505 WHERE cID = 42;UPDATE vehicle_cache SET ID =' at line 1

When I copy the query to phpMyAdmin it works as supposed to. What's happening?

Re: [BlueG R7] Syntax Error? - ReneG - 07.11.2012

I don't think you can run compound queries in the sa-mp version of MySQL. It didn't work for me as well. Run the queries separately.

Re: [BlueG R7] Syntax Error? - 13th - 07.11.2012

Quote:

Originally Posted by VincentDunn

I don't think you can run compound queries in the sa-mp version of MySQL. It didn't work for me as well. Run the queries separately.

I need to run this query fairly regularly, and it seems to take quite awhile, when each row is separate query. Like.. 3-6 seconds maybe? It's a long time to wait after some elements.

I'm thinking I'll have to settle on some kind of queue system.