hi,
I installed the component/module/plugin "Alexandria Book Library" compatible for joomla 4 and 5 (beta) and everything went fine, no errors.
I wanted to import the previously exported .sql file and it returns this error:
1062 Duplicate entry '1' for key 'joshh_abauthor.PRIMARY'
I only cared about the authors.
How can I solve this problem?
Thanks
Quote from: AntonioGreco on 23 May 2024, 20:40:35hi,
I installed the component/module/plugin "Alexandria Book Library" compatible for joomla 4 and 5 (beta) and everything went fine, no errors.
I wanted to import the previously exported .sql file and it returns this error:
1062 Duplicate entry '1' for key 'joshh_abauthor.PRIMARY'
I only cared about the authors.
How can I solve this problem?
Thanks
I understood that the problem is caused by the different data structure of the old and new component database. So I should, after exporting the fie. sql and before importing it, count the "null" fields before VALUES and set the value after the VALUES value by counting the fields. Obviously it's a huge job. Is there a way to simplify this Mysql version switch? Have any of you found yourself in this situation? Thanks
Hi AntonioGreco,
You can see my answer here https://forum.voxpopulix.org/index.php?msg=3872