HomeHome Product Discus... Product Discus...SmithCartSmithCartDelete Link not workingDelete Link not working
Previous
 
Next
New Post
5/11/2010 12:40 PM
 
When I go to manage products and try to delete one, the confirmation comes up and I click ok, but then nothing happens. Has anyone else had a problem with the delete link not working?
 
New Post
5/11/2010 2:14 PM
 

No one has reported that issue before is there an error in your dnn event viewer?

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
5/11/2010 2:57 PM
 
No, I checked that before I posted. I also ran firebug and clicked the delete link and it doesn't throw an error. I even checked the error log on the server and there was nothing. I'm really stumped on this one. I just did a fresh install too. Should I escalate this to a ticket?
 
New Post
5/14/2010 10:00 AM
 
Is there anything else you can help me with? This is still not working.
 
New Post
5/14/2010 1:13 PM
 

Have you manipulated the data in the tables outside of the cart using sql server? Or have you made any customizations to the ascx pages?


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
5/14/2010 1:34 PM
 
I had to do an upgrade and export the sql data and them import it again. Everything else is working though.
 
New Post
5/14/2010 2:27 PM
 

That probably has something to do with it. When you imported your data did you check the checkbox in the sql server import wizard to allow identity inserts? Most likely what has happened is the primary keys on the product table or child tables are out of sync.


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
5/14/2010 2:29 PM
 
I didn't check that the first time, but I re imported the data and did it correctly the second time. The categories would not be working if the identities were off. Shouldn't the delete link just be removing the product based on the product's id?
 
New Post
5/14/2010 2:31 PM
 

Yes it should here is the stored proc for deleting a product its pretty simple. Does it exist in your sql database?

ALTER PROCEDURE [dbo].[dnn_Smith_DeleteProducts]
@ProductID int
AS

DELETE FROM dnn_Smith_Products
WHERE [ProductID] = @ProductID


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
5/14/2010 2:38 PM
 
Yes it exists. What I don't understand is that there is no error anywhere. I don't get one from my JS debugger, and there is nothing in the DNN or server error logs.
 
New Post
5/14/2010 3:04 PM
 

Ya this is definitely a wierd one. Maybe its a permissions issue or something in your database does the sql account in your web config have the proper permission to delete records? Try checking your sql server logs and windows event viewer logs.

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartDelete Link not workingDelete Link not working