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

clausy
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 13 Aug 2017, 03:56

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

Post by clausy » 13 Aug 2017, 04:06

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 ?

Tags:


User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 6257
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

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

Post by Benno » 13 Aug 2017, 10:48

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
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 13 Aug 2017, 03:56

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

Post by clausy » 14 Aug 2017, 07:21

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

User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 6257
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

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

Post by Benno » 14 Aug 2017, 10:11

Ok.

Kind regards,
Benno

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest