error

Phoca Download - download manager
skate2k5
Phoca Member
Phoca Member
Posts: 31
Joined: 07 Jan 2011, 12:03

error

Post by skate2k5 » 28 May 2018, 13:06

After a new installation I restored the db of the phocadownloader but it returns me this error.
How can I do?

Attenzione
JInstaller: :Install: Errore SQL Duplicate entry '1' for key 'PRIMARY'
Estensione Installazione: richiesta di elaborazione degli errori di SQL: DB function fallita con errore numero 1062
Duplicate entry '1' for key 'PRIMARY'
SQL =
INSERT INTO `#__phocadownload_styles` (`id`, `title`, `alias`, `filename`, `menulink`, `type`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `language`) VALUES
(1, 'Phocadownload', 'phocadownload', 'phocadownload.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
(2, 'Rating', 'rating', 'rating.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 2, NULL, '*'),
(3, 'Button', 'button', 'button.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 3, NULL, '*'),
(4, 'Button (Rounded Corners)', '', 'buttonrc.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 4, NULL, '*'),
(5, 'Default', 'default', 'default.css', NULL, 2, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
(6, 'Bootstrap', '', 'bootstrap.min.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 5, NULL, '*');

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

Re: error

Post by Jan » 30 May 2018, 12:59

Hi, maybe this should be a question on Joomla! extension install which installs the extensions in Joomla!

In this case it seems that that table __phocadownload_styles exists in the database and the installation manager tries to install them again :idea:

- so if it is possible, the component should be removed completely:
https://www.phoca.cz/documents/16-jooml ... m-manually
and newly installed. BUT BY THIS METHOD ALL DATA WILL BE LOST

- so if there are some data included in database, the query needs to be done manually (e.g. instert phocadownload styles table will be not done whe the data exists in database yet) :idea:

Jan
If you find Phoca extensions useful, please support the project

skate2k5
Phoca Member
Phoca Member
Posts: 31
Joined: 07 Jan 2011, 12:03

Re: error

Post by skate2k5 » 30 May 2018, 13:07

In fact I just deleted the old folders from the database and installed phocadownload again.
I lost all the data on the statistics, okay patience.

Post Reply