Error When Opening Chocolatey

[kkevgreen]

Hi
I receive the following error when I open Chocolatey for Automate:

Error.JPG (13.01 KiB) Viewed 14368 times

Anybody seen this before?

The plugin does open, but any actions I do within the plugin, result in the same error message popping up

Thanks

[Cubert]

Drop all the chocolatey plugin tables in SQL (plugin_sw_chocolatey_xxx) and restart the DBagent to have the tables rebuilt. Looks like you may have an old table that is missing a column.

[kkevgreen]

Thanks for the reply. I have checked and there are no plugin tables in SQL for Chocolatey.
Anything else I could check?

[Cubert]

If you have no SQL tables, then that's the issue for the error.

So first reconfirm missing tables by running the following

Code: Select all

SELECT * FROM labtech.plugin_sw_chocolateyii_approved_apps;

Should return the following, (Your list of approved apps, if any)

Capture.PNG (50.86 KiB) Viewed 14358 times

Do you get this? If not restart the LThosts DB agent and wait 3 minutes and recheck.

[kkevgreen]

Thanks again for the info, but still no joy. I have even rebooted the server and I still get the following:

SQL.JPG (100.99 KiB) Viewed 14355 times

[Cubert]

Is this Chocolatey for labtech or the newer chocolatey for Automate?

If Automate then this is the table names, do you have these?

Capture.PNG (7.3 KiB) Viewed 14353 times

[Cubert]

This

Choco4Automate-logo.png (21.43 KiB) Viewed 14352 times

Or

That

logo.png (25.29 KiB) Viewed 14352 times

[kkevgreen]

Apologies, I should have mentioned it is Chocolatey for Automate (couldn't see a thread for Automate so placed my post in the Chocolatey for Labtech section)
I do not have those tables either though. There are no tables relating to Chocolatey in SQL

[Cubert]

Hmmm.. and restarting the DBagent does nothing. Sounds like a bigger issue then a plugin.

Here is the manual table creation for SQL.

Code: Select all

CREATE TABLE `plugin_p4l_chocolatey_applications` (  `Application` varchar(245) NOT NULL,  `Version` varchar(245) NOT NULL,  `Title` varchar(245) DEFAULT NULL,  `Published` varchar(45) DEFAULT NULL,  `CheckSum` varchar(255) DEFAULT NULL,  `Description` mediumtext,  `Approved` int(11) NOT NULL DEFAULT '0',  `PossiblyBroken` int(11) NOT NULL DEFAULT '0',  `PackageStatus` varchar(255) DEFAULT NULL,  `Install` varchar(5) NOT NULL DEFAULT 'False',  `Update` varchar(5) NOT NULL DEFAULT 'False',  `DeployedCount` int(11) NOT NULL DEFAULT '0',  `RecordUpdate` datetime DEFAULT NULL,  `RepoID` int(4) NOT NULL DEFAULT '0',PRIMARY KEY (`Application`)) ENGINE=InnoDB DEFAULT CHARSET=utf8

Code: Select all

CREATE TABLE `plugin_p4l_chocolatey_computers` (`ClientID` int(11) NOT NULL,`ComputerID` int(11) NOT NULL,`Application` varchar(255) NOT NULL,`Installs` varchar(5) NOT NULL DEFAULT 'False',`Updates` varchar(5) NOT NULL DEFAULT 'False',`AppInstalled` int(11) NOT NULL DEFAULT '0',`InstallDate` datetime DEFAULT NULL,`UninstallDate` datetime DEFAULT NULL,`Attempts` int(11) NOT NULL DEFAULT '0', `InstalledVersion` varchar(45) DEFAULT NULL, PRIMARY KEY (`ClientID`,`ComputerID`,`Application`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Code: Select all

CREATE TABLE `plugin_p4l_chocolatey_client_enable` (`ClientID` int(11) NOT NULL,`Active` int(11) NOT NULL DEFAULT '0',`LastScanDate` datetime DEFAULT NULL,`Suspend` int(11) NOT NULL DEFAULT '0',PRIMARY KEY (`ClientID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Code: Select all

CREATE TABLE `plugin_p4l_chocolatey_clients` (`ClientID` int(11) NOT NULL,`Application` varchar(255) NOT NULL DEFAULT '',`ServerInstalls` varchar(5) NOT NULL DEFAULT 'False',`ServerUpdates` varchar(5) NOT NULL DEFAULT 'False',`WorkstationInstalls` varchar(5) NOT NULL DEFAULT 'False',`WorkstationUpdates` varchar(5) NOT NULL DEFAULT 'False',`Version` varchar(245) DEFAULT NULL,`Title` varchar(255) NOT NULL,`Install` varchar(5) NOT NULL DEFAULT 'False',`Update` varchar(5) NOT NULL DEFAULT 'False',PRIMARY KEY (`Application`,`ClientID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Code: Select all

CREATE TABLE `plugin_p4l_chocolatey_properties` (`Name` varchar(255) NOT NULL,`Value` text,PRIMARY KEY (`Name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Code: Select all

CREATE TABLE `plugin_p4l_chocolatey_repos` (`ID` int(11) NOT NULL AUTO_INCREMENT,`Name` varchar(255) NOT NULL,`URL` varchar(255) NOT NULL,`Username` varchar(245) DEFAULT NULL,`Password` varchar(245) DEFAULT NULL,`Active` varchar(5) NOT NULL DEFAULT 'False',PRIMARY KEY (`URL`),UNIQUE KEY `ID_UNIQUE` (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

Code: Select all

CREATE TABLE `plugin_p4l_chocolatey_commands` (`ID` int(11) NOT NULL AUTO_INCREMENT,`ClientID` int(11) DEFAULT NULL,`ComputerID` int(11) DEFAULT NULL,`Application` varchar(255) DEFAULT NULL,`Command` varchar(255) DEFAULT NULL,`IssueDate` datetime DEFAULT NULL,`ExecuteDate` datetime DEFAULT NULL,`Results` mediumtext,`Errors` varchar(255) DEFAULT NULL,`RetryCount` int(11) NOT NULL DEFAULT '0',`Options` varchar(255) DEFAULT NULL,PRIMARY KEY (`ID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Code: Select all

CREATE TABLE `plugin_p4l_chocolatey_computer_enable` (`ComputerID` int(11) NOT NULL,`Active` int(11) NOT NULL DEFAULT '1',`LastScanDate` datetime DEFAULT NULL,`Suspend` int(11) NOT NULL DEFAULT '0',PRIMARY KEY (`ComputerID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Code: Select all

INSERT INTO `lt_scripts` (`FolderId`,`ScriptName`,`ScriptNotes`,`Permission`,`EditPermission`,`ComputerScript`,`LocationScript`,`MaintenanceScript`,`FunctionScript`,`LicenseData`,`ScriptData`,`ScriptVersion`,`ScriptGuid`,`ScriptFlags`,`Parameters`,`Last_User`,`Last_Date`) VALUES (8,'P4L Chocolatey For LabTech  Maintenance Service','This is a maintenance script used by the Chocolatey  Plugin. Not for manual execution.\r\n\r\nAuhor:Shannon Anderson\r\nDate:11/01/2017\r\nVersion 3.0.0.16\r\n','0,','0,',1,0,0,0,'H4sIAAAAAAAEAFWPzQrCMBCE74LvkAdoyI8m1LLkoiKIgljxvm33EJC0pA3Yt5cWhXoaZme+hYGLryn0dMABHTzGjpwCMSvcU9i3KQwUnQSxcHB8dz5ODLkyhQbHjJ3Ta2TaZkxLZVheaFVIy25XEIsylHX03fCk2Ps2TF//D9/8lHzjSFUkjd5xi1pxpcjyvMYtl2SksZU0iJsfPwMgllvWqw/mMEhw2wAAAA==','H4sIAAAAAAAEAO1d/XOayhr++Xam/8NO2pzoPdGIXzFJ62iVpM4x4hFN22nOJAQ3CbcIHMAmmXvu/353ARUxLIQsiet0OtMIrAjP7vvxvPu+ux9E2VQMuy3ZUv3tGwA+uMeWc4AO+XvblPDVYwWqYwvszS70JVOaQBuaVv30W+u0/WHPd8Zrc6LqV5Lq+5J78zPURNG1Ovdhb/nEUquTqTKuQ+4KFirFg1xVKnI5joPVXE2WyrkCrBQq1atCRZJKs7s4X3DeYc//Et7tRBsa8wdryrb3AN4n7/zxVHOOO+N65cOe78j/0tzSC3NL14r1mne+uHS+VO/0xGGz2z0eNE/5L8LgD69ZaalZOYBvxQedbtr1Ano1/Nc719I1W9GmEJ+ff/auCVZXmSjOV2YfvSsdbQw1W3LeG131H/rRWwBGQLBIQJArHoRjGHjRYuC4FDhOARiu+mrIVPcJgwsNFH4wBJ2TnjDgQac3FIChTm8U7cIoqxfyrS7rqmTDhwtZnxhTLG4gc9lSFfSonfbl7mXLO+0cNA1DVWTnFdBRR7NsSVUt9HFkjNFN8KembcMJEpbLLDiT1ClEt9vZlp37KePtnV104N3RPWzNnwAdDM0pnP8BO9xOFgg90B71u51Wc8iDP/hvYNRv44+LH/oIMrPP4HfAZR+XpGeOCI4lUSkWCAOC40JUjQhVKNtgjuW1qU/AZcRguQRfPvNoYPnHCfgI/J0MJG0MfCMHXfb3eoiCc998MNWsRKqtyFJ/7ZP6aw5ESLfthwBYfhy3+qFwxg8Go57oXS8TcSyxhCNXIJiIesPQ79CIvYWqCnI9vW/q14oKQY6/h/IUf6OvoyH6AD49GJJlgRwa0RM8dLcUeA8yGQ3e5fSr/2AR0aCdv4NXrlbL5tv6nabq0li0TUW7yezc2rZhHe7tLeQlr5s3e4qrLvOGhfRadgv8Jk2MI+c/IPJD0G8OP3/cxv9vH20j0z5CelvsD4TjTpffPl/c6/xKCRkKQRVXd6RsAK2paieTonJI73NJe7+YptbjCJ1fKqRiFiq0xSNNgDiuTECodXiOROIGfcb+eWDAuYd5eA9DtFAhRAsduua6/SnR+KtuFLxtXZ5O0G9bjkUUoY1e4MY6byJ9NLKQZjr3G8lgJ7xOB+yz1AEkglBfeByA/8oDTbfBtT7VxjngubHgWkLmYJyKmqixBONLEq0DpoApkQZYUNAo8w+muDqRkbpcMZKFYp/IE802bv8R9IQvmewuphLeeTjGXILb8TjIgoLg00s8Mx4Hodxl1DnjqynPBd4+NXqN43N3uvkjHfSoM7hN0ZkcdU72ikozQEYpj6Ew/rKWSpMogfy9DOEYCeDMW5mHaXJA/KEYBnIlgccwkfZMB0622M5LiuTaEZXSmiCzfpF0IjIJGXJictYfCCeD5ilyHJuJ+FmYi0EI0HD7awrvFjWKvPXUbvjaT9wDYW7KmvbAC4r+2oWOicCQ3ZRVOaVrWtfOUSFhRZ5eCpG9+MozKJ2tz0JLSCSb1P2V0muJZv3weNRrDTtCSp4ydf8lVaTIsrqkzOnCRD0cunZiSt8I0xNn6lHUjRVn6mHV1xNnPOrc+4Jrr40FEM01bXALzRCHe+OCrc9Qh+mONPpBzjShIiZaPCMNr9nvh2VbrLQg51vQD3syheeAPxXOeAKcwQYRaDLFQaij6c5IEdAMNohAkymWQh3NE354xg9EnypdwXO1SQSi1BkKU4h2Oy2+J/IEj7B++EibCEypcxmmMJ2LtBg1WENbRuDLFAl60VkA6gTlFd3GFb+Fst9InaKkitV+kZShy3f51hDI+lSzM//OguOBcBqR3nABNelKhV7iAv7dn9DLZcCcm5DJkEpvFKkTnjQJY6LAxrb1t2o6qbDbIZqzeYMel3f6ZZwoPlGkzoXSRJFoeR7BIghoKQRGLhl21HnP2o1ALswLEoR+Sxj1hsmAo05xUo31HFSjFak/vBhDl1ox0r+avfZK3ljBPT2rYsKnnMKjdDQsde60duMba9ixZEsWtE39zrGGYar29BsO0Q+ELyHOaRSYTE3sRLj4ASSCqBZDICyEufU9wXPdfLMgZI++uEmzP1ibotcfDNMRY+rkZ93EeKWICDEAp/oSEcRkwhrGihIXEVVTNVCk1OWFhguR1sbcmDcel9unjjfqNClN8BKZjQYC1WfxQ3B79jAshVGc9RyG5EpGJxrWmOeCNnzgNEDuIW55IL5LVzhJhid1spMunqTiwFWpjZs5FkJ2Vnz6iCJb6uQnTSyJ/kxgTMWNWhqS/EO6gZZXhJUPc26Om53uaMDHQ5U6M0oT1RQWcYi1coOfFV3ugktfyY1/CQcQWLZhSeXgJRsGIx794XZ2nSodwroN89/+6N09sziVDTzPosnS6SzYfaw0KBWPr0SduKVqgWOWQCpzIrzUkekgSJ2tvZp2C6r1oHqrhKg3AjVenfAKEJgIJUedu6Vqhl8y/ZgpqhbBah8j9ZSllKnsumetcDOfqHnOCjcR9aU9YQi6nT/4pTJTEKIePjfP+MQFCCWmKCJRvQZwCHZf9WmhsKiUe+pzXmtHrb/o5g/LfZqZixUCoSAOv/X5ZDgmIIJ4ppwlIEVo/kSCnx6GCQggnkF/tSAZxVkcZxGl+RyOt/Ccq2Dnq8Y5EzUNF+BGuhM1ZaZYI1GdrjqddOYYohBkijFF5OmnO51QZooaRfiowdRcylAxlda36QlDZabI1bomDJWZ4lzrlTBUZqvG6QUDHxWmkvliLaqVllGpMFW9tOlGpbL5OYAvYFQqTCUErpdRqTCVpfeiRoWplLsIo7JapkVZkf3iKutkVn5xFRpm5RdXSW5W2OIqxNyzGOv4AFWxbJBTQc4Ev93YR2D7TtHGirl93h2KP2W34U93kx4rb9+HhCUfz1cb8OKom6xUoko9BbDyWopgP0wRxEP60TVZnoNsgnXoXg/Z6AS2JSji5rAN8XokQMGr5gBomroJFA18Pe2CsbeeTjJoqZOiX9DOoKXOlNiEFhimLkPLArKk4XXxJdk5stEVvENKMmypMykGseWdoSrrGlLBNhwDWwd3kqkp2k0yTKlzsDXGNGRO8om+f5U6E0vV5JdI2wQWQpB658vrPEbjrTm19QlOixX1axuNNwg8DwB4K++7D/f2zbu+Q+Os8i7odlt5dAJ99RbdQbzFikADTfSipqVr6IqTZ1uo7RX3igVuH53wNlkEpXwB/au9ffMezzUjRncC7RyGFkEE8Gpy2CPR76wwj2QLfRNrmY9RbRHFwW0dmXIR7JvwGtkFTXbYpYhuotnqw6xbd9BD3pmKDXO3OnJHncfLOzQWyaEtqchL1aAFTCiN3UQw/BToBxR0s8LbN9c6uiLfgsx73A7bG+cO2bdv/uvA/94yVMVGbZ3reREfZbb+2UIN3gHg/2Gn4ffCX+7XljchCFycgTq/wLkXlOsMeq4c/BsUsujn/yVM7dyxs3kV/r8v2bfgvXvc0RCZFtxtqrYyfnK9O8+o6LRxBrf/SfBme7Mfdzfe8zbhy265Y+1/ULXgE355l8ZPg5xkGFAbe4/g/kE4/P772zfoKJ6CmIsNOY+2Sj1IwBY3QNIVYsTEP7tnze6IT1aqW6UeNng1XMOCL22+yw/5p1SqBxNFOz2QeVrWlLRoZmWjomrgCDy/gMS3JeijtSRw7AnxSk2Jr7xjVk/SmA+qBoisFFnceaViZHEpexQ+fP8c8YNvyUYv9cBNqqOXWDM4AyKdIo996pPOaSJFLLZKGynqc85pIoVXUAxFik5c76n4JVhxn0X8FhaZMn5hUY/1xO8F5zj32Zr9jVj2d6lSlvIQYmrZSrJZnBUsp6TsmVpahbHax32mJnZfVJMxNVkbtaLP6gqwlIV089aivHSI0iWQLHD64MRnSGzSMHUDmrYCZwS1J02cmNqp2PfQTyc1o0Z9RpbB1Ay3g/heS2jz7UQ0tcbUwpMRa9sY+h1ygW+hqoJcT++b+rUTXuTvoTx1or66qsgPYKohVG1TkfHESq6lTyY4CvJdfLBsOMkP4b2d5zVZHyvazV+Hh6PhcS1/AtGzmuhEZtas5U7NoAbHpj75hGxUtew1aSx1SyMbc3UJ1JtfT7vJepGp9FeukmyrPNR5ULPS2bejRp3apIngAXGCLArAxSn1Ie+dy99PQjhjvTHB45LOomS1MJ60ljA/P51paqDrYwgWF9FpGwGOg7RPW22L/5oswaYWxrjWEvIYjAsBkQ7jqjHFuF6SFNTYoksx64KCmxdQHk0btKS/cg00dw9pRQOqZN5AE0iGAaD2UzF1zd3xbUvkh+DG1KfGhaxrsmRfTKT7CxXiOelioVw72gLgCuLJcYAcW/D3FJoxFeBTkWdq6iUWKTsZCKP+RUvotZrDjH+iT+T7zUFzKAzAzj87WUzaUL9Ycef/jlLB/4CpCZ20suaRfnHoQCKjfcDWTA9xc+bAVMUi5QhvBulNwoo4fxCaecMKQ7wQgvPhqHmGBWPY6Y2SraBywFSaLNFBEqeGgd4EjTrQF8TPTl4Szn2dKJaFTu4CeK84Vy3nt/PpiD/13NjahrhRB9RniVJFJsKNWpU7yuNoc3JWg8YgZs3QSkLaEuhcrJmOA7bSWIn7ufr8ni6uE8I5fpJp4eToKwiuVEn7sVBxOad+6HsDfQs3bvyVziClzow2RtlR5z9rouxi7n7wVLjYIi3EyNjc43Nj5aXi+Rc3O7uPA/QiDtCf/+TyhfNFwN6JlpGC9p8eDMmyQE7TsYCDnNPqia4lyHnKwFm62NXIMUNJOBlwsaPi0xxMrsAUISJasiUYYvroZDNWjGXGnFX42cGQaMcc19y9r7doPbZgJrSnpgYk7QHgnIdVQ+ZCn5Id4wrUWdCmGDKuwBahiW/JiikNJaYK+CITerHQpQQUUwyHCNSA73ebLWJ9gC9VJHOJ00Qud71cE99mEQNo6F3Jst16s51dd3uGdPZn4ApMcaOX1XmvUdQ0O8bzqejw/zd/pLwSqgAA',1,'e1be0529-6a21-11e6-8ca4-0e5056b05aa3',0,'MYCMD','admin@localhost','2017-11-01 15:15:09')

[Cubert]

run each of these commands in SQL to create the tables and the script needed to operate Chocolatey