Quick Nav:  Online Store   |   Login | Register

Re: Upgrade Error

Rate this topic:

Please Register to post a reply. Another benefit of registration is the ability to subscribe to and recieve notifications of new posts.
AuthorMessages
John Mitchell
<500Posts
Posts:355


10/28/2003 8:45 PM  
Hi Nate,
Please check to see if you have any records in the ModuleSettings table with SkinFolder for the SettingName.

When you say you ran the SQL, you are talking about this one right?

=========================================================

DECLARE @ModuleID int

DECLARE settings_cursor CURSOR FOR

SELECT ModuleID FROM ModuleSettings

WHERE SettingName = 'container'

OPEN settings_cursor

FETCH NEXT FROM settings_cursor INTO @ModuleID WHILE @@FETCH_STATUS = 0 BEGIN

if not exists (select ModuleID from ModuleSettings Where ModuleId = @ModuleID and SettingName = 'SkinFolder')

BEGIN

Insert Into ModuleSettings (ModuleID,SettingName,SettingValue) Values ( @ModuleId,'SkinFolder','DesktopModules/SnapsisDNN/Skins/AquaBlue/' )

END

FETCH NEXT FROM settings_cursor INTO @ModuleID END

CLOSE settings_cursor

DEALLOCATE settings_cursor

GO
Please Register to post a reply. Another benefit of registration is the ability to subscribe to and recieve notifications of new posts.



ActiveForums 3.7
Powered by: Snapsis Software