need help please..Fatal error: mysql error

[Newguy2]

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

[daballiemo]

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

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

Only do this if you know what u are doing.

rgds

Han

[Newguy2]

thanks I'll give it a try