Page 1 of 1

Error Updating/re-installing Phoca Cart

Posted: 17 Dec 2020, 18:21
by Lv@tasco.be
Had a few errors while playing around (styling) the Phoca - cart plugin
Which game me enough reason to restart from scratch after learning some new things about css/html

Now I seem to have run into some issues uninstalling and re-installing the Com_phocacart_v3.5.4

I have roamed this forum and realized this might be an error because of versions updates.

I am perfectly ok with completely starting from scratch but now I can not even download the module.

Every tip is appreciated

https://imgur.com/a/kvr8Lk9

Warning
JInstaller: :Install: Error SQL Unknown column 'orders_view_display' in 'field list'
Extension Install: SQL error processing query: DB function failed with error number 1054
Unknown column 'orders_view_display' in 'field list'
SQL =
INSERT INTO `#__phocacart_order_statuses` (`id`, `title`, `published`, `ordering`, `stock_movements`, `type`, `download`, `change_user_group`, `change_points_needed`, `change_points_received`, `orders_view_display`) VALUES
(1, 'COM_PHOCACART_STATUS_PENDING', '1', '1', '-', '1', '0', '0', '1', '0', '[1]'),
(2, 'COM_PHOCACART_STATUS_CONFIRMED', '1', '2', '=', '1', '0', '1', '1', '1', '[1,3]'),
(3, 'COM_PHOCACART_STATUS_CANCELED', '1', '3', '+', '1', '0', '1', '2', '2', '[1]'),
(4, 'COM_PHOCACART_STATUS_SHIPPED', '1', '4', '=', '1', '0', '1', '1', '1', '[1,2,3]'),
(5, 'COM_PHOCACART_STATUS_REFUNDED', '1', '5', '=', '1', '0', '1', '2', '2', '[1]'),
(6, 'COM_PHOCACART_STATUS_COMPLETED', '1', '6', '=', '1', '1', '1', '1', '1', '[1,2,3]');
Package Install: There was an error installing an extension: com_phocacart_v3.5.4.zip

Re: Error Updating/re-installing Phoca Cart

Posted: 19 Dec 2020, 16:57
by Jan
Hi, unfortunately, Phoca Cart does not install itself but it is installed by Joomla! extension manager. So sometimes problems like this occur.

See: https://www.phoca.cz/blog/1100-solution ... components

In this case, the column should be normally added when installing, see:

Image
(it is a part of installation sql file)

So it could happen, that some obsolete database columns were in database.

In case, you want to install a component in Joomla! from scratch, you can see this guide:
https://www.phoca.cz/documents/16-jooml ... m-manually

This method will completely remove all data which can be in conflict when resinstalling. But of course, be aware, this method removes all components's data from the system.

Jan