Author Topic: what is the purpose of FK_Installation=1  (Read 689 times)

coley

  • Guru
  • ****
  • Posts: 481
    • View Profile
what is the purpose of FK_Installation=1
« on: March 29, 2011, 01:26:53 pm »
A bit of background first
I've had a recurring problem with a stray "eth0" appearing in some system files and screwing up my installation.
I can hand edit it out and restart the various services affected and get going again. I could never track down what was causing it.
I've just been able to get it to happen, and see why - When I'd hit update on the Network Settings in the Webadmin it would break.

When the script behind the update button populates its needed variables it gets the info from the dB running the following query
Code: [Select]
SELECT IK_DeviceData FROM Device_DeviceData WHERE FK_DeviceData=32trouble is this gets two records, which causes the parsing of fields to fail, with two different FK_installation IDs, 1 and 1000490. Further checking in the pluto_main db reveals a few records with an FK_Installation of 1.

Now my queries:
Where did this set of records for an Installation of 1 come from?
Can I safely remove them from the db? or at least the offending FK_DeviceData=32?

thx
-Coley.

tschak909

  • LinuxMCE God
  • ****
  • Posts: 5501
  • DOES work for LinuxMCE.
    • View Profile
Re: what is the purpose of FK_Installation=1
« Reply #1 on: March 29, 2011, 03:00:30 pm »
FK_Installation = 1 is set when an installation number can't be obtained by our server PHP scripts.

It may also indicate that some stuff is being done too early in the installation process.

-Thom

coley

  • Guru
  • ****
  • Posts: 481
    • View Profile
Re: what is the purpose of FK_Installation=1
« Reply #2 on: March 29, 2011, 03:37:21 pm »
Ah ok thanks.
I doubt if anything is being done too early in any recent installation process - at least not in this case, the modification dates are a few years old.
This install has been apt-get updated all the way.

so .... I'm guessing I should be able to delete these offending records?

-Coley.

tschak909

  • LinuxMCE God
  • ****
  • Posts: 5501
  • DOES work for LinuxMCE.
    • View Profile
Re: what is the purpose of FK_Installation=1
« Reply #3 on: March 29, 2011, 03:39:12 pm »
sure. Be sure you get them all.

-Thom