LinuxMCE Forums

General => Installation issues => Topic started by: thealflex on August 20, 2007, 10:46:06 pm

Title: Mysql Error at Webadmin
Post by: thealflex 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
Title: Re: Mysql Error at Webadmin
Post by: Zaerc 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.