https://bugs.kde.org/show_bug.cgi?id=334014
--- Comment #2 from jajaX <jaja...@gmail.com> --- Hi (sorry for my bad english) big thanks for your help and answer ;) step 6 don't work => mysql> SELECT TABLE_NAME,ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA='akonadi'; +----------------------------------+--------+ | TABLE_NAME | ENGINE | +----------------------------------+--------+ | collectionattributetable | InnoDB | | collectionmimetyperelation | InnoDB | | collectionpimitemrelation | InnoDB | | collectiontable | InnoDB | | flagtable | InnoDB | | mimetypetable | InnoDB | | parttable | InnoDB | | parttypetable | InnoDB | | pimitemflagrelation | InnoDB | | pimitemtable | InnoDB | | pimitemtagrelation | InnoDB | | resourcetable | InnoDB | | schemaversiontable | InnoDB | | tagattributetable | InnoDB | | tagremoteidresourcerelationtable | InnoDB | | tagtable | InnoDB | +----------------------------------+--------+ 16 rows in set (0.00 sec) mysql> USE akonadi; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> DELETE FROM CollectionTable WHERE parentId NOT IN (SELECT id FROM CollectionTable) AND parentId IS NOT NULL; ERROR 1093 (HY000): You can't specify target table 'CollectionTable' for update in FROM clause one idea ? -- 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