Hi Mike,

I have not been able to replicate this on our test portal, did you recently upgrade unable to recreate the same results, but I may not have the exact same configuration as you. Can you login to our test site www7.smith-consulting.com and try to replicate the error. This will determine if the issue is with the latest version of the cart or an issue with your specific dnn portal/cart install. Email me at kevin@smith-consulting.com if you need login credentials.

Thanks,

Hi Mike,

What you are experiencing seems do be an issue with the Identity(QuantityDiscountID) Column of your database. An identity is a common "auto generated" primary key to use in a SQL Server database. An identity is simply an integer value that "auto increments" as each new row is added to your table. If yours is not populating automatically then this points to an issue with your SQL database. You can't alter the existing columns for identity so you have the following 2 options:

1. Create a new table with identity & drop the existing table
2. Create a new column with identity & drop the existing column

Thanks,

I've actually never seen this before where sql server doesnt create the idenity field on insert. All the cart tables have identity columns as the primary key is the qty discount table the only table with this issue? To fix I would try what Kevin recommended by dropping and re creating the table should fix it.

---

Scott Kelly
Project Manager

Yes, set it as a primary key but the most important thing is make sure the "identity" property for the QuantityDiscountID field is set to "True" .

---

Scott Kelly
Project Manager