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

Shiny’s picture

Assigned: Unassigned » Shiny
Status: Active » Fixed

fixed in CVS (branch - DRUPAL-6--1).

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.