I'm guessing this shows up for each taxonomy created for mailarchive (I have two) but I'm not really sure whats going on here.
I can't execute the query manually
DELETE cache_mailarchive_overview WHERE dirty = 1 AND timestamp < 1250115488
I believe it's missing FROM, to successfully clear caching, so should be:
DELETE FROM cache_mailarchive_overview WHERE dirty = 1 AND timestamp < 1250115488
Error displayed as:
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE dirty = 1 AND timestamp < 1250115488' at line 1 query: DELETE cache_mailarchive_overview WHERE dirty = 1 AND timestamp < 1250115488 in E:\websites\drupalimporter\modules\mailarchive\mailarchive_cache\mailarchive_cache.module on line 126.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE dirty = 1 AND timestamp < 1250115488' at line 1 query: DELETE cache_mailarchive_message WHERE dirty = 1 AND timestamp < 1250115488 in E:\websites\drupalimporter\modules\mailarchive\mailarchive_cache\mailarchive_cache.module on line 127.
Comments
Comment #1
Shiny commentedfixed in CVS (branch - DRUPAL-6--1).