> --- > Repairing DBMAIL physmessage integrity... > Ok. Found [51747] unconnected physmessagesWarning: could not delete > orphaned > physmessages. Check log. > > --- > Jan 21 09:59:54 lira dbmail/maintenance[32496]: [0x8d69958] Error:[db] > db_exec(+318): SQLException: You can't specify target table > 'dbmail_physmessage' for update in FROM clause > Jan 21 09:59:54 lira dbmail/maintenance[32496]: [0x8d69958] Error:[db] > db_exec(+319): failed query [DELETE FROM dbmail_physmessage WHERE id IN > (SELECT id FROM dbmail_physmessage p LEFT JOIN dbmail_messages > --- >
Apart from this, I had a manual query to delete data while the dbmail-util wasn't fixed, but somehow I just started not to delete data. What's wrong? I've looked several times to the query and all seems OK. -- DELETE dbmail_mimeparts.* FROM dbmail_mimeparts LEFT JOIN dbmail_partlists ON (dbmail_mimeparts.id=dbmail_partlists.part_id) WHERE dbmail_partlists.physmessage_id IS NULL; --- _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
