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

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

10 years ago

Originally Posted by: bbobb

I've changed the scripts, please try it.

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

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

Originally Posted by: bbobb

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

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

10 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

10 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

10 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:

The YAF.NET Support Forum uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close