Post by dom44 » Sat Aug 27, 2011 8:41 am

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.

New member

Posts

Joined
Thu Jul 16, 2009 6:54 am

Post by Qphoria » Sat Aug 27, 2011 9:23 am

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

Code: Select all

ALTER TABLE `product` ADD `upc` varchar(28) NOT NULL DEFAULT '' AFTER sku;

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by dom44 » Sat Aug 27, 2011 9:33 am

Woohoo! Thank you Qphoria, it worked :)

New member

Posts

Joined
Thu Jul 16, 2009 6:54 am
Who is online

Users browsing this forum: No registered users and 23 guests