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.