[digiKam-users] Error updating from 7.1 to 7.2.0

[trparks1 at gmail.com]

Maik or anybody,
I continue to have database problems with MySQL server under windows 10
after migrating from 7.1 to 7.2.0.  I had followed your instructions below
and it worked (apparently, the program re-installed MYSQL after deleting it)
for maybe a half dozen sessions with no noticeable problems.  Then it
started freezing again on startup with the DebugView log showing database
server errors.  I am a new user and have just started to build my database
and so it wouldn't be a huge loss to replace it with SQLite if that would be
more robust (from what I've read I suspect it would be).  I had initialized
the program with MYSQL as the documentation indicated it may be better
suited for large archives, but I think mine will eventually top out at
something like 100-150 images and suspect that won't overburden SQLite.  I
am no power user and don't want to have ongoing issues with a finicky
system.

If you don't see any problems with this could you please point me to
instructions on how I switch to Lite?

Thanks,
Tom

-----Original Message-----
From: Digikam-users <digikam-users-bounces at kde.org> On Behalf Of Maik
Qualmann
Sent: Tuesday, March 30, 2021 10:40 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

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