Deleting a product fails

Imar Spaanjaars

Posted on 09/01/2015 08:18:29

Hi there,

When I delete a product in the backend, I see the following exception in the client script debugger (as the result from the delete AJAX call):

The DELETE statement conflicted with the REFERENCE constraint &quot;EcomProductCategoryFieldValue$ProductForeignKey&quot;. The conflict occurred in database &quot;fasteddie.dw-demo.com&quot;, table &quot;dbo.EcomProductCategoryFieldValue&quot;.<br>The statement has been terminated.

Looks like the cateogry field data isn't cleaned up before deleting the product. Is this a known issue? We're running on 8.5.1.9.

Imar

Replies

Christian Rud Skovgaard

Posted on 12/01/2015 10:46:44

Hi Imar,

This bug (created as TFS-16377) will be fixed in hotfix 8.5.1.11

Kind Regards

Christian

Imar Spaanjaars

Posted on 12/01/2015 12:38:25

Thanks!

Imar

Kristian Kirkholt

Posted on 14/01/2015 13:39:14

This post has been marked as an answer

Hi Imar

The problem TFS#16377 has now been fixed in version 8.5.1.11

You are able to find this build in the download section:

http://developer.dynamicweb-cms.com/downloads/dynamicweb-8.aspx

Please contact Dynamicweb Support if you need any additional help regarding this.

Kind Regards
Dynamicweb Support
Kristian Kirkholt

Votes for this answer: 1

Imar Spaanjaars

Posted on 20/01/2015 12:45:52

Hi Christian and Kristian,

I just upgraded an existing site to 8.5.1.11 but I am running into the same issue when deleting a product using the Integration Framework Module. When a product no longer exists in the source file and I have "delete products" enabled I am getting the same error.

Could this be the same bug surfacing from a different point in the application?

Imar

Imar Spaanjaars

Posted on 01/02/2015 11:29:19

Bump Any news on this?

Jonas Krarup Dam

Posted on 02/02/2015 10:37:12

Hi Imar,

This one snuck under my radar.

The problem you are having with Data Integration is not (technically) the same as you saw here, since Data Integration accesses the database directly.

Can you give me some more information about what goes wrong?

The usual info is helpful:

SourceProvider

DestinationProvider

error message from the Data Integration log file

if possible, a minimal example of an import file that causes the problem

if possible, relevant information about the state of the database you're importing to.

/Jonas

Imar Spaanjaars

Posted on 02/02/2015 13:22:15

Hi Jonas,

I just e-mailed you a backup of a site that demonstrates the behavior, along with the jobs, source files, error message and a walkthrough video.

Cheers,

Imar

Jonas Krarup Dam

Posted on 11/02/2015 10:05:30

Hi Imar,

I have reproduced the problem.

A bug has been created for it (16653), and it will be fixed in an upcomming 8.6.0.x hotfix.

/Jonas

You must be logged in to post in the forum

Developer forum

Deleting a product fails

Replies