Phoca Forum

I have update Phoca cart today from RC9 to Stable and now I get an error code: 1054 - Unknown column 'm.link' in 'field list' when I want to select a product on the website. How can I solve this?

Hi,

see here please: https://www.phoca.cz/news/956-phoca-car ... e-released

If you upgrade from development version RC9 to Stable, then database data needs to be updated. See:

administrator/components/com_phocacart/install/sql/mysql/install.utf8.sql (RC9 -> Stable part): viewtopic.php?f=44&t=57836&p=146206#p146206

There are SQL instructions for upgrading database of the component.

Kind regards, Christine

I did that. Copied everything below RC9->Stable in phpmyadmin, but the reply form SQL is that there is no referal to a database.

Hi, what you exactly mean with "there is no referal to a database"?

Jan

I copied this into phpmyadmin in the SQL tab:
ALTER TABLE `o07i2_phocacart_manufacturers` ADD `link` varchar(255) NOT NULL DEFAULT '';
ALTER TABLE `o07i2_phocacart_coupons` ADD `category_filter` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `o07i2_phocacart_coupons` ADD `product_filter` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `o07i2_phocacart_discounts` ADD `category_filter` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `o07i2_phocacart_discounts` ADD `product_filter` tinyint(1) NOT NULL DEFAULT '1';
into phpmyadmin
The response from my SQL: #1046 - no database selected.

Sorry. I see my mistake. I have selected the Joomla database and now it does work. Thanks for your responses. Sorry for the inconvenience.

Hi,
thank you for your information.

Kind regards, Christine