Author Topic: need help please..Fatal error: mysql error  (Read 511 times)

Newguy2

  • Veteran
  • ***
  • Posts: 110
    • View Profile
need help please..Fatal error: mysql error
« 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

daballiemo

  • Guru
  • ****
  • Posts: 244
  • Full Blown Addict
    • View Profile
Re: need help please..Fatal error: mysql error
« Reply #1 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

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

Only do this if you know what u are doing.

rgds

Han
HP N40L12.04 KVM with virt LCME8.10/10.04
MD: FoxConn NetBox 330I - Samsung LE 26 (1360* 768)
MD: M2NPV-VM dual core AMD 64/3800/2Gb/NV6150 - Samsung UE 55 C8700 (full hd, 3d)
MD: FoxConn NetBox 330I - LG 32ld350

Newguy2

  • Veteran
  • ***
  • Posts: 110
    • View Profile
Re: need help please..Fatal error: mysql error
« Reply #2 on: January 08, 2011, 04:13:38 pm »
thanks I'll give it a try