Problem with the pkg datebase

[Willem Jan Withagen (EcoRacks)]

Hi,

Trying to run a 'pkg upgrade -f' which gives me:

pkg: sqlite error while executing UPDATE packages SET name=?1  WHERE
name=?2; in file pkg_jobs.c:1576: UNIQUE constraint failed: packages.name

And upgrading is not really possibe.

How do I fix the database?

--WjW