Bug 451291 - Insuffiecient privileges "ALTER TABLE" crashes digikam
Summary: Insuffiecient privileges "ALTER TABLE" crashes digikam
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Mysql (show other bugs)
Version: 7.6.0
Platform: Microsoft Windows Microsoft Windows
: NOR crash
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-03-08 19:14 UTC by Steve Franks
Modified: 2022-03-21 10:31 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In: 7.7.0
Sentry Crash Report:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
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