Enabling database cleanup tool causes Error is not of type string error
I ran the amazing Scheduled Job a few times to cleanup the database of a client's site. Afterwards, I could no longer access AdvImport and CiviCRM was reporting a Error is not of type String
What is happening:
- Cleanup the tables with scheduled job
- Go to Admin > Advanced Import
- Big error message with
Error is not of type String
Basically, the cleanup happens with the tables and I think that you are then setting the table_name to NULL is the actual database of civicrm_advimport. This is what is causing the error since CiviCRM assumes it's a string. Removing all the entries that are NULL actually resolves this issue.
Do we need to keep these around? Probably not if we are using the cleanup tool.