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
Try running this sql in phpmyadmin
Code: Select all
ALTER TABLE `product` ADD `upc` varchar(28) NOT NULL DEFAULT '' AFTER sku;
Who is online
Users browsing this forum: No registered users and 23 guests