using providence develop branch database, pawtucket search gives ca_search_log foreign key constraint failure

[0nobody0]

using providence develop branch database, searching for any term in pawtucket, or clicking a collection hierarchy link for an object results in:

Cannot add or update a child row: a foreign key constraint fails (`providencedev`.`ca_search_log`, CONSTRAINT `fk_ca_search_log_user_id` FOREIGN KEY (`user_id`) REFERENCES `ca_users` (`user_id`)) in /usr/share/nginx/html/pawtucket/app/lib/Db/mysqli.php line 316:

Warning: join(): Invalid arguments passed in /usr/share/nginx/html/pawtucket/themes/default/views/system/fatal_error_html.php on line 52
In Db_mysqli->execute() in DbStatement line 151

Warning: join(): Invalid arguments passed in /usr/share/nginx/html/pawtucket/themes/default/views/system/fatal_error_html.php on line 52
At DbStatement->executeWithParamsAsArray() in Db line 261

Warning: join(): Invalid arguments passed in /usr/share/nginx/html/pawtucket/themes/default/views/system/fatal_error_html.php on line 52
At Db->query() in Searchlog line 58

Warning: join(): Invalid arguments passed in /usr/share/nginx/html/pawtucket/themes/default/views/system/fatal_error_html.php on line 52
At Searchlog->log() in SearchEngine line 373

Warning: join(): Invalid arguments passed in /usr/share/nginx/html/pawtucket/themes/default/views/system/fatal_error_html.php on line 52
At SearchEngine->doSearch() in CollectionSearch line 50

Warning: join(): Invalid arguments passed in /usr/share/nginx/html/pawtucket/themes/default/views/system/fatal_error_html.php on line 52
At CollectionSearch->search() in searchHelpers line 449

Warning: join(): Invalid arguments passed in /usr/share/nginx/html/pawtucket/themes/default/views/system/fatal_error_html.php on line 52
At caPuppySearch() in BaseMultiSearchController line 104

Warning: join(): Invalid arguments passed in /usr/share/nginx/html/pawtucket/themes/default/views/system/fatal_error_html.php on line 52
At BaseMultiSearchController->Index() in MultiSearchController line 59

Warning: join(): Invalid arguments passed in /usr/share/nginx/html/pawtucket/themes/default/views/system/fatal_error_html.php on line 52
At MultiSearchController->Index() in RequestDispatcher line 273

Warning: join(): Invalid arguments passed in /usr/share/nginx/html/pawtucket/themes/default/views/system/fatal_error_html.php on line 52
At RequestDispatcher->dispatch() in AppController line 113

Warning: join(): Invalid arguments passed in /usr/share/nginx/html/pawtucket/themes/default/views/system/fatal_error_html.php on line 52
At AppController->dispatch() in index line 124

[0nobody0]

originally occurred using pawtucket2 master branch - same issue seems to occur testing the pawtucket2 develop branch as well

[juliaweist]

What version of MySQL are you running?

…

On Oct 6, 2021, at 1:57 PM, 0nobody0 ***@***.***> wrote: originally occurred using pawtucket2 master branch - same issue seems to occur testing the pawtucket2 develop branch as well — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#29 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AANNQ6QNHADBKATKK6E4CG3UFSEY5ANCNFSM5FNWRSMA>. Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

[0nobody0]

10.5.12-MariaDB

[collectiveaccess]

Just pushed a fix to develop

[0nobody0]

thank you, that seemed to do the trick