Big problem [Featured Product Column Error]

[eriknv]

Hi,

I've update Cubecart from Upgrade from Alpha-2 to Beta and now I'll get this error:

MySQL Error Occured

1064: You have an error in your SQL syntax near '' at line 1

QUERY = SELECT productId, image, price, name, sale_price FROM CubeCart_inventory WHERE `showFeatured` = 1 ORDER BY productId DESC LIMIT

( See it yourself: http://www.parfumwebshop.nl/webshop/upload/ )

What can I do now? :(

[Al Brookbanks]

Did you upgrade from Alpha-RGF to Alpha 2?

Run this SQL command using a tool such as phpMyAdmin:

ALTER TABLE `CubeCart_inventory` ADD `showFeatured` INT DEFAULT '1' NOT NULL;

Remember to add the table prefix if you have one.

Thanks for this Erik, I'm sure it will trick quite a few people.

[eriknv]

Did you upgrade from Alpha-RGF to Alpha 2?

Run this SQL command using a tool such as phpMyAdmin:

ALTER TABLE `CubeCart_inventory` ADD `showFeatured` INT DEFAULT '1' NOT NULL;

Remember to add the table prefix if you have one.

Thanks for this Erik, I'm sure it will trick quite a few people.

No I had upgrade from Alpha-2 to Beta. But I try what you say for Alpha-RGF to Alpha 2. Mayby it works :(

[eriknv]

That table is already exist . What can I do now .

[Guest]

Hi Brooky,

I experienced the same SQL syntax error when upgrading from Alpha-2 to Beta. Was able to correct it by moving

$latestProducts = $db->select("SELECT productId, image, price, name, sale_price FROM ".$config['dbprefix']."CubeCart_inventory WHERE `showFeatured` = 1 ORDER BY productId DESC LIMIT ".$config['noLatestProds']);

from line 43 to line 47 in the includes/content/index.inc.php file just beneath

if($config['showLatestProds']==1 && $latestProducts==TRUE){

which was its original location in Alpha-2

[eriknv]

Verry Thanx for this it works :D