Error: Unknown column 'customer_group_id' in 'where clause'

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

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