News:

Rule #1 - Be Patient - Rule #2 - Don't ask when, if you don't contribute - Rule #3 - You have coding skills - LinuxMCE's small brother is available: http://www.agocontrol.com

Main Menu

SQL ERROR 1064

Started by robertb, November 23, 2008, 03:44:25 PM

Previous topic - Next topic

robertb

Hi,

I'm getting the same error as described in http://forum.linuxmce.org/index.php?topic=2162.0

Fatal error: mysql 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 '?)) ORDER BY OrderNum ASC' at line 4] in EXECUTE(" SELECT DISTINCT PageSetup.* FROM PageSetup LEFT JOIN DeviceTemplate ON PageSetup.FK_Package=DeviceTemplate.FK_Package LEFT JOIN Device ON Device.FK_DeviceTemplate=PK_DeviceTemplate WHERE showInTopMenu = 1 AND Website='1' AND (PageSetup.FK_Package IS NULL OR (PK_Device IS NOT NULL AND FK_Installation=?)) ORDER BY OrderNum ASC") in /var/www/pluto-admin/include/adodb/adodb-errorhandler.inc.php on line 77

Happened after re-installing after i accidently erased the on screen orbiter in the admin page. I also changed the machine, same error.
If its relevant for some reason since that happens: Once if i'm in the wizard and it asks for the rooms, if i click on adding the rooms it wont show up as digit but the rooms are created when i hit 'next

Thanks in advance

Rob

Timeo Danaeos et dona ferentes