inport/export script fail from 13.x to 14

[supportFGT]

I've 2 different standalone server debian 11
server 1 was updated before export to latest version (02/jan/2025)
Version: 13.2.0+20241204194243+1574190327+0011+maintenance132+bullseye1

server 2 was
Version: 13.2.0+20240516161922+1294249809+0011+maintenance132+bullseye1

I've installed a new server debian (bookworm) for the migration process:
Version: 14.0.0+20241212210324+1586725144+0012+maintenance140+bookworm1

The database import failed on each server

> Dump file was made without triggers and procedures
> Importing bare schema for 13.2
> ---------------------------------------------------------------------------------
> Replacing create statements from the dump and removing drop statements
> ---------------------------------------------------------------------------------
> Importing packetfence-db-dump-2025-01-03_00h30.sql into pf
> ERROR 1062 (23000) at line 1239: Duplicate entry '1' for key 'PRIMARY'

[JeGoi]

Looks like this #8105

[JeGoi]

The database import failed on each server

Do you mean, you tried to import from each 13.2 servers on your new server 14.0, correct?

[JeGoi]

server 2 was
Version: 13.2.0+20240516161922+1294249809+0011+maintenance132+bullseye1

This one should have the error.

server 1 was updated before export to latest version (02/jan/2025)
Version: 13.2.0+20241204194243+1574190327+0011+maintenance132+bullseye1

This one should not have the error.

[supportFGT]

The database import failed on each server

Do you mean, you tried to import from each 13.2 servers on your new server 14.0, correct?

Yes. I've prepared 2 new deb12,PF14 servers to replace my existing ones

[JeGoi]

And is it exactly like that? #8464 (comment)
Can you check if the "addons/backup-and-maintenance.sh" contains "--insert-ignore" (from 60fd326#diff-26009787ff2aac5d7bd47e89965a5e307e89af5c13060c519fbc8b29a76984d7R154) ? Thanks

[supportFGT]

And is it exactly like that? #8464 (comment) Can you check if the "addons/backup-and-maintenance.sh" contains "--insert-ignore" (from 60fd326#diff-26009787ff2aac5d7bd47e89965a5e307e89af5c13060c519fbc8b29a76984d7R154) ? Thanks

latest version 13.2 contains "--insert-ignore" .

Version 13.2 (not updated ) and 14 does not contains

[supportFGT]

finally I was able to import config and update my servers:
Both failed on "ERROR 1062 (23000) at line 1239: Duplicate entry '1' for key 'PRIMARY"

So I've extracted the sql ; check the line affected, and because I don't have any setting configured for the affected table, I commented the line 1239:

--INSERT INTO pki_scep_servers VALUES ...

...