Solved Searching failed

[pmonstad]

I have installed FOG 0.33 beta (new installation). I then imported hosts from and old installation. When listing all hosts I get errors telling FOG DEBUG: Image: Database Load Failed: ID: 0, Error: Row not found

I guess this is because there is no image assosiations? I then try to find all hosts starting with t61 as I want to put them into a group and make the required image association. When searching I get an error telling Error searching, please try again…

[Andrew W]

Further, I also found most Javascript stuff broken until I cleared the cache - going through host details (ie Snapins, Hardware) didn’t work amongst other things.

[Andrew W]

From what I experienced it’s not to do with hostImage. It appears to purely be a browser caching issue. I only had it from PCs that had recently accessed FOG 0.32 when accessing FOG 1.0.1. PCs that had not accessed the old-version FOG server didn’t have the issue, and once clearing the cache in Firefox in my laptop, the problem went away.

[pmonstad]

[quote=“Tom Elliott, post: 26271, member: 7271”]When you go into mysql you need to specify the database you want to use.
[code]mysql -u root -p’<YOURPASSWORDHERE>’ -h<FOGIPADDRESS> <DATABASE_NAME>[/code]

If you signed into the mysql command line with:
[code]mysql -u root -p’<YOURPASSWORDHERE>'[/code]

You can use a couple methods to update the related DB.
First method, use the specified database:
[code]use fog;
update hosts set hostImage=‘1’;[/code]
Or you can specify the database right on the line:
[code]update fog.hosts set hostImage=‘1’;[/code][/quote]

Thanks!

[Tom Elliott]

[quote=“pmonstad, post: 26261, member: 17422”]Hm, I am a newbie to mysql. I enter mysql and then
UPDATE hosts set hostImage=‘1’ but the response is then -> How does mysql know which database I will modify?[/quote]

When you go into mysql you need to specify the database you want to use.
[code]mysql -u root -p’<YOURPASSWORDHERE>’ -h<FOGIPADDRESS> <DATABASE_NAME>[/code]

If you signed into the mysql command line with:
[code]mysql -u root -p’<YOURPASSWORDHERE>'[/code]

You can use a couple methods to update the related DB.
First method, use the specified database:
[code]use fog;
update hosts set hostImage=‘1’;[/code]
Or you can specify the database right on the line:
[code]update fog.hosts set hostImage=‘1’;[/code]

[pmonstad]

Hm, I am a newbie to mysql. I enter mysql and then
UPDATE hosts set hostImage=‘1’ but the response is then -> How does mysql know which database I will modify?

[BPSTravis]

IF the hosts are missing images then it will not be loaded into the list to search.

Easiest way to fix this would be to run the sql command:

[CODE]
sudo mysql or ‘sudo mysql -p’ if you set a root password for mysql
UPDATE hosts set hostImage=‘1’
quit
[/CODE]

This will set all hosts to the same image(whatever image is id# 1) If you do not have any images made yet then make one called “Test” or something like that.

After that go through your hosts, move them into groups and then assign that group the actual image you want for the hosts.