RVY200836: Known Issue: RayVentory DataHub 12.5 [Update 2] Executing an SQL Script when migrating or installation of RayVentory DataHub and encountering an SQL error.

Issue:

If you encounter an SQL error in RayVentory DataHub during the migration of MariaDB, this may indicate a problem with the database structure. The error appears to suggest that a specific column, in this case 'Description' and 'Owner', are not recognized in the table.

Solution:

To fix the issue, you will need to execute an SQL script that adds the necessary columns and update the version of current database. In this case, the script is:

ALTER TABLE Task ADD COLUMN Owner VARCHAR(255), ADD COLUMN Description TEXT;

UPDATE VersionHistory SET VersionChangeset = 5136;

Run the script in your database and then try to use RayVentory DataHub again. If the error persists, you may need to take further steps to resolve the problem, such as checking the database connections or updating the application. It is also important to note that SQL errors often indicate a problem with the database schema or data, so it is a good idea to back up your data before making any changes to the database.