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

Attachment: 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

Reply via email to