https://bugs.kde.org/show_bug.cgi?id=435179
Bug ID: 435179
Summary: face write to database with wrong user (''@'%')
MariaDB backend
Product: digikam
Version: 7.2.0
Platform: Compiled Sources
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: Database-Faces
Assignee: digikam-bugs-n...@kde.org
Reporter: ges...@blackrosetech.com
Target Milestone: ---
SUMMARY
when writing a new face ID either from the image preview face tag interface or
from the tags manager interface, the operation fails.
STEPS TO REPRODUCE
In tag manager select "People" -> green plus sign -> in "Create New Tag in
"/Poeple" enter "Name of Person" as tag (without quotes, no slashes) click "OK"
and get:
Tag creation Error --digiKam
An error occurred during tag creation:
Tag Path Error
/people/Person Name Failed to add tag to database
It fails silently in the image preview (detect face->label face with "Persons
Name" -> click green "Confirm" -> nothing happens.
Console debug during image preview creation process:
QPixmap::scaled: Pixmap is a null pixmap
digikam.database: Creating new tag for name "Persons Name" fullName "Persons
Name"
digikam.dbengine: Failure executing query:
"INSERT INTO Tags (pid, name) VALUES( ?, ?);"
Error messages: "QMYSQL3: Unable to execute statement" "The user specified as a
definer (''@'%') does not exist" "1449" 2
Bound values: (QVariant(int, 4), QVariant(QString, "Persons Name"))
digikam.dbengine: Error while executing DBAction [ "InsertTag" ] Statement [
"INSERT INTO Tags (pid, name) VALUES( :tagPID, :tagname);" ]
digikam.database: Attempt to create tag properties for tag id 0
digikam.general: Failed to get person tag
QPixmap::scaled: Pixmap is a null pixmap
Console debug during tag manager insert attempt:
digikam.general: ("Persons Name")
digikam.general: "Persons Name" :: "/People/Persons Name"
digikam.dbengine: Failure executing query:
"INSERT INTO Tags (pid, name) VALUES( ?, ?);"
Error messages: "QMYSQL3: Unable to execute statement" "The user specified as a
definer (''@'%') does not exist" "1449" 2
Bound values: (QVariant(int, 4), QVariant(QString, "Persons Name"))
digikam.dbengine: Error while executing DBAction [ "InsertTag" ] Statement [
"INSERT INTO Tags (pid, name) VALUES( :tagPID, :tagname);" ]
This database connection attempt is with a null user: '', it should be with the
user configured in database settings. Operations such as modifying a tag are
successful, it is just create that's being attempted with a null user.
core/libs/database/coredb/coredb.cpp?
EXPECTED RESULT
I'd expect the tag to be written to the database, it is not. In either case t
SOFTWARE/OS VERSIONS
Linux/KDE Plasma: 20.04.2 LTS (Focal Fossa) 5.8.0-48-generic
(available in About System)
KDE Plasma Version: plasmashell 5.18.5
KDE Frameworks Version: 5.68.0
Qt Version: 5.12.8
mariadb Ver 15.1 Distrib 10.3.25-MariaDB, for debian-linux-gnu (x86_64) using
readline 5.2
ADDITIONAL INFORMATION
digikam version 7.2.0
CPU cores: 8
Eigen: 3.3.7
Exiv2: 0.27.3
Exiv2 supports Base Media: No
Exiv2 supports XMP metadata: Yes
HEIF encoding support: Yes
ImageMagick codecs: 6.9.10
KF5: 5.68.0
LensFun: 0.3.2-0
LibCImg: 130
LibJPEG: 80
LibJasper: 2.0.27
LibLCMS: 2090
LibLqr support: Yes
LibPGF: 7.19.03
LibPNG: 1.6.37
LibRaw: 0.21.0
LibTIFF: 4.1.0
Marble: 0.27.20
Parallelized demosaicing: Yes
Qt: 5.12.8
Qt WebEngine support: Yes
Rajce support: Yes
VKontakte support: No
AkonadiContact support: No
Baloo support: Yes
Calendar support: Yes
DBus support: Yes
Database backend: QMYSQL
Database internal server: No
HTML Gallery support: Yes
LibAVCodec: 58.91.100
LibAVFormat: 58.45.100
LibAVUtil: 56.51.100
LibGphoto2: 2.5.25
LibOpenCV: 4.2.0
LibQtAV: 1.13.0
Media player support: Yes
Panorama support: Yes
--
You are receiving this mail because:
You are watching all bug changes.
