Jump to content

Welcome, Guest!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

RonGin

ThirtyBeesDatabaseException SQL syntax

Recommended Posts

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Capture.JPG

Capture2.JPG

Edited by RonGin

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...