Skip to main content

FluentCart 🚀

#Bug Report

Product integrations failing and Advanced FC filters

I have a product. This one has 2 integrations:

  • FluentCRM
  • webhook

They are failing regularly. From 22 orders, it's failing 3 times, no FluentCRM creation and no webhook trigger.

Order is placed, client is created, and the subscription is created, but in 3 cases from 22 sales, no contact in FCRM, no Webhook.

I guess the system should have some sort of verification to validate that the integrations worked, and in case of failure, retry or at least send an alert to the user to know that this is happening.

In this case, the only thing I think we can do users, is create an automation with the sales FluentCart trigger make a second validation ourselves. However, I think this should be built in the product.

  • 5 comments

Carlos Rodera

I tried to filter in FCRM to add manually and the advanced filter is giving error, the filter is basically FluentCart bought and the product selected :

"
Error

Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' (SQL: select count(*) as aggregate from `wp_fc_subscribers` where ((exists (select 1 from `wp_fct_customers` inner join `wp_fct_orders` on `wp_fct_orders`.`customer_id` = `wp_fct_customers`.`id` and `wp_fct_orders`.`payment_status` in ('paid', 'partially_refunded', 'partially_paid') inner join `wp_fct_order_items` on `wp_fct_order_items`.`order_id` = `wp_fct_orders`.`id` where `wp_fct_customers`.`email` = `wp_fc_subscribers`.`email` and `wp_fct_order_items`.`post_id` in ('11661')))))
"

1.00

Carlos Rodera

But I see it doesn't matter which filter I try to use. I use Client, and it is also giving me errors.

1.00

Carlos Rodera

There is no native way to export FluentCart customers to a CSV to import in FluentCRM? The filters are not working. Now I have to manually copy one by one client? There is no export?

Carlos Rodera

this is not a bug but a UX improvement, I exported FCRM contact from site A to Site B by CSV and this same CSV from Site A to B does not auto-match fields, I need to do manually

Amimul Ihsan Mahdi

Hi, thanks for sharing the error details.

This error is coming from a database collation mismatch between the FluentCRM subscriber table and the FluentCart customer/order tables. In the query, one table is using utf8mb4_unicode_520_ci while another is using utf8mb4_unicode_ci, and MySQL cannot compare those email/product values safely with mixed collations.

Please update the database/table collation so the related tables use the same collation, then try the advanced filter again. Ideally, ask your hosting provider or database administrator to align the collations for the FluentCRM and FluentCart tables, especially wp_fc_subscribers, wp_fct_customers, wp_fct_orders, and wp_fct_order_items.

Once the collations match, the “FluentCart bought” filter should run without that SQL collation error.