Page 1 of 1
UPDATE from: v3.0.0 RC8 to v3.0.0_RC91 - ERROR!
Posted: 13 Aug 2017, 04:06
by 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 ?
Re: UPDATE from: v3.0.0 RC8 to v3.0.0_RC91 - ERROR!
Posted: 13 Aug 2017, 10:48
by 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
Re: UPDATE from: v3.0.0 RC8 to v3.0.0_RC91 - ERROR!
Posted: 14 Aug 2017, 07:21
by clausy
Thanks...
Fixed and working fine by updating the db
Re: UPDATE from: v3.0.0 RC8 to v3.0.0_RC91 - ERROR!
Posted: 14 Aug 2017, 10:11
by Benno
Ok.
Kind regards,
Benno