Make a quick vote 🗳 ️How do you refer to SuiteCRM extensions: add-ons or plug-ins? Click here to have your say 👈

Error message on workflow operation

Hi Please see the following error message that keeps occuring on my system:

Wed Oct 6 07:51:41 2021 [7700][-none-][FATAL] Mysqli_query failed.
Wed Oct 6 07:51:41 2021 [7700][-none-][FATAL] Query Failed: SELECT countries.name as country_value , (SELECT default_name FROM directory_country_region WHERE code=‘MH’) as state_value FROM countries WHERE countries.code=‘IE’ : MySQL error 1242: Subquery returns more than 1 row
Wed Oct 6 08:50:16 2021 [7785][8f2a1190-06f3-fc66-ec03-60c089541384][FATAL] Caught error: stat(): stat failed for upload/import/status_8f2a1190-06f3-fc66-ec03-60c089541384.csv
Wed Oct 6 08:50:16 2021 [7785][8f2a1190-06f3-fc66-ec03-60c089541384][FATAL] Caught error: touch(): UploadStream::stream_metadata is not implemented!
Wed Oct 6 10:19:19 2021 [7785][-none-][FATAL] Could not connect to DB server toc-crm-db.mysql.database.azure.com as toc_suitecrm. port : MySQL server has gone away
Wed Oct 6 12:27:30 2021 [7841][-none-][FATAL] WC Order-shopify_sync_date=2021-10-06&shopify_sync_date_to=2021-10-06
Thu Oct 7 07:39:31 2021 [7797][8f2a1190-06f3-fc66-ec03-60c089541384][FATAL] DEBUG: token already sent
Thu Oct 7 07:42:50 2021 [7769][8f2a1190-06f3-fc66-ec03-60c089541384][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Thu Oct 7 07:43:52 2021 [7846][-none-][FATAL] WC Order-shopify_sync_date=2021-10-06&shopify_sync_date_to=2021-10-07
Thu Oct 7 07:43:56 2021 [7846][-none-][FATAL] Mysqli_query failed.
Thu Oct 7 07:43:56 2021 [7846][-none-][FATAL] Query Failed: SELECT countries.name as country_value , (SELECT default_name FROM directory_country_region WHERE code=‘MH’) as state_value FROM countries WHERE countries.code=‘IE’ : MySQL error 1242: Subquery returns more than 1 row
Thu Oct 7 07:43:56 2021 [7846][-none-][FATAL] Mysqli_query failed.
Thu Oct 7 07:43:56 2021 [7846][-none-][FATAL] Query Failed: SELECT countries.name as country_value , (SELECT default_name FROM directory_country_region WHERE code=‘MH’) as state_value FROM countries WHERE countries.code=‘IE’ : MySQL error 1242: Subquery returns more than 1 row
Thu Oct 7 07:45:42 2021 [7846][-none-][FATAL] Mysqli_query failed.
Thu Oct 7 07:45:42 2021 [7846][-none-][FATAL] Query Failed: SELECT countries.name as country_value , (SELECT default_name FROM directory_country_region WHERE code=‘MH’) as state_value FROM countries WHERE countries.code=‘IE’ : MySQL error 1242: Subquery returns more than 1 row
Thu Oct 7 07:45:43 2021 [7846][-none-][FATAL] Mysqli_query failed.
Thu Oct 7 07:45:43 2021 [7846][-none-][FATAL] Query Failed: SELECT countries.name as country_value , (SELECT default_name FROM directory_country_region WHERE code=‘MH’) as state_value FROM countries WHERE countries.code=‘IE’ : MySQL error 1242: Subquery returns more than 1 row
Thu Oct 7 07:45:44 2021 [7846][-none-][FATAL] Mysqli_query failed.
Thu Oct 7 07:45:44 2021 [7846][-none-][FATAL] Query Failed: SELECT countries.name as country_value , (SELECT default_name FROM directory_country_region WHERE code=‘MH’) as state_value FROM countries WHERE countries.code=‘IE’ : MySQL error 1242: Subquery returns more than 1 row

Please help
Thanks Ken

In your database, you have a table called directory_country_region , which contains two rows that have code='MH', and it seems only one row was expected.

Note that this is not a default SuiteCRM table, it is something from an add-on or from custom code you have…

1 Like

Thanks for your reply