Closed (fixed)
Project:
Support File Cache
Version:
6.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
22 May 2009 at 16:22 UTC
Updated:
18 Sep 2009 at 09:29 UTC
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
Comment #1
kkaefer commentedIt 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.
Comment #2
jcmarco commentedThank you for your quick answer.
Exactly, I have InnoDB tables, I will foillow you advise and I will try to bundle at hand.
Comment #3
kkaefer commentedPlease reopen or post a new issue if you have further questions.