Developer forum

Forum » Rapido » Error in new installation of Wrap 9 Solution Set

Error in new installation of Wrap 9 Solution Set

E-mail notifications
Aki Ruuskanen
Aki Ruuskanen
Reply
Posted on 07/03/2017 13:45:22

Hi,

I dowloaded the lates DB for Wrap9 and the lates solutions for wrap9.

Installed and admin fired up nicely but when I go to frontend I get an error message shown below. Looks like the DB is not up to date,  I tried to change to version numbers in the update-xml files but no luck. 

Any ideas?

 

[IndexOutOfRangeException: ShopUseAlternativeImages]
   System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +2348872
   System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +122
   System.Data.SqlClient.SqlDataReader.get_Item(String name) +21
   Dynamicweb.Ecommerce.Shops.Shop.Fill(IDataReader dataReader) +687
   Dynamicweb.Ecommerce.Shops.Shop.get_CachedShops() +292
   Dynamicweb.Ecommerce.Shops.Shop.GetShops() +80
   Dynamicweb.Ecommerce.Common.Application.GetShops() +580
   Dynamicweb.Ecommerce.Common.Application.GetShop(String shopId) +35
   Dynamicweb.Ecommerce.Common.Context.GetCartContext() +284
   Dynamicweb.Ecommerce.Common.Context.ConvertKeyToCartContextAwareKey(String key) +13
   Dynamicweb.Ecommerce.Frontend.Cart.CartCatch.LoadCart() +79
   Dynamicweb.Ecommerce.Common.Context.GetCart() +10
   Dynamicweb.Ecommerce.Frontend.Cart.CartCatch.CatchCart(Int32 pageId, PageView pageView) +427
   Dynamicweb.Ecommerce.Frontend.EcomPageLoadNotificationSubscriber.LoadedPage(PageView pageview) +47
   Dynamicweb.Extensibility.Notifications.NotificationManager.Notify(String notification, NotificationArgs eventArgs) +977
   Dynamicweb.Frontend.PageView.Load() +2256
   Dynamicweb.Frontend.DynamicwebHttpHandler.ProcessRequest(HttpContext context) +177
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +508
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +92

Replies

 
Nicolai Pedersen
Posted on 09/03/2017 11:42:31
Reply

Missing ddl rights for the SQL user?

 
Aki Ruuskanen
Aki Ruuskanen
Posted on 09/03/2017 12:07:35
Reply

I can log in and access admin so there should not be any problem with the SQL user. 

When I click in eCommerce I get the error shown above. Looks like missing field in database. 

I installed admin through the package manager : https://www.myget.org/F/dynamicweb-packages/api/v3/index.json

Shouln't the database be updated automatically like in the 8 versions?

Regards / Aki

 

 
Aki Ruuskanen
Aki Ruuskanen
Posted on 09/03/2017 12:23:27
Reply

How does updating of the database work if I upadate the admin through package manager? Is it still handeled with the update.xml, UpdateVersion_ecom.xml?

Tried to start looking in the documentation but the dw9 section is down : http://doc.dynamicweb.com/documentation-9/introduction

/Aki

 
Nicolai Pedersen
Posted on 09/03/2017 14:24:15
Reply

Hi Aki

The SQL user needs read, write and ddl permissions - if the latter does not exist, the database cannot be updated. Also there is a log file next to updates.xml.aspx that tells you what errors there is.

Updating a package will not change DB - only if you update Dynamicweb.Admin.

If you upgrade a package from 1.X to 1.y you do not have to update Dynamicweb.Admin package - if a package change from 1.x to 2.0 it could contain a major change that requires other APIs above and the admin to be updated - that would be in the release information on that package.

NP

 
Aki Ruuskanen
Aki Ruuskanen
Posted on 09/03/2017 14:26:27
Reply

Alright. Thanks for the input. 

I think I should get thing to work now. 

/Aki

 

You must be logged in to post in the forum