02-04-2020, 02:42 PM
This is a strange error to have as this table has been in TACTIC for a long time. It would mean that you don't have the search type registered in the "search_object" table in the "sthpw".
You can look at the search object table in the admin side bar under Schema Views / Global. Search for the change_timestamp table.
You can also try to run the upgrade_db script
cd <TACTIC_INSTALL_DIR>/src/bin
python3 upgrade_db.py -f
This will upgrade the database to the current version.
If that doesn't work, then you can manually set the database to an older version:
psql -U postgres sthpw
sthpw=# select code, last_version_update from project;
This will show a list of the projects and their database version. Downgrade the version for "sthpw" to something older
sthpw=# update project set last_version_update = '4.0.0.a01' where code = 'sthpw';
And then run from the shell
python3 upgrade_db.py -f
You will see a lot of output warnings. Ignore them. They are just the database complaining about adding columns that already exist and others.
It should work after that.
You can look at the search object table in the admin side bar under Schema Views / Global. Search for the change_timestamp table.
You can also try to run the upgrade_db script
cd <TACTIC_INSTALL_DIR>/src/bin
python3 upgrade_db.py -f
This will upgrade the database to the current version.
If that doesn't work, then you can manually set the database to an older version:
psql -U postgres sthpw
sthpw=# select code, last_version_update from project;
This will show a list of the projects and their database version. Downgrade the version for "sthpw" to something older
sthpw=# update project set last_version_update = '4.0.0.a01' where code = 'sthpw';
And then run from the shell
python3 upgrade_db.py -f
You will see a lot of output warnings. Ignore them. They are just the database complaining about adding columns that already exist and others.
It should work after that.