Advanced Stock Options

[fw115]

Hi,

after click on Advanced Stock Options i get :

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

regards

[Jan]

Hi, did you make an upgrade of database correctly

See: administrator\components\com_phocacart\install\sql\mysql\install.utf8.sql

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';

metatitle columns were added in RC9

The update of database does not work in development versions as all the versions has the same name: 3.0.0 and Joomla! install manager then cannot differentiate between the versions. So in development version, the update needs to be done manually for the database.
See:
https://www.phoca.cz/news/944-phoca-car ... 9-released
viewtopic.php?f=44&t=57836&p=146206#p146206

Jan