Database Error in Visitor Insights Page

Hi @kmfoysal06,

Thank you for opening the thread!

Please accept our apologies for the delayed response. We have been trying to replicate the issue, but so far, we have been unable to do so.

The issue comes from the ORDER BY parameter not being set properly. It is set to %i.%i instead of visitor.ID.

Could you kindly try reinstalling the plugin to check if that resolves the issue?

Additionally, please make sure you are using the latest version of the plugin.

We look forward to your response.

Regards,
Matthew

Dear @kmfoysal06,

I wanted to follow up as we haven’t heard back from you regarding the issue.

Have you had the opportunity to reinstall the plugin and test the latest version to see if it resolves the problem?

Additionally, we would greatly appreciate it if you could share your site information with us. You can find this under Tools > Site Health > Info.

Thank you for your cooperation.

Regards,
Matthew

@mhdizmni

thanks for your response.the issue was resolved then by updating plugin core.it was not a great solution still it work for me. I’ll be later try switching to updated version if its work for us.

Dear @kmfoysal06,

Thank you for the update!

We’re glad to hear that the issue has been resolved. If the problem arises again in the future, please don’t hesitate to reach out. We’re always here to help and will work with you to resolve any issues.

Regards,
Matthew

Dear @kmfoysal06,

I’m pleased to inform you that we have resolved the database error in version 14.12.5, ensuring compatibility with WordPress versions earlier than 6.2.

Could you please update the plugin to the latest version and verify if everything is working as expected?

Thank you for your continued support!

Regards,
Matthew

Thank you very much @mhdizmni its helped me a lot.