Knowledgebase

Home » Item #862

Error: 'You have an error in your SQL syntax' (MySQL)

Item: #862
Date: 4 May 2004
Applies to
v5

Question

When I click to view a product, I get the following error:

You have an error in your SQL syntax near '(tblCactuShopVersions AS AlsoVersions INNER JOIN tblCactuShopProducts AS AlsoPro' at line 1

I'm running on MySQL. What's going on?

Answer

The problem is with the 'people who bought this product also bought' function. Older versions of MySQL have problems running this complex query. To get this feature working, you will need to upgrade your MySQL database to the latest version (v4+).

If you can't upgrade your MySQL database, you will need to turn off the 'people who bought...' feature. This can be done by setting the 'peoplewhobought' config setting to 0.

Can't find the answer you need? Click here to open a support ticket.

« Back