• 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 @Quazz
      last edited by

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

      @Raymond-Bell Ubuntu 16.04?

      14.04

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

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

        @Tom-Elliott 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 @Raymond Bell
          last edited by

          @Raymond-Bell What version/revision?

          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 r5716 newest
            going back to 5633

            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

              @Raymond-Bell

              Please try this:

              delete from snapinAssoc WHERE saSnapinID NOT IN (SELECT snapinID 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 Tom ElliottT 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:

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

                                            184

                                            Online

                                            12.1k

                                            Users

                                            17.3k

                                            Topics

                                            155.3k

                                            Posts
                                            Copyright © 2012-2024 FOG Project