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
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
thanks I'll give it a try