[digiKam-users] Error updating from 7.1 to 7.2.0

[Maik Qualmann]

You use digiKam's internal MySQL server. In digiKam-7.1.0, when exiting 
digiKam, the internal server was not shut down correctly under Windows. This 
could damage the database. This is the case with you, therefore the schema 
update to a new structure does not work:

-----------------------------------------
> Error messages: "QMYSQL: Unable to
> execute query" "Table 'tags' is marked as crashed and should be repaired"
> "1194" 2

> digikam.dbengine: Error while
> executing DBAction [ "UpdateSchemaFromV10ToV11" ] Statement [ "DROP TRIGGER
> IF EXISTS insert_tagstree;" ]
-----------------------------------------

The best way is to start with a new database. To do this, you have to delete 
the "C:\Users\trpar\OneDrive\Documents\TRP\DIgikam Working
Archive\.mysql.digikam" folder.

Rescuing the database is more difficult. With digiKam-7.1.0 you would have to 
copy the database with the migration tool into an SQLite database and then 
back again later. 

Maik

Am Dienstag, 30. März 2021, 23:56:51 CEST schrieb trparks1 at gmail.com:
> Thanks, Here's what I got.
> Tom

> 00000065	20.11470795	[22148] Error messages: "QMYSQL: Unable to
> execute query" "Table 'tags' is marked as crashed and should be repaired"
> "1194" 2
> 00000066	20.11470795	[22148] Bound values:  ()
> 00000067	20.11476326	[22148] digikam.dbengine: Error while
> executing DBAction [ "UpdateSchemaFromV10ToV11" ] Statement [ "DROP TRIGGER
> IF EXISTS insert_tagstree;" ]

> -----Original Message-----
> From: Digikam-users <digikam-users-bounces at kde.org> On Behalf Of Maik
> Qualmann
> Sent: Tuesday, March 30, 2021 2:07 PM
> To: digiKam - Home Manage your photographs as a professional with the power
> of open source <digikam-users at kde.org>
> Subject: Re: [digiKam-users] Error updating from 7.1 to 7.2.0
> 
> Post the DebugView log when starting digiKam-7.2.0 as described here for
> Windows:
> 
> https://www.digikam.org/contribute/
> 
> Don't forget to set the environment variable.
> 
> Maik
> 
> Am Dienstag, 30. März 2021, 22:59:26 CEST schrieb mippo:
> > I get the same error (Failed to upload the database schema ...), with
> > the new 7.2.0 digiKam 7.1.0 still works fine
> > 
> > 
> > 
> > 
> > 
> > -----
> > x
> > --
> > Sent from:
> > http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html