OpenCart Community

Hi,

I just upgraded my store from 1.5.0 to 1.5.1 and on the top of the home page it shows this error:

Notice: Undefined index: upc in /home/dom/public_html/domain.com/store/catalog/model/catalog/product.php on line 26


Further more when I edit one of the products and try to save it, its says:

Error: Unknown column 'upc' in 'field list'
Error No: 1054
UPDATE product SET model = 'MCard', sku = '', upc = '2', location = '', quantity = '0', minimum = '1', subtract = '1', stock_status_id = '8', date_available = '2011-05-16', manufacturer_id = '0', shipping = '1', price = '199', points = '0', weight = '0', weight_class_id = '1', length = '0', width = '0', height = '0', length_class_id = '1', status = '1', tax_class_id = '0', sort_order = '1', date_modified = NOW() WHERE product_id = '51'

I've tried to few suggestions from browsing the forums but, I couldn't find a solution.

FYI: Yes the line 'upc' => $query->row['upc'], is in my product.php page.

and I did apply this patch as well http://code.google.com/p/opencart/source/detail?r=495

none of them solved the problem.

Any help would be greatly appreciated.

Sounds like the upc database field doesn't exist. Something doesn't seem right with your install.
Try running this sql in phpmyadmin

Woohoo! Thank you Qphoria, it worked