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

    Solved Change Image ID Number

    FOG Problems
    3
    44
    8843
    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.
    • Wayne Workman
      Wayne Workman @RobTitian16 last edited by

      @RobTitian16 The command is wrong, you are missing the equals.

      You need to be really careful doing this, it has to be accurate and exact or you will break it and have to remake these definitions by hand with the web GUI. I would suggest you copy/paste and then modify the commands as needed.

      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
      Daily Clean Installation Results:
      https://fogtesting.fogproject.us/
      FOG Reporting:
      https://fog-external-reporting-results.fogproject.us/

      RobTitian16 1 Reply Last reply Reply Quote 0
      • RobTitian16
        RobTitian16 @Wayne Workman last edited by

        @Wayne-Workman Thanks! Extremely helpful, although I’m running into an issue when running “UPDATE images SET imageID - imageID -4 ;” that says:

        ERROR 1062 (23000): Duplicate entry ‘25’ for key ‘PRIMARY’.

        I’m not overly familiar with SQL, so I’m unsure what this means.

        Wayne Workman 1 Reply Last reply Reply Quote 0
        • Wayne Workman
          Wayne Workman last edited by

          Here’s a tutorial I wrote a year ago on how to do it:

          https://forums.fogproject.org/topic/5798/resetting-the-image-numbers-r4602

          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
          Daily Clean Installation Results:
          https://fogtesting.fogproject.us/
          FOG Reporting:
          https://fog-external-reporting-results.fogproject.us/

          RobTitian16 1 Reply Last reply Reply Quote 0
          • Tom Elliott
            Tom Elliott last edited by

            You can’t change image id’s in the GUI.

            However you can have the id’s reordered how you want using a SQL statement.

            That said, unless you’re 100% aware of what you’re doing, I wouldn’t recommend this.

            Remember these id’s (hosts, snapins, groups, images, etc…) are typically “cross” associated. With images, in particular, there’s two different associations made. One is tied to hosts on the host tables, under the hostImage column. This is the image ID that’s associated to the host. There’s also the imageGroupAssoc table which handles storage group associations between images.

            Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

            Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

            Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

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

            193
            Online

            10.4k
            Users

            16.4k
            Topics

            150.6k
            Posts

            Copyright © 2012-2023 FOG Project