Developer forum

Forum » Ecommerce - Standard features »  Kolonnen 'OrderLineWishListID' tilhører ikke tabellen Table.

Kolonnen 'OrderLineWishListID' tilhører ikke tabellen Table.

E-mail notifications
Mikkel Toustrup Olsen
Reply
Posted on 25/03/2015 13:47:04

Hello,

I am currently working on a webshop where I encounter this odd error saying : The column 'OrderLineWishListID' does not belong to the table Table.

Kolonnen 'OrderLineWishListID' tilhører ikke tabellen Table. 

[ArgumentException: Kolonnen 'OrderLineWishListID' tilhører ikke tabellen Table.]
   System.Data.DataRow.set_Item(String columnName, Object value) +3045548
   Dynamicweb.eCommerce.Orders.OrderLine.Save(DataRow DataRow) +2056
   Dynamicweb.eCommerce.Orders.OrderLineCollection.Save(String OrderID) +6

Prior to the error I hit an add to cart button which should ajax the specific product id to the cart. I have literally no clue on what forces this to happen - anyone encountered a similar error before?


Replies

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 25/03/2015 13:52:01
Reply

Sounds like a mismatch between the application version and your database version. Try updating the database under Management Center | System | System Information. At the bottom of the page, set both numbers to 1 and hit Rerun Updates.

Hope this helps,

Imar

 

 
Mikkel Toustrup Olsen
Posted on 25/03/2015 14:13:25
Reply

Hi Imar,

Thanks for the quick reply. The re-run updates method didn't help, unfortunately. It still gives me the error. I can see, however, that the column is in the database and in the dynamicweb.dll by decompiling.

Regards,

MikkelTO

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 25/03/2015 14:25:12
Reply

Was the column there before the update? If not, it was added but thee might be cached data that's not aware of it? Try recycling the site in IIS....

 
Mikkel Toustrup Olsen
Posted on 25/03/2015 15:07:50
Reply

Hi Imar,

No it was not present, and even after IIS recycle it's still not showing. I ill try to create the field manually instead :-)

 

 
Morten Bengtson
Posted on 25/03/2015 15:20:04
Reply

You could take a look at the update log file to see if any errors have occurred which would prevent DW from creating this column.

/Admin/Update/ShowUpdateLog.aspx

 

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 25/03/2015 15:24:28
Reply

I am little confused. This "I can see, however, that the column is in the database" seems to suggest it is there, doesn't it?

Imar

 

 
Nicolai Høeg Pedersen
Posted on 26/03/2015 12:46:38
Reply

Also make sure the DB user has ddl rights.

 

You must be logged in to post in the forum