Skip to main content

Error on contact

When I select a contact the contact loads but in the bottom right I get an error box pop up which says

Unknown column 'Esc97O02C_fluentform_transactions.submission_id' in 'on clause' (SQL: select `Esc97O02C_fluentform_subscriptions`.*, `Esc97O02C_fluentform_transactions`.`currency` from `Esc97O02C_fluentform_subscriptions` inner join `Esc97O02C_fluentform_transactions` on `Esc97O02C_fluentform_subscriptions`.`submission_id` = `Esc97O02C_fluentform_transactions`.`submission_id` where `Esc97O02C_fluentform_transactions`.`payer_email` = 'truncated' order by `Esc97O02C_fluentform_subscriptions`.`created_at` desc)

Is this something I have done wrong in the setup / settings.

Thanks

Nick

Shahjahan Jewel

Our team is taking look into it.

Mignon Iltchenko

Shahjahan JewelΒ Hi - I'm having the same issue.

Shahjahan Jewel

Mignon IltchenkoΒ Can you go to FluentForms and then enable/disable the payment module once? That should resolve the issue.

Nick Porter

Shahjahan JewelΒ worked for me I just enabled payments (can't figure out how to disable it) but i worked.

Mignon Iltchenko

Shahjahan JewelΒ thanks for the reply. The issue was the tags. I deleted the tags and the contact list appeared again.

Shiam Chowdhury

Hello Nick, We are unable to reproduce the issue on our end, everything is working correctly in our test environments. It is possible that you may be using older versions of Fluent Forms or Fluent Forms Pro. If so, please update both plugins to the latest versions.
After updating, kindly deactivate and reactivate the plugins once. If the issue still persists, we recommend opening a support ticket so our team can investigate your setup more closely.
To create ticket please visit: https://support.wpmanageninja.com/#/

Nick Porter

OK thanks for getting back to me I will check it all out later and if needed open a ticket. Thanks again