LinuxMCE Forums

General => Users => Topic started by: Newguy2 on January 08, 2011, 01:49:51 am

Title: need help please..Fatal error: mysql error
Post by: Newguy2 on January 08, 2011, 01:49:51 am

hello, After adding a touch orbiter to my core and then then back onto the admin site, i try to select anything but i get:

"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 Description ASC' at line 3] in EXECUTE(" SELECT Room.Description, PK_Room FROM Room WHERE Room.FK_Installation=? ORDER BY Description ASC") in /var/www/lmce-admin/include/adodb/adodb-errorhandler.inc.php on line 77"

After reading the forums i was hoping that maybe someone can tell me there is a better solution than reinstalling lmce. everything works fine, its that error message when trying to do anything on the admin site. thanks in advance

Title: Re: need help please..Fatal error: mysql error
Post by: daballiemo on January 08, 2011, 10:46:43 am

Just to make sure mysql is ok you can run:

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases http://www.directadmin.com/forum/showthread.php?t=32220 (http://www.directadmin.com/forum/showthread.php?t=32220)

although the error message points to some flacky in the webmin script.

Only do this if you know what u are doing.

rgds

Han

Title: Re: need help please..Fatal error: mysql error
Post by: Newguy2 on January 08, 2011, 04:13:38 pm

thanks I'll give it a try