Phoca Forum

Hi;

Is there, anyone who can show me how to resolve the error every time i try to install com_phocacart_v3.0.4 in joomla 3.8.4. this is the following error that I encounter:

Warning
JInstaller: :Install: Error SQL Duplicate entry '1' for key 'PRIMARY'
Extension Install: SQL error processing query: DB function failed with error number 1062
Duplicate entry '1' for key 'PRIMARY'
SQL =

INSERT INTO `#__phocacart_order_statuses` (`id`, `title`, `published`, `ordering`, `stock_movements`, `type`, `download`, `change_user_group`, `change_points_needed`, `change_points_received`) VALUES
(1, 'COM_PHOCACART_STATUS_PENDING', '1', '1', '-', '1', '0', '0', '1', '0'),
(2, 'COM_PHOCACART_STATUS_CONFIRMED', '1', '2', '=', '1', '0', '1', '1', '1'),
(3, 'COM_PHOCACART_STATUS_CANCELED', '1', '3', '+', '1', '0', '1', '2', '2'),
(4, 'COM_PHOCACART_STATUS_SHIPPED', '1', '4', '=', '1', '0', '1', '1', '1'),
(5, 'COM_PHOCACART_STATUS_REFUNDED', '1', '5', '=', '1', '0', '1', '2', '2'),
(6, 'COM_PHOCACART_STATUS_COMPLETED', '1', '6', '=', '1', '1', '1', '1', '1');

Package Install: There was an error installing an extension: com_phocacart_v3.0.2.zip

It will be highly appreciated if there some one can resolved this matter

Thank you

Hi,

Phoca Cart version is: 3.0.3

at first try: Admin > Extensions > Manage > Database, click to button "Fix" to correct DB problems.
In addition: Make sure that your template and extensions that you're using for your website support Joomla! 3.8.5

Kind regards
Christine

Hello christine;

Thank you for your quick reply. I tried your suggestion by going to manage database and click fix but when i tried to install the com_phocacart_v3.0.2 still same warning pop-up. is there any other way to do this?

Thanks

Hi, then try to empty the table: `#__phocacart_order_statuses` in your database. Normally, this sql query should not run through standard Joomla! extension update

Jan