|
|
Dec
2
Posted by:
Sebastian Leupold
Wednesday, December 02, 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
Tags:
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
Thursday, December 03, 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
Thursday, December 03, 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
Friday, December 04, 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
Friday, December 04, 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
Sunday, December 06, 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
Tuesday, December 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
Tuesday, December 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
Friday, December 18, 2009
|
|
Follow us on Twitter @DNNCorp or join the DotNetNuke Community on LinkedIn
|