Bug 451291

Summary:	Insuffiecient privileges "ALTER TABLE" crashes digikam
Product:	[Applications] digikam	Reporter:	Steve Franks <stevef48>
Component:	Database-Mysql	Assignee:	Digikam Developers <digikam-bugs-null>
Status:	RESOLVED FIXED
Severity:	crash	CC:	metzpinguin
Priority:	NOR
Version:	7.6.0
Target Milestone:	---
Platform:	Microsoft Windows
OS:	Microsoft Windows
Latest Commit:		Version Fixed In:	7.7.0
Sentry Crash Report:

Description Steve Franks 2022-03-08 19:14:54 UTC

SUMMARY
***
NOTE: If you are reporting a crash, please try to attach a backtrace with debug symbols.
See https://community.kde.org/Guidelines_and_HOWTOs/Debugging/How_to_create_useful_crash_reports
***


STEPS TO REPRODUCE
1.  Unknown. Today digikam crashed whilst importing photos from a camera simultaneously checking for new items
2. 
3. 

OBSERVED RESULT
The program crashed. I restarted it and it displayed the message shown in attachment 1 [details] (Insufficient privileges "Alter Table")

EXPECTED RESULT
digikam worked as it did yesterday

SOFTWARE/OS VERSIONS
Windows:  11
macOS: 
Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 

ADDITIONAL INFORMATION
It appears that only one file can be attached, so I have uploaded the screenshot and debugview logs in a zip file to https://www.dropbox.com/sh/8my4sqiho9ztgqx/AADu813_5M0jSzP8q6muAKjCa?dl=0

Comment 1 Maik Qualmann 2022-03-08 19:29:44 UTC

MariaDB-10.6 needs special patches in the Qt-MySQL driver. Hence the crash when adding new images and scanning. Go back to MariaDB-10.5.x. Only with the availability of Qt-5.15.3 can we build a Windows version that works with current MariaDB versions again. This problem has been haunting us for months, it's a problem in Qt caused by changes in MariaDB.

Maik

Comment 2 Maik Qualmann 2022-03-08 19:35:49 UTC

See Bug 440296 story.

Maik

Comment 3 Steve Franks 2022-03-09 10:17:37 UTC

Thank you for your advice.
I installed MariaDB 10.5.x, but still see the insufficient privileges error.
What have I missed?

Comment 4 Maik Qualmann 2022-03-09 10:20:24 UTC

Create a new DebugView log.

Maik

Comment 5 Maik Qualmann 2022-03-20 07:33:03 UTC

digiKam-7.70 now works with an internal MySQL/MariaDB-10.5 database?

Maik

Comment 6 Maik Qualmann 2022-03-20 16:57:33 UTC

Thanks to the last log from bug 451723 we know that internal MySQL is working now. I close here.

Maik

Comment 7 Steve Franks 2022-03-21 10:31:56 UTC

(In reply to Maik Qualmann from comment #5)
> digiKam-7.70 now works with an internal MySQL/MariaDB-10.5 database?
> 
> Maik

Yes