So I’m working on an online logging system and I am having troubles with the query that is supposed to remove old tables.
"DROP TABLE `"..gLogs.Database.."`.`"..log.logname.."`; DELETE FROM `"..gLogs.Database.."`.`manifest` WHERE `logname` = \""..log.logname.."\";"
[gLogs] Removing old log tables... [gLogs] Failed to remove old log table (srv1-12-09-14)! Error: 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 'DELETE FROM `glogs`.`manifest` WHERE `logname` = "srv1-12-09-14"' at line 1
But when I send the query using phpMyAdmin everything works fine.
MySQL Module: mysqloo
[editline]13th September 2014[/editline]
mysqloo doesn’t seems to support multiple queries at once.