FOG Project

    • Register
    • Login
    • Search
    • Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Pending MACs Table Doesn't Exist?

    FOG Problems
    2
    3
    1397
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • E
      Eric Wunder last edited by

      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

      1 Reply Last reply Reply Quote 0
      • E
        Eric Wunder last edited by

        Thanks, that worked perfectly!

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

        1 Reply Last reply Reply Quote 0
        • C
          chad-bisd Moderator last edited by

          [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]


          If you would like to make a donation to the Fog project, please do so [U][COLOR=#0000ff][URL='http://sourceforge.net/dona…

          1 Reply Last reply Reply Quote 0
          • 1 / 1
          • First post
            Last post

          224
          Online

          10.2k
          Users

          16.3k
          Topics

          149.9k
          Posts

          Copyright © 2012-2020 FOG Project