Upgrading from Chocolatey For Automate 3.5

[Cubert]

If you are doing a in place upgrade of Chocolatey for Automate 3.5 or older then you should first clean up a few tables in the Automate database. This includes if you ever operated Chocolatey for Automate 3+ on the current host.

These tables have be altered in build 3.6+ to change several parts of the tables parameters.

Code: Select all

DROP TABLE IF EXISTS plugin_p4a_chocolatey_applications;
DROP TABLE IF EXISTS plugin_p4a_chocolatey_cache;
DROP TABLE IF EXISTS plugin_p4a_chocolatey_clients;
DROP TABLE IF EXISTS plugin_p4a_chocolatey_enable;
DROP TABLE IF EXISTS plugin_p4a_chocolatey_properties;
DROP TABLE IF EXISTS plugin_p4a_chocolatey_repos;

[Cubert]

In Build 3.6.0.6 We added a new Plugin Server Function to the Automate Script writer that allows you to drop all the tables needed to upgrade from 3.5 to 3.6

Install 3.6 and restart the dbagent,

Log back into console and create a new Automate script. Add just one line to script as a "Plugins Server Function" Select the sub function "Clear Chocolatey Database Tables" and set no parameters. Once completed have just one agent run the script one time and allow it to complete. Once completed restart the DB agent again and the install should now be completed.



Script should look like this...

Screenshot 2023-10-17 113413.png (20.99 KiB) Viewed 1086 times

All the Chocolatey tables for plugin will get dropped and the DBagent will recreate them from the latest templates.