Author Topic: Mysql Error at Webadmin  (Read 945 times)

thealflex

  • First post!
  • Posts: 1
    • View Profile
Mysql Error at Webadmin
« on: August 20, 2007, 10:46:06 pm »
Hallo!

When I want to login at the Webadmin Page I get this error:

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

Does anyone know this error?
(LinuxMCE 0704 DVD installer)

Alf

Zaerc

  • Alumni
  • LinuxMCE God
  • *
  • Posts: 2256
  • Department of Redundancy Department.
    • View Profile
Re: Mysql Error at Webadmin
« Reply #1 on: August 20, 2007, 11:40:42 pm »
Yes that sounds familiar: http://forum.linuxmce.org/index.php?topic=2053.msg9492#msg9492

Seems to me your database is hosed, I'd recommend reinstalling.
"Change is inevitable. Progress is optional."
-- Anonymous