Daniel wrote:crazypetfood wrote:I have just uploaded the new version 1.5.1.0 to my site and used the standard setup including db.
If i recall Daniel said to export the 1.5.0.5 db and import it (sorry if i got this wrong)
I get the following errors:
Error: Unknown column 'subtract' in 'field list'
Error No: 1054
INSERT INTO `oc_order_product` (`order_product_id`, `order_id`, `product_id`, `name`, `model`, `price`, `total`, `tax`, `quantity`, `subtract`) VALUES ('21', '12', '119', 'Autarky Adult 15Kg ', 'Single', '', '', '0.0000', '2', '0')
when using the admin restore
or when using my hostign sql import
Error
SQL query:
INSERT INTO `oc_order_product` ( `order_product_id` , `order_id` , `product_id` , `name` , `model` , `price` , `total` , `tax` , `quantity` , `subtract` )
VALUES (
'21', '12', '119', 'Autarky Adult 15Kg ', 'Single', '', '', '0.0000', '2', '0'
);
MySQL said: Documentation
#1054 - Unknown column 'subtract' in 'field list'
I also get errors for manufacturer, measurement_class and other fields, i tried unticking and backing them up in admin and restoring them, still loads of sql errors..... Do you already know about this??
i have no idea how this has happened if your going from 1.5.0 > 1.5.1.
resave the settings in the admin but the subtract frield should still be there.
IT is strange, I tried a fresh install with an empty db, saved from the older version 1.5.0.x and tried to import it, the same thing happens... I will download the latest oc again and do a re-install.
The only other way is if you could post an sql script that add's the extra db bits for the latest version, I could then simply copy the newer files over my older ones if this will work?