Developer forum

Forum » Development » Local DW install with SQL DB

Local DW install with SQL DB


Reply

I've installed a local DW copy for development purposes using a local SQL Server database.

 

I can log on to the admin backend - I can create pages in the site tree - but when I try to save a new page paragraph, I get the following error:

 

"Kolonnen 'ParagraphPreview' tilhører ikke tabellen Table"   (Danish XP Pro IIS)

 

and this stack trace:

 

[ArgumentException: Kolonnen 'ParagraphPreview' tilhører ikke tabellen Table.]
   System.Data.DataRow.GetDataColumn(String columnName) +1775301
   System.Data.DataRow.set_Item(String columnName, Object value) +12
   Dynamicweb.Content.Paragraph.FillRow(DataRow row) +1155
   Dynamicweb.Modules.Common.DbObject.Save() +192
   Dynamicweb.Content.Paragraph.Save() +12
   Dynamicweb.Admin.ParagraphEdit.SaveParagraph() +605
   Dynamicweb.Admin.ParagraphEdit.Page_Load(Object sender, EventArgs e) +536
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
 

 

Any idea what I did wrong?

 

 

Regards,

Kim J


Replies

 
Reply
kij@cadesign.dk wrote:

I've installed a local DW copy for development purposes using a local SQL Server database.

 

I can log on to the admin backend - I can create pages in the site tree - but when I try to save a new page paragraph, I get the following error:

 

"Kolonnen 'ParagraphPreview' tilhører ikke tabellen Table"   (Danish XP Pro IIS)

 

and this stack trace:

 

[ArgumentException: Kolonnen 'ParagraphPreview' tilhører ikke tabellen Table.]
   System.Data.DataRow.GetDataColumn(String columnName) +1775301
   System.Data.DataRow.set_Item(String columnName, Object value) +12
   Dynamicweb.Content.Paragraph.FillRow(DataRow row) +1155
   Dynamicweb.Modules.Common.DbObject.Save() +192
   Dynamicweb.Content.Paragraph.Save() +12
   Dynamicweb.Admin.ParagraphEdit.SaveParagraph() +605
   Dynamicweb.Admin.ParagraphEdit.Page_Load(Object sender, EventArgs e) +536
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
 

 

Any idea what I did wrong?

 

 

Regards,

Kim J


 

Hi I have the same error and are told to run the update script from package 189. Do you know what this means?

 
Reply

Hi,

 

I had no idea, but your reply led me to look in the updates folder.

 

All I had to do was execute the following SQL on my local databse:

 

"ALTER TABLE Paragraph ADD ParagraphPreview BIT NOT NULL DEFAULT 0"

 

This fixed the issue and I can now add paragraphs.

 

 

 

Regards,

Kim Jensen

 

You must be logged in to post in the forum