Page 1 of 1

error

Posted: 28 May 2018, 13:06
by skate2k5
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, '*');

Re: error

Posted: 30 May 2018, 12:59
by Jan
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

Re: error

Posted: 30 May 2018, 13:07
by skate2k5
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.