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
Error Updating/re-installing Phoca Cart
-
- Phoca Newbie
- Posts: 2
- Joined: 16 Dec 2020, 09:45
- Jan
- Phoca Hero
- Posts: 48402
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Error Updating/re-installing Phoca Cart
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:
(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
See: https://www.phoca.cz/blog/1100-solution ... components
In this case, the column should be normally added when installing, see:
(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
If you find Phoca extensions useful, please support the project