foreign key error, Pawtucket doesn't show public items for unauthenticated users
Hello all, I've got Pawtucket configured with "accessible to public" facets and objects, however, I keep getting this error when trying to browse objects or collections in our Pawtucket2 instance:
Cannot add or update a child row: a foreign key constraint fails (`aggregator_db`.`ca_search_log`, CONSTRAINT `ca_search_log_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `ca_users` (`user_id`)) in /data/unco/aggregator/pawtucket/app/lib/Db/mysqli.php line 316:
Warning: join(): Invalid arguments passed in /data/unco/aggregator/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 /data/unco/aggregator/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 /data/unco/aggregator/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 /data/unco/aggregator/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 /data/unco/aggregator/pawtucket/themes/default/views/system/fatal_error_html.php on line 52
- At SearchEngine->doSearch() in ObjectSearch line 50
Warning: join(): Invalid arguments passed in /data/unco/aggregator/pawtucket/themes/default/views/system/fatal_error_html.php on line 52
- At ObjectSearch->search() in BrowseEngine line 2515
Warning: join(): Invalid arguments passed in /data/unco/aggregator/pawtucket/themes/default/views/system/fatal_error_html.php on line 52
- At BrowseEngine->execute() in BaseBrowse line 48
Warning: join(): Invalid arguments passed in /data/unco/aggregator/pawtucket/themes/default/views/system/fatal_error_html.php on line 52
- At BaseBrowse->execute() in BrowseController line 272
Warning: join(): Invalid arguments passed in /data/unco/aggregator/pawtucket/themes/default/views/system/fatal_error_html.php on line 52
- At BrowseController->__call() in RequestDispatcher line 273
Warning: join(): Invalid arguments passed in /data/unco/aggregator/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 /data/unco/aggregator/pawtucket/themes/default/views/system/fatal_error_html.php on line 52
- At AppController->dispatch() in index line 124
Any ideas on how/where to update configuration to allow unauthenticated users to browse all publicly accessible objects? Thanks!
Gary