Developer forum

Forum » Dynamicweb 9.0 Upgrade issues » Column 'OrderDebuggingInfoOrderAutoID' does not belong to table Table.

Column 'OrderDebuggingInfoOrderAutoID' does not belong to table Table.

Eva Sommer
Reply

We have upgraded from 8+ to 9.13.5.

During testing we found that when "Add to basket" is clicked we receive the error below. Can someone help us solve this?

 

Server Error in '/' Application.
Column 'OrderDebuggingInfoOrderAutoID' does not belong to table 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 'OrderDebuggingInfoOrderAutoID' does not belong to table Table.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ArgumentException: Column 'OrderDebuggingInfoOrderAutoID' does not belong to table Table.]
   System.Data.DataRow.GetDataColumn(String columnName) +62
   Dynamicweb.Ecommerce.Orders.OrderDebuggingInfo.Save() +457
   Dynamicweb.Ecommerce.Orders.OrderDebuggingInfo.Save(Order order, DateTime time, String message, String source, DebuggingInfoType infoType) +155
   Dynamicweb.Ecommerce.Frontend.Cart.CartService.LogEvent(Order order, String message, String name, DebuggingInfoType infoType, Object[] params) +847
   Dynamicweb.Ecommerce.Cart.Frontend.LogEvent(Order order, String message, Object[] params) +60
   Dynamicweb.Ecommerce.Orders.OrderRepository.Save(Order order) +13290
   Dynamicweb.Ecommerce.Orders.OrderService.Save(Order order, Boolean saveOldVersion) +280
   Dynamicweb.Ecommerce.Frontend.Cart.CartService.SaveCart(Order cart, User user, OrderContext orderContext) +74
   Dynamicweb.Ecommerce.Common.Context.SetCart(Order cart, User user, OrderContext orderContext) +114
   Dynamicweb.Ecommerce.Frontend.Cart.CartService.CreateCart(User user, String sessionId, Boolean setAsActive, String displayName) +1056
   Dynamicweb.Ecommerce.Frontend.Cart.CartCatch.CatchCart(Int32 pageId, PageView pageView) +3414
   Dynamicweb.Ecommerce.Frontend.EcomPageLoadNotificationSubscriber.LoadedPage(PageView pageview) +446
   Dynamicweb.Extensibility.Notifications.NotificationManager.Notify(String notification, NotificationArgs eventArgs) +866
   Dynamicweb.Frontend.PageView.Load() +2485
   Dynamicweb.AspNet.DynamicwebHttpHandler.ProcessRequest(HttpContext context) +50
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +866
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +213
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +91

 


Replies

 
Morten Bengtson Dynamicweb Employee
Morten Bengtson
Reply
This post has been marked as an answer

Hi Eva,

The error indicates that your database has not been updated yet.
I assume that you have followed the guide for Upgrading to Dynamicweb 9.

After the upgrade you can go to Settings > System information.
Scroll to "Updates" at the bottom of the page and enter 2000 for the two input fields.
Click "Rerun updates" and the updates will be applied to the database and your error should go away.

Best regards,
Morten

Votes for this answer: 1
 
Eva Sommer
Reply

Hi Morten,

So we thought that the problem was solved, after rerunnning the updates as you suggested, but it still persists.

First we updated the solutions locally with nuget, updated all custom code to work on 9.13.5 and here there are no issues with the database not being updated (Database is from live env)

We then copied Admin and bin to our staging env. And here we see the error, meaning the database does not update (same database from live env as tried on locally). When logging in to /admin we can see that the interface has updated to 9.13.5. 

Jus check the GlobalSettings

      <PerformedOncePackages>
        <updates.xml>2119,2114,2082,2029,2028,2023,2021</updates.xml>
        <ecom.xml>2029,2028,2027</ecom.xml>
      </PerformedOncePackages>

Any ideas?

-Thanks

Eva

 

 
Morten Bengtson Dynamicweb Employee
Morten Bengtson
Reply
This post has been marked as an answer

It is because GlobalSettings and database are out of sync.
It looks like your GlobalSettings comes from an already updated solution and then the database will not be fully updated due to PerformedOncePackages.
You can try to remove <PerformedOncePackages> from GlobalSettings and then rerun the updates as described before.

Votes for this answer: 1

 

You must be logged in to post in the forum