YAFLogo

johnk
  • johnk
  • 74.8% (Friendly)
  • YAF All-the-Time Topic Starter
9 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
  • johnk
  • 74.8% (Friendly)
  • YAF All-the-Time Topic Starter
9 years ago
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

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
  • bbobb
  • 100% (Exalted)
  • YAF Developer
9 years ago
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
  • johnk
  • 74.8% (Friendly)
  • YAF All-the-Time Topic Starter
9 years ago
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.