LinuxMCE Forums
June 20, 2013, 06:00:16 am GMT-1 *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
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
 
   Home   Help Search Chat Login Register  
Pages: [1]
  Print  
Author Topic: SQL ERROR 1064  (Read 416 times)
robertb
Newbie
*
Posts: 6


View Profile
« 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

Logged

Timeo Danaeos et dona ferentes
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!