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, '*');
error
- Jan
- Phoca Hero
- Posts: 47887
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: error
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
- 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)
Jan
In this case it seems that that table __phocadownload_styles exists in the database and the installation manager tries to install them again
- 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)
Jan
If you find Phoca extensions useful, please support the project