Error displaying widgets

Jul 25, 2008 at 2:57 AM
Edited Jul 25, 2008 at 3:00 AM
I'm running and it appears fine except that I get the following error when I try to add a widget:
Implicit conversion from data type nvarchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.

Source Error:

Line 229:		WidgetSettings ws = new WidgetSettings(_zoneId);
Line 230: ws.SettingsBehavior = new XMLDocumentBehavior();
Line 231: ws.SaveSettings(doc);
Line 232: Cache[_zoneId] = doc;
Line 233: }

Source File: d:\hosting\3080307\html\cory\admin\WidgetEditor.aspx.cs    Line: 231

Any ideas?
Jul 25, 2008 at 6:53 PM
I get a similar message using time I can't even load the default page.

Source Error:

Line 394:  {
Line 395: BlogEngine.Core.DataStore.ExtensionSettings xs = new BlogEngine.Core.DataStore.ExtensionSettings(ext.Name);
Line 396: xs.SaveSettings(ext);
Line 397: return true;
Line 398: }

Source File: d:\hosting\3080307\html\cory\App_Code\ExtensionManager\Manager.cs    Line: 396

Is this a problem with my configuration?
Jul 25, 2008 at 8:33 PM
My mistake. I upgraded but didn't run the SQL upgrade script. Looks like the Settings column in the be_DataStoreSettings table had a data type change from varbinary to nvarchar.