Thread: error on checkout page

Hi i get this error on checkout page.

HTML Code:

Could not find stored procedure 'aspdnsf_updOrderitemQuantityDiscount'.

what could be wrong

That's the same problem you had in this thread, and we walked you through how to fix it step by step - the same applies.

At some point, while running the install or upgrade script something failed and you lost some sprocs. You just need to go through the same steps to replace that.

I could fix it. i created Sproc and checkout is working fine.

but i have one more error in product viewing page

HTML Code:

Exception=Could not find stored procedure 'Quix_GetParentSection'.

this message is showing at the bottom of the page, i have all the information in that page with no problem.

I was actually comparing this store DB to the other 8.1 DB and gettign the SQL for the missing Sproc.

But i don't find and Sproc like Quix_GetParentSection in both websites.

Could you please tell me where can i find this Sproc so that i can get that SQL for this and run it in this website.

That looks like a custom sproc - I've always found that ASPDNSF prefixes them with aspdnsf_

How can I get rid of that message?

That message means the stored procedure is missing, you probably deleted it somehow or forgot to upload it.
You need to recreate it.

just created a dummy sproc.