Manual Version update from 6.0.6 directly to 6.7.2

Pratik

Hi, so after the failing to upgrade the system using the backend maintenance panel, we went through an effort of manually updating the system by copying the files of latest dedalo directly from the repository.

After, several folder replacements and configuration of .pgpass files the system finally greeted with a login screen that showed the code version as the latest 6.7.2.

However, now the problem is with the old database structure, where the data version is still 6.0.2 and I cannot get past the login screen despite entering the correct credentials. The login screen throws a "throwable exception when calling dedalo API" error and i can no longer access the backend or maintenance panel at all.

Trying to solve this problem with chat gpt where it suggested to manually run the database structure update sql or php files generally found in updates folder of the latest pack but i can not find any such files.

Any one else faced similar issue or if has any idea regarding this please provide your valuable guidance.

Steps I had followed -
downloaded and unpacked the latest dedalo folder
Replaced the dedalo core folder items - core, shared, config, db_config and updated parameters to match the existing credentials
Set up .pgpass file for database operations

Thank you.

Alex

Pratik

Hi and welcome!

As I see, your code is not sync with your data and Dédalo needs to update both in at the same time. In the maintenance panel you have 4 different update tasks to do to update your Dédalo installation and they needs to be applied with the correct order:

Update Ontology
Update Code
Update Data
Update Tools
Update Ontology

Every time that you update your code, you need to update your data and your ontology. The tools can be update at any time, but your data and your code needs to be synced.

You can read the documentation about it here.

So, you need to update your data, but, in the version 6.3 an important change was implemented in the ontology and a new columns named model and term was added to it. And without this columns you will not able to login and do the maintenance process.

Ok, you have 2 options:

install a v6.3 and run the updates in the panel (more safe)

you can download the v6.3 here

run this SQL and then, apply the updates in the panel. (more quickly but you can see wrong labels in menus and maintenance, and unexpected behaviour)

ALTER TABLE "jer_dd"
ADD "term" jsonb NULL;
COMMENT ON TABLE "jer_dd" IS 'Term and translations';

ALTER TABLE "jer_dd"
ADD "model" text NULL;
COMMENT ON TABLE "jer_dd" IS 'Model, a typology of the tipo';

So, try and tell me if you can update.

Best