Posted by jcmarco on May 22, 2009 at 4:22pm
Jump to:
| Project: | Support File Cache |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
When the logging option is active I got this error:
user warning: Table storage engine for 'sf_cache_file_statistics' doesn't have this option query: INSERT DELAYED INTO sf_cache_file_statistics (access_sec, access_msec, fid, request, type, scope) VALUES (1243005191, 264595, 33, 'admin/reports/status', 'module', 'all'), ..... --- half screen with lines like that ----- ..... in xxxxxxxx\sites\all\modules\sf_cache\sf_cache.log.inc on line 101.
I guess that without logging option it would be hard to determine the right bundle configuration.
Comments
#1
It looks like the "INSERT DELAYED" query is not allowed for the table engine. Did you change the table engine form MyISAM to InnoDB? I just read in the manual that DELAYED is not supported for InnoDB.
You can still use sf_cache without the logging functionality. Do do so, look at what files are present on a number of key pages and generate bundles manually. The automatic bundle generation is far from perfect anyway; so you might even end up with better results if you do it manually.
#2
Thank you for your quick answer.
Exactly, I have InnoDB tables, I will foillow you advise and I will try to bundle at hand.
#3
Please reopen or post a new issue if you have further questions.