SQL Server DB error when upgrading to latest YAF version· Page 2

Welcome Guest! To enable all features please Login or Register

johnk
74.8% (Friendly)
YAF All-the-Time Topic Starter

11 years ago

#16

I've changed the scripts, please try it.

Originally Posted by: bbobb

http://yafnet.codeplex.com/SourceControl/changeset/dd4b33b38719

Oh, wow...I would not have been able to figure out making so many changes.

It can't garantee a smooth upgrade, but at least we would know what to do next.

Originally Posted by: bbobb

Thanks for the warning. I would make a copy of prod DB and test these changes on the new copy. Azure does not make it easy to import/export data. They force you to create a azure storage account (probbaly pay extra for that), export it as a blog file with BACPAC extension.

I did find a way to do it through either powershell script or DOS command line. It also involves modifying azure firewall rules.

Microsoft does not make it easy. It may take me few hours to do all this and then do more testing to make sure all functionality are working fine. I will report success or error message(s) as soon as I can.

johnk
74.8% (Friendly)
YAF All-the-Time Topic Starter

11 years ago

#17

I just finished all the steps listed listed above. I was able to successfully upgrade the DB without any error.

I was able to create new topic.

I then decided to delete another topic. When I clicked on "Delete" button on first post of that topic, I got this error message

Show Spoiler

Server Error in '/' Application.

Column 'DeleteReason' does not belong to table .

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Column 'DeleteReason' does not belong to table .

Source Error:

Line 282: }

Line 283:

Line 284: if (this.MessageFlags.IsDeleted)

Line 285: {

Line 286: if (this.DataRow.Table.Columns.Contains("IsModeratorChanged" ))

Source File: d:\yafnet_ba903e9138b2\yafsrc\YAF.Controls\MessagePostData.cs Line: 284

Stack Trace:

[ArgumentException: Column 'DeleteReason' does not belong to table .]

System.Data.DataRow.GetDataColumn(String columnName) +5254087

System.Data.DataRow.get_Item(String columnName) +13

YAF.Controls.MessagePostData.RenderMessage(HtmlTextWriter writer) in d:\yafnet_ba903e9138b2\yafsrc\YAF.Controls\MessagePostData.cs:284

YAF.Controls.MessagePost.Render(HtmlTextWriter writer) in d:\yafnet_ba903e9138b2\yafsrc\YAF.Controls\MessagePost.cs:275

System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +57

System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +100

System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25

System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +128

System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +8

System.Web.UI.Control.Render(HtmlTextWriter writer) +10

System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +57

System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +100

System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25

System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +128

System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +8

System.Web.UI.Control.Render(HtmlTextWriter writer) +10

System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +57

System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +100

System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25

System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +128

System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +8

YAF.Core.ForumPage.Render(HtmlTextWriter writer) in d:\yafnet_ba903e9138b2\yafsrc\YAF.Core\BasePages\ForumPage.cs:554

System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +57

System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +100

System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25

System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +128

System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +8

YAF.Forum.Render(HtmlTextWriter writer) +278

System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +57

System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +100

System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25

System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +128

System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +8

System.Web.UI.Control.Render(HtmlTextWriter writer) +10

System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +57

System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +100

System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25

System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +128

System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) +216

System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +32

System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) +53

System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +57

System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +100

System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) +40

System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +128

System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +8

System.Web.UI.Control.Render(HtmlTextWriter writer) +10

System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +57

System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +100

System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25

System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +128

System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +8

System.Web.UI.Page.Render(HtmlTextWriter writer) +29

System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +57

System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +100

System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1386

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18044

I will continue my testing and report any error messages I get.

bbobb
100% (Exalted)
YAF Developer

11 years ago

#18

I see. This is really a bug. First message in a topic gets the wrong end of the stick. I deleted second post in a topic and reproduced it.

But it's not related to SQL scripts.

johnk
74.8% (Friendly)
YAF All-the-Time Topic Starter

11 years ago

#19

I am glad you were able to duplicate it. The weird thing about this bug is that if I create a new topic, I can delete it successfully.

But if I try to delete an older topic created by someone else, it gives an error message. However if I try to delete an older topic created by me, it works fine.

Important Information: