...

ALTER TABLE app_package_activity_plugin CHANGE pluginProperties pluginProperties LONGTEXT;

Joget DX on MySQL 8

Joget DX supports MySQL 8 database out of the box, except if you use MySQL 8 "caching_sha2_password" new authentication plugin instead of the older "mysql_native_password".

Read https://mysqlserverteam.com/upgrading-to-mysql-8-0-default-authentication-plugin-considerations/

Because Joget DX ships with MariaDB JDBC drivers, you will need to download and paste the latest MySQL JDBC driver into "[JogetRootFolder]\apache-tomcat-8.5.41\webapps\jw\WEB-INF\lib\".

Or you could download the latest "MariaDB Connector/J 2.5.4 Stable":https://downloads.mariadb.org/connector-java/2.5.4/ . FYI Joget DX ships with @mariadb-java-client-2.5.0.jar@.