[digiKam-users] Core database: schema update to V 14 failed!

[Philippe Deyres]

Hi everybody,

I'm running Linux Ubuntu 22.04, with Digikam 7.5
Database is local.

When i run digikam, i have this message:
*Impossible d'effectuer la mise à jour du schéma de base données*








































* de la version 13 vers la version 14philippe at philippe-ub:~$
digikamdigikam.widgets: Use installed iconsdigikam.general: Switch to
widget style:  ""digikam.general: AlbumWatch is
disableddigikam.general: Database Parameters:   Type:
    "QSQLITE"   DB Core Name:
"/home/philippe/Logiciels/digikam/digikam4.db"   DB Thumbs Name:
     "/home/philippe/Logiciels/digikam/thumbnails-digikam.db"   DB
Face Name:
"/home/philippe/Logiciels/digikam/recognition.db"   DB Similarity
Name:        "/home/philippe/Logiciels/digikam/similarity.db"
Connect Options:           ""   Host Name:                 ""   Host
port:                 -1   Internal Server:           false   Internal
Server Path:      ""   Internal Server Admin Cmd: "mysqladmin"
Internal Server Serv Cmd:  ""   Internal Server Init Cmd:  ""
Username:                  ""   Password:
""digikam.dbengine: Loading SQL code from config file
"/usr/share/digikam/database/dbconfig.xml"digikam.dbengine: Checking
XML version ID => expected:  3  found:  3digikam.coredb: Core
database: running schema updatedigikam.coredb: Core database: have a
structure version  13digikam.coredb: Core database: makeUpdates  13
to  15digikam.dbengine: Failure executing query: "" Error messages:
"Impossible d'exécuter l'instruction" "duplicate column name:
modificationDate" "1" 2 Bound values:  ()digikam.dbengine: Error while
executing DBAction [ "UpdateSchemaFromV13ToV14" ] Statement [ "ALTER
TABLE Albums ADD modificationDate DATETIME;" ]digikam.coredb: Core
database: schema update to V 14 failed!digikam.coredb: Core database:
cannot process schema initializationdigikam.general: KMemoryInfo:
Platform identified :  "LINUX"digikam.general: KMemoryInfo: TotalRam:
8311914496digikam.general: Allowing a cache size of 396
MBQThreadStorage: Thread 0x7f98d1ae7860 exited after QThreadStorage 12
destroyedphilippe at philippe-ub:~$ *


*I see same problem in a post in 2020.*


*Thanks for your help.*


Philippe

e-mail : pdeyres at gmail.c <pdeyres at gmail.com>om
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20220823/78fb8494/attachment.htm>