Hi, is there really no idea how to fix the problem?
If so, what would I have to do to clean up all existing data (except the mail
messages, of course) and start over with a fresh installation in my Linux
account?
Best regards,
Andreas
Am Montag, 14. Januar 2019, 18:03:47 CET schrieb Andreas Gungl:
> Hi Dan,
>
> Thanks for offering your help. I'd already asked on kdepim-users and didn't
> get a response for weeks. That's why I wrote to this list.
>
> The output from the akonadiconsole, if the search error occurs, ist like
> this:
>
> org.kde.pim.akonadiserver: DATABASE ERROR:
> org.kde.pim.akonadiserver: Error code: "1452"
> org.kde.pim.akonadiserver: DB error: "Cannot add or update a child row: a
> foreign key constraint fails (`akonadi`.`collectiontable`, CONSTRAINT
> `collectiontable_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES
> `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)"
> org.kde.pim.akonadiserver: Error text: "Cannot add or update a child row:
> a foreign key constraint fails (`akonadi`.`collectiontable`, CONSTRAINT
> `collectiontable_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES
> `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3:
> Unable to execute statement"
> org.kde.pim.akonadiserver: Values: QMap((":0", QVariant(QString, "Letzte
> Suche"))(":1", QVariant(qlonglong, 1))(":2", QVariant(qlonglong, 1))(":3",
> QVariant(QString, "{\n \"limit\": -1,\n \"negated\": false,\n
> \"rel\": 0,\n \"subTerms\": [\n {\n \"negated\":
> false,\n \"rel\": 1,\n \"subTerms\": [\n {\n
> \"cond\": 5,\n \"key\": \"from\",\n
> \"negated\": false,\n \"value\": \"gungl\"\n
> }\n ]\n }\n ]\n}\n"))(":4", QVariant(QString,
> "RECURSIVE"))(":5", QVariant(QString, "166"))(":6", QVariant(bool, true)))
> org.kde.pim.akonadiserver: Query: "INSERT INTO CollectionTable (name,
> parentId, resourceId, queryString, queryAttributes, queryCollections,
> isVirtual) VALUES (:0, :1, :2, :3, :4, :5, :6)"
> org.kde.pim.akonadiserver: Error during insertion into table
> "CollectionTable" "Cannot add or update a child row: a foreign key
> constraint fails
> (`akonadi`.`collectiontable`, CONSTRAINT `collectiontable_ibfk_1` FOREIGN
> KEY (`parentId`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON
> UPDATE CASCADE) QMYSQL3: Unable to execute statement"
>
> It looks like a DB integrity problem KMail can't recover from by itself. But
> apart from that I've no clue about how to fix that.
>
> Best regards,
> Andreas
>
> Am Montag, 14. Januar 2019, 10:53:40 CET schrieb Daniel Vrátil:
> > Hi Andreas,
> >
> > could you please start Akonadi from terminal (open "Konsole" and run
> > "akonadictl restart"), then try to create the search in KMail again - you
> > should see some more detailed errors in the Konsole window that might help
> > us figure out what's wrong.
> >
> > Thanks,
> > Daniel
> >
> > PS: kdepim-users is a better list for this kind of questions.
> >
> > On Saturday, 12 January 2019 16:13:10 CET Andreas Gungl wrote:
> > > Hi,
> > >
> > > did a search in the web but didn't find a solution for how to solve the
> > > problem: When I search for messages, I end up with the error message:
> > > "Unable to create persistent search"
> > >
> > > I have no search folder around, maybe that's the problem. Should I need
> > > to
> > > create one manually? Any other hints like restarting akonadi etc. didn't
> > > help. How can I make the search working again?
> > >
> > > Best regards,
> > > Andreas
--
~
' v '
// \\
/( )\ Powered by Penguin.
^ ' ^