1062 Duplicate entry '1' for key 'joshh_abauthor.PRIMARY'

[AntonioGreco]

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

[AntonioGreco]

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

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

[federica]

Hi AntonioGreco,
You can see my answer here https://forum.voxpopulix.org/index.php?msg=3872