UPDATE from: v3.0.0 RC8 to v3.0.0_RC91 - ERROR!

[clausy]

Getting an error:

1054 - Unknown column 'i.metatitle' in 'field list'

while updating my phoca cart v3.0.0 RC8 to v3.0.0_RC91

Joomla v3.7.4

any suggestion / help to fix this issue, or keeping the old verion v3.0.0 RC8 ?

[Benno]

Hi,
did you also update your data base?

Code: Select all

-- ---------
-- RC8 -> RC9
-- ---------

-- ALTER TABLE  `#__phocacart_currencies` 		CHANGE `exchange_rate` `exchange_rate` DECIMAL( 15, 8 ) NOT NULL DEFAULT '0';
-- ALTER TABLE  `#__phocacart_orders` 			CHANGE `currency_exchange_rate` `currency_exchange_rate` DECIMAL( 15, 8 ) NOT NULL DEFAULT '0';

-- ALTER TABLE  `#__phocacart_order_total` 		ADD `amount_currency` DECIMAL( 15, 4 ) NOT NULL DEFAULT  '0';
-- ALTER TABLE  `#__phocacart_order_products` 	ADD `default_tax_id` int(11) NOT NULL DEFAULT '0';

-- ALTER TABLE  `#__phocacart_categories` 		ADD `metatitle` varchar(255) NOT NULL DEFAULT '';
-- ALTER TABLE  `#__phocacart_products` 		ADD `metatitle` varchar(255) NOT NULL DEFAULT '';

-- ALTER TABLE  `#__phocacart_order_total` 		ADD `item_id` int(11) NOT NULL DEFAULT '0';


-- ---------
-- RC9 -> RC9.1
-- ---------
-- ALTER TABLE  `#__phocacart_product_stock` 		ADD `image` varchar(255) NOT NULL DEFAULT '';
-- ALTER TABLE  `#__phocacart_product_stock` 		ADD `image_small` varchar(255) NOT NULL DEFAULT '';
-- ALTER TABLE  `#__phocacart_product_stock` 		ADD `image_medium` varchar(255) NOT NULL DEFAULT '';

-- ALTER TABLE  `#__phocacart_products` 		CHANGE `isbn` `isbn` varchar(20) NOT NULL DEFAULT '';

See: viewtopic.php?f=44&t=57836&p=146206#p146206

Kind regards,
Benno

[clausy]

Thanks...
Fixed and working fine by updating the db

[Benno]

Ok.

Kind regards,
Benno