Errors After 2.x Upgrade

AdminBoB

Hello,

I am an IT person attempting to support a company that uses Collective Access. We are getting the following two errors which may or may not have pre-existed before the upgrade but were only noticed after the upgrade.

The first is appearing on every page in the admin:

Something went wrong
There was an uncaught fatal error. Please contact your system administrator and check the CollectiveAccess log files.

When I look in the log, I seem to be getting pages of the same error:
2025-02-05 12:11:33 - ERROR --> [1::581017] {"code":283,"errorNumber":1054,"errorMessage":"Unknown column 't.representation_id' in 'ON'","sql":"\n\t\t\tSELECT s.object_id, s.type_id val\n\t\t\tFROM ca_object_representations\n\t\t\tINNER JOIN _caSortTmpa645e3531bf640bba16e5944b4b32854 ON _caSortTmpa645e3531bf640bba16e5944b4b32854.row_id = ca_object_representations.representation_id\n\t\t\tLEFT JOIN ca_objects_x_object_representations AS l ON t.representation_id = l.representation_id\nLEFT JOIN ca_objects AS s ON s.object_id = l.object_id\n\t\t\tWHERE\n\t\t\t\ts.type_id IN (29)\n\t\t","stacktrace":"\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/Db\/mysqli.php::caPrintStacktrace@356<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/Db\/DbStatement.php:Db_mysqli:execute@150<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/Db.php:DbStatement:executeWithParamsAsArray@259<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/BaseFindEngine.php:Db:query@1290<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/BaseFindEngine.php:BaseFindEngine:_getRelatedRowIDsForIntrinsic@1229<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/BaseFindEngine.php:BaseFindEngine:_getRowIDsForValues@366<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/BaseFindEngine.php:BaseFindEngine:_secondarySortHits@330<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/BundlableLabelableBaseModelWithAttributes.php:BaseFindEngine:sortHits@7634<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/helpers\/utilityHelpers.php:BundlableLabelableBaseModelWithAttributes:makeSearchResult@2731<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/BundlableLabelableBaseModelWithAttributes.php::caMakeSearchResult@7283<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/Search\/SearchResult.php:BundlableLabelableBaseModelWithAttributes:getRelatedItems@835<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/Search\/SearchResult.php:SearchResult:prefetchRelated@1643<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/SearchResultsRepresentableTrait.php:SearchResult:get@147<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/Parsers\/DisplayTemplateParser.php:ObjectSearchResult:get@1278<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/Parsers\/DisplayTemplateParser.php:DisplayTemplateParser:_getValues@270<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/Parsers\/DisplayTemplateParser.php:DisplayTemplateParser:process@62<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/Parsers\/DisplayTemplateParser.php:DisplayTemplateParser:evaluate@923<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/Parsers\/DisplayTemplateParser.php:DisplayTemplateParser:_processChildren@989<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/Parsers\/DisplayTemplateParser.php:DisplayTemplateParser:_processChildren@513<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/Parsers\/DisplayTemplateParser.php:DisplayTemplateParser:_processChildren@277<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/Parsers\/DisplayTemplateParser.php:DisplayTemplateParser:process@62<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/helpers\/displayHelpers.php:DisplayTemplateParser:evaluate@2870<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/BundlableLabelableBaseModelWithAttributes.php::caProcessTemplateForIDs@841<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/helpers\/displayHelpers.php:BundlableLabelableBaseModelWithAttributes:getWithTemplate@5338<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/controllers\/DetailController.php::caDoTemplateTagSubstitution@557<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/Controller\/RequestDispatcher.php:DetailController:__call@289<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/app\/lib\/Controller\/AppController.php:RequestDispatcher:dispatch@108<br\/>\n\n\/home\/laandm\/domains\/leatherarchives.org\/public_html\/ca\/index.php:AppController:dispatch@133<br\/>\n"}

The second error is when I log into the admin and attempt to run Manage > Administration > Configuration Check. This is what I get:
Fatal error: Uncaught TypeError: preg_match(): Argument #2 ($subject) must be of type string, array given in /home/laandm/domains/leatherarchives.org/public_html/ca/admin/app/helpers/utilityHelpers.php:585 Stack trace: #0 /home/laandm/domains/leatherarchives.org/public_html/ca/admin/app/helpers/utilityHelpers.php(585): preg_match() #1 /home/laandm/domains/leatherarchives.org/public_html/ca/admin/app/helpers/mediaPluginHelpers.php(171): caIsValidFilePath() #2 /home/laandm/domains/leatherarchives.org/public_html/ca/admin/app/lib/Plugins/Media/QuicktimeVR.php(125): caMediaPluginFFmpegInstalled() #3 /home/laandm/domains/leatherarchives.org/public_html/ca/admin/app/lib/Plugins/Media/QuicktimeVR.php(134): WLPlugMediaQuicktimeVR->register() #4 /home/laandm/domains/leatherarchives.org/public_html/ca/admin/app/lib/Media.php(198): WLPlugMediaQuicktimeVR->checkStatus() #5 /home/laandm/domains/leatherarchives.org/public_html/ca/admin/app/controllers/administrate/setup/ConfigurationCheckController.php(65): Media->checkPluginStatus() #6 /home/laandm/domains/leatherarchives.org/public_html/ca/admin/app/lib/Controller/RequestDispatcher.php(289): ConfigurationCheckController->DoCheck() #7 /home/laandm/domains/leatherarchives.org/public_html/ca/admin/app/lib/Controller/AppController.php(108): RequestDispatcher->dispatch() #8 /home/laandm/domains/leatherarchives.org/public_html/ca/admin/index.php(137): AppController->dispatch() #9 {main} thrown in /home/laandm/domains/leatherarchives.org/public_html/ca/admin/app/helpers/utilityHelpers.php on line 585

Any suggestions on how to correct these would be appreciated.

seth

what version, exactly, are you running?

AdminBoB

seth

Providence 2.0.3
Pawtucket2 2.0.0

darrigan

And which version of PHP?

AdminBoB

darrigan

PHP 8.2.27

AdminBoB

@darrigan and @seth. Any suggestions on how to proceed at this point? Any information of files I can provide to assist in the troubleshooting process?

monica

AdminBoB Please give us as much information as you can.

a run down of what the prior version was before upgrade
what upgrade steps you took to go from that to version 2.
You have told us which PHP version you are running, were you running 7.4 before the upgrade and if so, how did you upgrade PHP (Some times you might have upgraded the CLI to 8.2, but the Webserver is still on 7.4).
Which web service are you using (Apache, Nginx) are you using FPM?
What type and version of database?

AdminBoB

Thanks monica

After talking with our host about the issue, they said they could restart the shared server that our environment is running on as they felt that could be the issue. They have since done that, and the issues have resolved.

Thank you all for your replies. I'm considering the matter closed.