Archive
Monthly
Go
|
|
DNN Blog
Dec
1
Posted by:
Sebastian Leupold
12/1/2009
A caching issue in DNN 5.2.0 leads into special characters like German umlauts, accents etc. being replaced by "?".
Users, who are familiar with Visual Studio may download latest source code from dotnetnuke.codeplex.com and compile for themselves, all others may work around by setting cache duration to 0 in module settings - if they can afford the associated performance decrease.
To speed up this process, I created a SQL Script as a temporary workaround to adjust caching and back.
To enable/disable caching for all module, go to SQL in Host Settings, paste the script into the textbox, check "run as Script" and hit "execute".
To disable caching, use:
INSERT INTO {databaseOwner}{objectQualifier}TabModuleSettings
(TabModuleID,SettingName,SettingValue,CreatedByUserID,CreatedOnDate,LastModifiedByUserID,LastModifiedOnDate)
SELECT TabModuleID, N'SavedCacheTime', CacheTime, 2, GETDATE(), 2, GETDATE()
FROM {databaseOwner}{objectQualifier}TabModules T
WHERE CacheTime > 0
UPDATE {databaseOwner}{objectQualifier}TabModules
SET CacheTime = 0 WHERE CacheTime <> 0
to re-enable caching, execute
UPDATE M
SET M.CacheTime = S.SettingValue
FROM {databaseOwner}{objectQualifier}TabModules M
INNER JOIN {databaseOwner}{objectQualifier}TabModuleSettings S on M.TabModuleID = S.TabModuleID
WHERE S.SettingName = N'SavedCacheTime'
DELETE FROM {databaseOwner}{objectQualifier}TabModuleSettings
WHERE SettingName = N'SavedCacheTime'
HTH
8 comment(s) so far...
Re: A quick workaround for a caching issue in DNN 5.2.0
Hi Sebastian,
As far as I can tell, it seems another important issue with the caching provider, which disables the cache when cached dependencies are used.
It is logged in gemini and explained in the following post: www.dotnetnuke.com/Community/Forums/tabid/795/forumid/160/threadid/334397/scope/posts/Default.aspx
Can you have a look?
By Jean-Sylvain Boige on
12/3/2009
|
Re: A quick workaround for a caching issue in DNN 5.2.0
Jean-Sylvain,
Thanks for heading me up on it, I will have a look and try to get it fixed.
By Sebastian Leupold on
12/3/2009
|
Re: A quick workaround for a caching issue in DNN 5.2.0
Hello, when it is possible to except new fixed release?
By ilisium on
12/4/2009
|
Re: A quick workaround for a caching issue in DNN 5.2.0
I'd expect DotNetNuke 5.2.1 to be release within the next weeks, you may review the roadmap here
By Sebastian Leupold on
12/4/2009
|
Re: A quick workaround for a caching issue in DNN 5.2.0
Hi Sebastian...
Your script works great, thanks !! :)
/Kenneth
By Kenneth Madsen on
12/6/2009
|
Re: A quick workaround for a caching issue in DNN 5.2.0
Hi Sebastian, any chance you could provide a link to where the source code is on codeplex that you mention above?
Many thanks
KG
By John Wallwork on
12/15/2009
|
Re: A quick workaround for a caching issue in DNN 5.2.0
John, please find DNN source code here.
By Sebastian Leupold on
12/15/2009
|
Re: A quick workaround for a caching issue in DNN 5.2.0
Hi Sebastian,
I have an issue with profileproperties that are cached. After adding a profile property to a portal and clicking apply changes they do not show up. I've cycled the app pool, edited the web config, restared iis and deleted all resource files that I could find related to caching but to no avail. Any chance you can point me in a direction to get the profile property cache to refresh / invalidate?
Thank You,
Terryb
By Terryb on
12/18/2009
|
|