Citeren "Jens-U. Mozdzen" <jmozd...@nde.ag>:
Hi *,I have dug deeper into this problem, as it seems to affect several areas of operation. Looking at the list of tables, I noticed that there's "horde_imap_client_message" with nearly 36000 entries - 13 of which have a "messageid" of zero:--- cut here --- mysql> select count(*) from horde_imap_client_message where messageid=0; +----------+ | count(*) | +----------+ | 13 | +----------+ 1 row in set (0.01 sec) mysql> select count(*) from horde_imap_client_message; +----------+ | count(*) | +----------+ | 35804 | +----------+ 1 row in set (0.02 sec) mysql> --- cut here ---Might it be that not handling of new horde_imap_client_data entries is the root cause, but those 13 entries above? How would I proceed to clean up the entries (with messageid==0) in horde_imap_client_message without disturbing data integrity?
I saw this too a couple of days ago. Since these tables contain only cached information from the IMAP server, I just DROPped the tables and created new ones. After that, the error message was gone.
Best regards, Arjen
smime.p7s
Description: S/MIME Signature
-- imp mailing list Frequently Asked Questions: http://wiki.horde.org/FAQ To unsubscribe, mail: imp-unsubscr...@lists.horde.org