ThirtyBeesDatabaseException SQL syntax

[RonGin]

Can you tell me how to fix this in the stats:

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'in,SUM(IF(o.id_lang = 3, total_paid_tax_excl / o.conversion_rate, 0)) as hi,SUM(' at line 1

in file modules/statsmodule/stats/statsforecast.php at line 632

[wakabayashi]

Please enable debug mode and post the full error message.

[wakabayashi]

Btw this is an official module and I have never seen it before. Is this module up do date? When do you get this message exactly?

[RonGin]

This is in the dashboard where the visitor link are.  I have been getting since I made my move from A2 to hostgator for the last 30 days.  Yes the cart is up to date 1.1.0 version.

Edited November 17, 2020 by RonGin

[datakick]

You have Indian language enabled in your store, don't you?

The stats module contains a bug that only reproduce for this language, because its iso code is 'in'... and that is reserved sql keyword.

[RonGin]

Hello, Datakick that is the problem I removed and it is working fine. Thank you very much. Ron