Post by SavSiteDesign » Wed Oct 22, 2014 9:33 am

Upgraded from 1.5.6 to 2.0 am getting the following when I click on a product to view... recommendations appreciated.

Notice: Error: Unknown column 'customer_group_id' in 'where clause'
Error No: 1054
Error in: /home/www/mysite.net/catalog/model/catalog/product.php line 495
SELECT `pd`.* FROM `oc1_product_recurring` `pp` JOIN `oc1_recurring_description` `pd` ON `pd`.`language_id` = 1 AND `pd`.`recurring_id` = `pp`.`recurring_id` JOIN `oc1_recurring` `p` ON `p`.`recurring_id` = `pd`.`recurring_id` WHERE `product_id` = 1000058 AND `status` = 1 AND `customer_group_id` = 1 ORDER BY `sort_order` ASC in /home/www/mysite.net/system/library/db/mysql.php on line 53Notice: Trying to get property of non-object in /home/www/mysite.net/catalog/model/catalog/product.php on line 495

Newbie

Posts

Joined
Tue Apr 17, 2012 6:32 pm

Post by i2Paq » Wed Oct 22, 2014 3:16 pm


Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by hqbytes » Sat Jan 31, 2015 6:18 am

You need to alter your table by adding the missing column.
You can run the query below to fix the error:

ALTER TABLE oc_product_recurring
ADD customer_group_id int(11) NOT NULL

That will do it

Newbie

Posts

Joined
Sat Jan 31, 2015 6:14 am
Who is online

Users browsing this forum: No registered users and 5 guests