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

[Raymond Bell]

@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>

[Tom Elliott]

@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;

[Tom Elliott]

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

[Raymond Bell]

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

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

Tried on 3 different computers

[Raymond Bell]

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

[Raymond Bell]

@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

[Tom Elliott]

Can you get me output of mysql command:

SELECT * FROM snapins \G

[Raymond Bell]

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

@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

[Tom Elliott]

@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;

[Raymond Bell]

@Tom-Elliott Now getting this

And it is in a group

[Tom Elliott]

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

[Raymond Bell]

@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;

[Tom Elliott]

@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.