Author Topic: mysql error-trying to access core  (Read 569 times)

Avi

  • Making baby steps
  • Posts: 2
    • View Profile
mysql error-trying to access core
« on: June 03, 2009, 12:18:01 am »
Hi all I have a problem when i try to access the "core" from the admin page.
I get the following 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 '?' at line 1] in EXECUTE("SELECT FK_OperatingSystem FROM Distro WHERE PK_Distro=?") in /var/www/pluto-admin/include/adodb/adodb-errorhandler.inc.php on line 77

Note: All other sections on the admin page I can access.

any help will be greatly appreciated.
Thanks.

pigdog

  • NEEDS to work for LinuxMCE
  • ***
  • Posts: 1008
    • View Profile
Re: mysql error-trying to access core
« Reply #1 on: June 03, 2009, 03:29:10 am »
Hi Avi,

Are you on 710 or 810 variant?

Avi

  • Making baby steps
  • Posts: 2
    • View Profile
Re: mysql error-trying to access core
« Reply #2 on: June 03, 2009, 03:47:10 am »
I am using LMCE 710.

I also just noticed that in the admin page under ADVANCED->NETWORK SETTINGS I see the following message:

"No record in Device_DeviceData for Network Interfaces."

I don't understand because my internet connection works fine, its on eth1 as external and eth0 is internal for LMCE.


Zaerc

  • Alumni
  • LinuxMCE God
  • *
  • Posts: 2256
  • Department of Redundancy Department.
    • View Profile
Re: mysql error-trying to access core
« Reply #3 on: June 03, 2009, 03:52:41 am »
Sounds like your database is hosed.  Probably best to reinstall.
"Change is inevitable. Progress is optional."
-- Anonymous


pigdog

  • NEEDS to work for LinuxMCE
  • ***
  • Posts: 1008
    • View Profile
Re: mysql error-trying to access core
« Reply #4 on: June 03, 2009, 03:57:50 am »
Hi Avi,

It sounds like MySQL is corrupted.

Did you just install 710 or have you been running for a while?

If you just installed 710 I would suggest a re-install.

Otherwise, there are ways of purging mysql and re-installing but I don't know if that would be a recommended course.

Maybe someone with more MySQL experience could guide you on this one.