Storage Location errors after updating to 2.1 from 1.7

UAMAlbany

Hello,

Running:
CollectiveAccess 2.0
PHP 8.3
Server: Dreamhost VPS
Linux vps32058 5.15.0-101-generic #111₂₀.04.1-Ubuntu SMP Mon Mar 11 15:44:43 UTC 2024 x86_64

Was able to update to the new 2.0 from 1.7 without too much trouble using the "caUtils update-from-1.7" script. Seemed to work without errors.

The only big change we made was updating the app.conf to make use of the "Workflow based location tracking". Before, we were using a very primitive solution to track location of deleting the old storage location and replacing it with the current location. Not ideal, and we're thrilled that you've introduced the "Workflow based location tracking" feature.

So the problem:
The error I'm experiencing isn't for all of Providence, it's specifically the "Storage Location Editor" pages. When I try to edit a Storage Location I get the following:

"There are issues with your configuration
General installation instructions can be found here. or more specific information on detected issues review the messages below:
Could not connect to database. Check your database configuration in setup.php: 1054"

When running the "do-configuration-check" script, I got the following response:

"Errors were found:
[1] It looks like the CA_SITE_HOSTNAME setting in your setup.php may be set incorrectly. If you experience any troubles with image display try setting this to "localhost". We came up with this suggestion because this is the hostname you used to access this script. It may only be valid for you (and not for other users of the system) though (e.g. if you use 'localhost' or a feature like /etc/hosts on UNIX-based operating systems) so you have to be very careful when editing this"

I've confirmed the setup.php file is setup correctly by double-checking with dreamhost.com about the hostname address, etc. It also worked smoothly with Providence 1.7.

Ran the "reload-current-values-for-history-tracking-policies", "reload-object-current-location-dates" and the "rebuild-search-index" caUtils. Not sure if it's a different app.conf mistake or something that was introduced in the update from 1.7 to 2.0

Thanks so much for your advice/help,
-Gil

UAMAlbany

Here is the error log:
2025-02-12 6:58:41 - ERROR --> [1::641226] {"code":283,"errorNumber":1054,"errorMessage":"Unknown column 't.object_id' in 'on clause'","sql":"\n\t\t\tSELECT s.object_id, s.idno_sort val\n\t\t\tFROM ca_objects_x_storage_locations\n\t\t\tINNER JOIN _caSortTmpa4a06244c8664014bc97df73e78d8c0a ON caSortTmpa4a06244c8664014bc97df73e78d8c0a.row_id = ca_objects_x_storage_locations.relation_id\n\t\t\tINNER JOIN ca_objects AS s ON t.object_id = s.object_id\n\t\t\tWHERE\n\t\t\t\ts.idno_sort IN (' 19780557 ',' 19780557 01 ',' 19780557 02 ',' 19780557 03 ',' 19780557 04 ',' 19780557 05 ',' 19780557 06 ',' 19780557 07 ',' 19780557 08 ',' 19780557 09 ')\n\t\t","stacktrace":"\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/Db\/mysqli.php::caPrintStacktrace@356<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/Db\/DbStatement.php😃b_mysqli:execute@150<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/Db.php😃bStatement:executeWithParamsAsArray@259<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/BaseFindEngine.php😃b:query@1290<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/BaseFindEngine.php:BaseFindEngine:getRelatedRowIDsForIntrinsic@1229<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/BaseFindEngine.php:BaseFindEngine:getRowIDsForValues@366<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/BaseFindEngine.php:BaseFindEngine:secondarySortHits@330<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/BundlableLabelableBaseModelWithAttributes.php:BaseFindEngine:sortHits@7634<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/BundlableLabelableBaseModelWithAttributes.php:BundlableLabelableBaseModelWithAttributes:makeSearchResult@3408<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/RepresentableBaseModel.php:BundlableLabelableBaseModelWithAttributes:getRelatedBundleFormValues@1335<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/BundlableLabelableBaseModelWithAttributes.php:RepresentableBaseModel:getRelatedBundleFormValues@3538<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/BundlableLabelableBaseModelWithAttributes.php:BundlableLabelableBaseModelWithAttributes:getRelatedHTMLFormBundle@1872<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/BundlableLabelableBaseModelWithAttributes.php:BundlableLabelableBaseModelWithAttributes:getBundleFormHTML@2978<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/themes\/default\/views\/editor\/storage_locations\/screen_html.php:BundlableLabelableBaseModelWithAttributes:getBundleFormHTMLForScreen@59<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/View.php::require@352<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/View.php:View:_render@292<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/Controller\/ActionController.php:View:render@184<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/BaseEditorController.php:ActionController:render@241<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/Controller\/RequestDispatcher.php:BaseEditorController:Edit@289<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/app\/lib\/Controller\/AppController.php:RequestDispatcher:dispatch@108<br\/>\n\n\/home\/uam_admin\/ca.universityartmuseum.org\/index.php:AppController:dispatch@137<br\/>\n"}