Pending MACs Table Doesn't Exist?

[Eric Wunder]

Hello!

First off, I would like to say that FOG is saving me so much trouble when it comes to image and inventory management. Although we have had some issues with reliably installing printers using the printer manager, we have had no other major problems.

However, when trying to remove a host, I get the message:
[CODE]Failed to remove host!
Query Failed: Table ‘fog.pendingMACS’ doesn’t exist[/CODE]

And when viewing the edit host general tab, I see the following under each MAC address:
[code]Error retrieving Pending MAC addresses[/code]

It appears that the fog.pendingMACS table was not installed/configured properly. I’m not certain if this is because we installed 0.30 and then immediately upgraded to 0.32 and it got messed up in the conversion process, but I have lightly googled/searched the forum and found nothing similar.

Any ideas how I can rectify this? I’m going to settle for changing the hostname of the machine to DELETE_ME so I don’t mess up my inventory, but this is definitely not a permanent solution.

Looking forward to 0.33!

Thanks

[Eric Wunder]

Thanks, that worked perfectly!

I plan to be making a donation very soon… or will get my boss to do so.

[chad-bisd]

[CODE]CREATE TABLE fog.pendingMACS (
pmID INTEGER NOT NULL AUTO_INCREMENT,
pmAddress varchar(18) NOT NULL,
pmHostID INTEGER NOT NULL,
PRIMARY KEY (pmID),
INDEX idx_mc(pmAddress),
INDEX idx_host(pmHostID)
)
ENGINE = MyISAM;[/CODE]