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

    Snapin ID was not set, or unable to be created SVN Revision: 5661

    Scheduled Pinned Locked Moved Solved
    Bug Reports
    3
    28
    10.1k
    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.
    • Raymond BellR
      Raymond Bell Testers @Tom Elliott
      last edited by

      @Tom-Elliott said in Snapin ID was not set, or unable to be created SVN Revision: 5661:

      truncate table

      mysql> use fog
      Database changed
      mysql> delete from snapinAssoc WHERE saSnapinID NOT IN (SELECT snapinID FROM snapins);
      ERROR 1054 (42S22): Unknown column 'snapinID' in 'field list'
      mysql>
      

      Raymond Bell
      WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

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

        @Tom-Elliott

        @Tom-Elliott said in Snapin ID was not set, or unable to be created SVN Revision: 5661:

        @Raymond-Bell

        Please try this:

        delete from snapinAssoc WHERE saSnapinID NOT IN (SELECT sID FROM snapins);
        truncate table snapinJobs;
        truncate table snapinTasks;
        

        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

        Raymond BellR 2 Replies Last reply Reply Quote 0
        • Tom ElliottT
          Tom Elliott @Raymond Bell
          last edited by

          @Raymond-Bell sorry i’m allowed to make a mistake once in a while lol.

          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

          Raymond BellR 2 Replies Last reply Reply Quote 0
          • Raymond BellR
            Raymond Bell Testers @Tom Elliott
            last edited by

            @Tom-Elliott said in Snapin ID was not set, or unable to be created SVN Revision: 5661:

            @Raymond-Bell sorry i’m allowed to make a mistake once in a while lol.

            LOL

            Raymond Bell
            WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

            1 Reply Last reply Reply Quote 0
            • Raymond BellR
              Raymond Bell Testers @Tom Elliott
              last edited by Raymond Bell

              @Tom-Elliott
              Ok done that… This is what happens when trying to image after upgrading to Revision 5717

              0_1466446587690_Untitled.png

              Tried on 3 different computers

              Raymond Bell
              WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

              1 Reply Last reply Reply Quote 0
              • Raymond BellR
                Raymond Bell Testers @Tom Elliott
                last edited by

                @Tom-Elliott And if i change the image on a guest from the GUI i get this error, but it does save the change

                0_1466447160655_Untitled2.png

                Raymond Bell
                WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

                1 Reply Last reply Reply Quote 0
                • Raymond BellR
                  Raymond Bell Testers @Tom Elliott
                  last edited by

                  @Tom-Elliott Any more thought to this issue? I am unable to image anything… Unless i go back to Revision 5633
                  I am up to SVN Revision: 5725 and same issue

                  Raymond Bell
                  WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

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

                    Can you get me output of mysql command:

                    SELECT * FROM snapins \G

                    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

                    Raymond BellR 2 Replies Last reply Reply Quote 0
                    • Raymond BellR
                      Raymond Bell Testers @Tom Elliott
                      last edited by

                      @Tom-Elliott said in Snapin ID was not set, or unable to be created SVN Revision: 5661:

                      Can you get me output of mysql command:

                      SELECT * FROM snapins \G

                      Yes one min

                      Raymond Bell
                      WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

                      1 Reply Last reply Reply Quote 0
                      • Raymond BellR
                        Raymond Bell Testers @Tom Elliott
                        last edited by Raymond Bell

                        @Tom-Elliott

                        Database changed
                        mysql> SELECT * FROM snapins \G
                        *************************** 1. row ***************************
                                  sID: 0
                                sName:
                                sDesc:
                            sFilePath:
                                sArgs:
                          sCreateDate: 2015-11-09 10:08:23
                             sCreator: fog
                              sReboot:
                             sRunWith:
                         sRunWithArgs:
                               sAnon3:
                        snapinProtect: 0
                             sEnabled: 1
                           sReplicate: 1
                            sShutdown: 0
                             sHideLog: 0
                             sTimeout: 0
                        *************************** 2. row ***************************
                                  sID: 56
                                sName: NCE
                                sDesc:
                            sFilePath: /opt/fog/snapins/New Century Learning System Client.msi
                                sArgs: /qn
                          sCreateDate: 2011-08-29 13:23:09
                             sCreator: fog
                              sReboot: 0
                             sRunWith: c:\windows\system32\msiexec.exe
                         sRunWithArgs: /i SERVERNAME="GSD-NCE" SHAREPATH="\\GSD-NCE\nceroot"
                               sAnon3:
                        snapinProtect: 0
                             sEnabled: 1
                           sReplicate: 1
                            sShutdown: 0
                             sHideLog: 0
                             sTimeout: 0
                        *************************** 3. row ***************************
                                  sID: 64
                                sName: Rosetta Stone
                                sDesc: Rosetta Stone Client
                            sFilePath: /opt/fog/snapins/Rosetta Stone Client.bat
                                sArgs: /qn
                          sCreateDate: 2012-12-04 12:33:16
                             sCreator: dholifield
                              sReboot: 0
                             sRunWith: c:\windows\system32\msiexec.exe
                         sRunWithArgs: /i
                               sAnon3:
                        snapinProtect: 0
                             sEnabled: 1
                           sReplicate: 1
                            sShutdown: 0
                             sHideLog: 0
                             sTimeout: 0
                        *************************** 4. row ***************************
                                  sID: 67
                                sName: LockdownBrowser
                                sDesc:
                            sFilePath: /opt/fog/snapins/lockdownbrowser.bat
                                sArgs:
                          sCreateDate: 2013-09-03 14:46:51
                             sCreator: fog
                              sReboot: 0
                             sRunWith:
                         sRunWithArgs:
                               sAnon3:
                        snapinProtect: 0
                             sEnabled: 1
                           sReplicate: 1
                            sShutdown: 0
                             sHideLog: 0
                             sTimeout: 0
                        *************************** 5. row ***************************
                                  sID: 69
                                sName: iTalc-Client
                                sDesc:
                            sFilePath: /opt/fog/snapins/iTALC-Client.exe
                                sArgs:
                          sCreateDate: 2013-10-04 10:33:52
                             sCreator: dholifield
                              sReboot: 0
                             sRunWith:
                         sRunWithArgs:
                               sAnon3:
                        snapinProtect: 0
                             sEnabled: 1
                           sReplicate: 1
                            sShutdown: 0
                             sHideLog: 0
                             sTimeout: 0
                        *************************** 6. row ***************************
                                  sID: 70
                                sName: Baby Center
                                sDesc:
                            sFilePath: /opt/fog/snapins/Baby Control Center.msi
                                sArgs: /qn
                          sCreateDate: 2014-01-27 10:51:03
                             sCreator: fog
                              sReboot: 0
                             sRunWith: c:\windows\system32\msiexec.exe
                         sRunWithArgs: /i
                               sAnon3:
                        snapinProtect: 0
                             sEnabled: 1
                           sReplicate: 1
                            sShutdown: 0
                             sHideLog: 0
                             sTimeout: 0
                        *************************** 7. row ***************************
                                  sID: 71
                                sName: Drivers
                                sDesc:
                            sFilePath: /opt/fog/snapins/dpinst.bat
                                sArgs:
                          sCreateDate: 2014-02-20 13:59:41
                             sCreator: fog
                              sReboot: 0
                             sRunWith:
                         sRunWithArgs:
                               sAnon3:
                        snapinProtect: 0
                             sEnabled: 1
                           sReplicate: 1
                            sShutdown: 0
                             sHideLog: 0
                             sTimeout: 0
                        7 rows in set (0.00 sec)
                        
                        

                        But i do not use any snapins

                        Raymond Bell
                        WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

                        Tom ElliottT 1 Reply Last reply Reply Quote 0
                        • Tom ElliottT
                          Tom Elliott @Raymond Bell
                          last edited by

                          @Raymond-Bell do me a favor then, and run:

                          truncate table snapins; (if you don’t mind losing all the snapin definitions.

                          I also notice you ahve a snapin with an ID of 0.

                          delete from snapins where sID=0;

                          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

                          Raymond BellR 1 Reply Last reply Reply Quote 0
                          • Raymond BellR
                            Raymond Bell Testers @Tom Elliott
                            last edited by Raymond Bell

                            @Tom-Elliott Now getting this

                            0_1466525595416_Untitled.png

                            And it is in a group

                            Raymond Bell
                            WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

                            Tom ElliottT 1 Reply Last reply Reply Quote 0
                            • Tom ElliottT
                              Tom Elliott @Raymond Bell
                              last edited by

                              @Raymond-Bell try the same delete changing sID to groupID and snapins to group.

                              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

                              Raymond BellR 1 Reply Last reply Reply Quote 1
                              • Raymond BellR
                                Raymond Bell Testers @Tom Elliott
                                last edited by

                                @Tom-Elliott said in Snapin ID was not set, or unable to be created SVN Revision: 5661:

                                @Raymond-Bell try the same delete changing sID to groupID and snapins to group.

                                Works like a charm now… with

                                delete from groups where groupID=0;

                                Raymond Bell
                                WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

                                Tom ElliottT 1 Reply Last reply Reply Quote 0
                                • Tom ElliottT
                                  Tom Elliott @Raymond Bell
                                  last edited by

                                  @Raymond-Bell I’m going to solve this then. The issue was likely from a far older revision of fog where 0 id’s were very much prevelant. This should no longer be the case, with any luck.

                                  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 1
                                  • 1
                                  • 2
                                  • 2 / 2
                                  • First post
                                    Last post

                                  161

                                  Online

                                  12.1k

                                  Users

                                  17.3k

                                  Topics

                                  155.3k

                                  Posts
                                  Copyright © 2012-2024 FOG Project