User warning in mailarchive_cache module after cron executes
aaronsb - August 13, 2009 - 22:29
| Project: | Mailing List Archive |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
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 < 1250115488I believe it's missing FROM, to successfully clear caching, so should be:
DELETE FROM cache_mailarchive_overview WHERE dirty = 1 AND timestamp < 1250115488Error 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.