[13th]

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?

[ReneG]

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.

[13th]

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.