https://bugs.kde.org/show_bug.cgi?id=337396

Robert G. Siebeck <kde.bugzilla.2...@r123.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |kde.bugzilla.2...@r123.de

--- Comment #3 from Robert G. Siebeck <kde.bugzilla.2...@r123.de> ---
Same problem here with Akonadi 1.13 and KDE 4.14.10:

DATABASE ERROR:
Error code: 1452
DB error:  "Cannot add or update a child row: a foreign key constraint fails
(`akonadi`.`collectionpimitemrelation`,
 CONSTRAINT `collectionpimitemrelation_ibfk_2` FOREIGN KEY (`PimItem_id`)
REFERENCES `pimitemtable` (`id`) ON DELETE
 CASCADE ON UPDATE CASCADE)"
Error text: "Cannot add or update a child row: a foreign key constraint fails
(`akonadi`.`collectionpimitemrelation`
, CONSTRAINT `collectionpimitemrelation_ibfk_2` FOREIGN KEY (`PimItem_id`)
REFERENCES `pimitemtable` (`id`) ON DELET
E CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement"
Query: "INSERT INTO CollectionPimItemRelation (Collection_id, PimItem_id)
VALUES (:0, :1)"
Error during adding a record to table "CollectionPimItemRelation" "Cannot add
or update a child row: a foreign key c
onstraint fails (`akonadi`.`collectionpimitemrelation`, CONSTRAINT
`collectionpimitemrelation_ibfk_2` FOREIGN KEY (`
PimItem_id`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE
CASCADE) QMYSQL3: Unable to execute statem
ent" 
DATABASE ERROR:
Error code: 1452
DB error:  "Cannot add or update a child row: a foreign key constraint fails
(`akonadi`.`collectionpimitemrelation`,
 CONSTRAINT `collectionpimitemrelation_ibfk_2` FOREIGN KEY (`PimItem_id`)
REFERENCES `pimitemtable` (`id`) ON DELETE
 CASCADE ON UPDATE CASCADE)"
Error text: "Cannot add or update a child row: a foreign key constraint fails
(`akonadi`.`collectionpimitemrelation`
, CONSTRAINT `collectionpimitemrelation_ibfk_2` FOREIGN KEY (`PimItem_id`)
REFERENCES `pimitemtable` (`id`) ON DELET
E CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement"
Query: "INSERT INTO CollectionPimItemRelation (Collection_id, PimItem_id)
VALUES (:0, :1)"
Error during adding a record to table "CollectionPimItemRelation" "Cannot add
or update a child row: a foreign key c
onstraint fails (`akonadi`.`collectionpimitemrelation`, CONSTRAINT
`collectionpimitemrelation_ibfk_2` FOREIGN KEY (`
PimItem_id`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE
CASCADE) QMYSQL3: Unable to execute statem
ent" 


Are there any ways to get these errors resolved without deleting the whole
databases? Or workarounds?

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

Reply via email to