Author Topic: SQL ERROR 1064  (Read 2205 times)

robertb

  • Newbie
  • *
  • Posts: 6
    • View Profile
SQL ERROR 1064
« on: November 23, 2008, 03:44:25 pm »
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