https://bugs.kde.org/show_bug.cgi?id=440919
Bug ID: 440919
Summary: SQlite - Mysql internal name-tag migrating error
Product: digikam
Version: 7.4.0
Platform: Microsoft Windows
OS: Microsoft Windows
Status: REPORTED
Severity: normal
Priority: NOR
Component: Database-Migration
Assignee: digikam-bugs-n...@kde.org
Reporter: hann...@hot.ee
Target Milestone: ---
SUMMARY
SQlite - Mysql internal tag migrating error
STEPS TO REPRODUCE
1. An error message always appears in the same place
2.4932] digikam.coredb: Core database: query isOnValidRow [ true ] isActive [
true ] result size: [ -1 ]
[14932] digikam.coredb: Core database: column: [ "id" ] value [
QVariant(qlonglong, 1772) ]
[14932] digikam.coredb: Core database: column: [ "pid" ] value [
QVariant(qlonglong, 1733) ]
[14932] digikam.coredb: Core database: column: [ "name" ] value [
QVariant(QString, "Aare Miller") ]
[14932] digikam.coredb: Core database: column: [ "icon" ] value [
QVariant(qlonglong, 182090) ]
[14932] digikam.coredb: Core database: column: [ "iconkde" ] value [
QVariant(QString, "") ]
[14932] digikam.coredb: Core database: query isOnValidRow [ true ] isActive [
true ] result size: [ -1 ]
[14932] digikam.coredb: Core database: column: [ "id" ] value [
QVariant(qlonglong, 1773) ]
[14932] digikam.coredb: Core database: column: [ "pid" ] value [
QVariant(qlonglong, 1733) ]
[14932] digikam.coredb: Core database: column: [ "name" ] value [
QVariant(QString, "Kaja Kartau (Lainde)") ]
[14932] digikam.coredb: Core database: column: [ "icon" ] value [
QVariant(qlonglong, 308120) ]
[14932] digikam.coredb: Core database: column: [ "iconkde" ] value [
QVariant(QString, "") ]
[14932] digikam.dbengine: Failure executing query:
[14932] "\n REPLACE INTO Tags (id, pid, name, icon,
iconkde) VALUES (?, ?, ?, ?, ?);\n "
[14932] Error messages: "QMYSQL3: Unable to execute statement" "Cannot add or
update a child row: a foreign key constraint fails (`digikam`.`tags`,
CONSTRAINT `Tags_Images` FOREIGN KEY (`icon`) REFERENCES `images` (`id`) ON
DELETE SET NULL ON UPDATE CASCADE)" "1452" 2
[14932] Bound values: (QVariant(qlonglong, 1773), QVariant(qlonglong, 1733),
QVariant(QString, "Kaja Kartau (Lainde)"), QVariant(qlonglong, 308120),
QVariant(QString, ""))
[14932] digikam.dbengine: Error while executing DBAction [ "Migrate_Write_Tags"
] Statement [ "\n REPLACE INTO Tags (id, pid, name, icon,
iconkde) VALUES (:id, :pid, :name, :icon, :iconkde);\n " ]
[14932] digikam.coredb: Core database: error while converting table data.
Details: QSqlError("1452", "QMYSQL3: Unable to execute statement", "Cannot add
or update a child row: a foreign key constraint fails (`digikam`.`tags`,
CONSTRAINT `Tags_Images` FOREIGN KEY (`icon`) REFERENCES `images` (`id`) ON
DELETE SET NULL ON UPDATE CASCADE)")
[14932] digikam.databaseserver: Running 930 seconds...
3. What could be the reason for the failure?
OBSERVED RESULT
EXPECTED RESULT
SOFTWARE/OS VERSIONS
Windows:
macOS:
Linux/KDE Plasma:
(available in About System)
KDE Plasma Version:
KDE Frameworks Version:
Qt Version:
ADDITIONAL INFORMATION
--
You are receiving this mail because:
You are watching all bug changes.
