Developer forum

Forum » Development » ecom problems sqlexp2008

ecom problems sqlexp2008

E-mail notifications
Jais Edelmann
Reply
Posted on 21/12/2012 14:34:52

i cant create new product groups, and i cannot remove or rename a shop if i rename a shop i just get a new shop with the new name? I've triede removing files folder and database and download'd new everytime i change update to 10 and update ecom to 10

Stacktrace on createing product group (i use defaultemptydata8sql)



[SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "EcomShopGroupRelation$EcomShopsEcomShopGroupRelation". The conflict occurred in database "globalisers-web", table "dbo.EcomShops", column 'ShopID'.
The statement has been terminated.]
   System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) +2290668
   System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) +75
   System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) +3479
   System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping) +66
   System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable) +370
   Dynamicweb.eCommerce.Products.GroupShopRelation.Save(String IDstr, String ShopIdStr) +618
   Dynamicweb.Admin.eComBackend.EcomGroupEdit.Save(String languageId) +1651
   Dynamicweb.Admin.eComBackend.EcomGroupEdit.RBSaveAndClose_Click(Object sender, EventArgs e) +23
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804

 

 


Replies

 
Jais Edelmann
Posted on 21/12/2012 23:41:41
Reply
Okay i've triede 3 times to redo the solutions with new files set and dba i have a feeling i must be missing something
 
Jais Edelmann
Posted on 21/12/2012 23:44:22
Reply

21-12-2012 23:35:15 Updates initialized
21-12-2012 23:35:15 Not upgrade license valid!
21-12-2012 23:35:15 Updates initialized
21-12-2012 23:35:15 Not upgrade license valid!

 

Just got that in my updatelog.html.aspx?

 

Edit:

After redoing it in the backend through  management center > mangement , i got it updated but i still have the same error.

 

I'm running on IIS8 but shouldent really have anything todo with the database error

 

Edit2:

Triede updating to the latest version 8.2.0.3 same issues

 
Jais Edelmann
Posted on 22/12/2012 01:21:00
Reply

Also when i go under websites, i can create a new website but if i try and update it i get another error:

[DirectoryNotFoundException: Could not find a part of the path 'C:\Development\Globalisers\globalisers-web\src\globalisers-web\Files\System\Items\WebsiteLayouts_2.xml'.]
   System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) +338
   System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) +1430
   System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy) +208
   System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, Boolean useAsync) +112
   System.Xml.XmlWriterSettings.CreateWriter(String outputFileName) +7569808
   Dynamicweb.Content.Items.Metadata.XmlWebsiteItemTypeLayouts.Save() +148
   Dynamicweb.Admin.Edit2.SaveChanges() +240
   Dynamicweb.Admin.Edit2.Page_Load(Object sender, EventArgs e) +539
   System.Web.UI.Control.LoadRecursive() +71
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3178

 

 

 
Jais Edelmann
Posted on 22/12/2012 12:05:19
Reply
So i decided to start on a fresh today and try and go with the version:  Application(8.1.3.1) , now i can update websites again with out the error above however i still get the Ecom bug im really in a hurry to get this fixed so any help would be greatful

 

Edit:

I can create a sub group to "gruppe1" but i cannot create a side group?

 
Jais Edelmann
Posted on 23/12/2012 01:36:31
Reply
Hmm seems all the problems disapred as soon as i deployed on production, except i had to redo all products and pages there as they werent outputtin in the frontend very very strange.

 

You must be logged in to post in the forum