Error Updating/re-installing Phoca Cart

Phoca Cart - complex e-commerce extension
Lv@tasco.be
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 16 Dec 2020, 09:45

Error Updating/re-installing Phoca Cart

Post by Lv@tasco.be » 17 Dec 2020, 18:21

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

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 43634
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Error Updating/re-installing Phoca Cart

Post by Jan » 19 Dec 2020, 16:57

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
If you find Phoca extensions useful, please support the project

Post Reply