HomeHome Product Discus... Product Discus...SmithCartSmithCartThe stored procedure The stored procedure 'dbo.Smith_GetZone' doesn't exist.
Previous
 
Next
New Post
2/11/2012 10:01 AM
 
Richard Bandelin
No Ranking

Joined: 12/15/2010
Posts: 25

Hello,

I get this critical error "The stored procedure 'dbo.Smith_GetZone' doesn't exist." when trying to edit any of the zones in my shipping zone list. I thought it may be related to my last upgrade, so I added a new zone, and when I tried to edit it I still got the same error.

How can I fix this?

Cheers,

Ricky
 
New Post
2/13/2012 2:46 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0

Hi Ricky,

I have not been able to replicate this issue in our test environment

Which version of the Cart and DNN are you currently running? It would be helpful if you could provide which version of the Cart you upgraded from.

Can you confirm if the stored procedure 'dbo.Smith_GetZone' exists in your database?

I just tried to replicate this issue on my test portal but was unable to reproduce the same behavior you reported.

Thanks,
 
New Post
2/13/2012 3:25 PM
 
Richard Bandelin
No Ranking

Joined: 12/15/2010
Posts: 25

Hi Kevin,

I think the issue maybe a result of an unsuccesful upgrade at some point in the past. This issue has actually been on our website for a while now, but we have ignored it because it isnt breaking anything.

The issue occured many versions back. I would like to find a solution that doesn't involve a clean install...

Also, Im not sure how to confirm if 'dbo.Smith_GetZone' exists in our database.

Ill try to include more detail in my descriptions so that Im not causing you to spend even more time testing, but I appreciate the help.
 
New Post
2/14/2012 3:13 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Richard,

You can confirm if the stored procedure 'dbo.Smith_GetZone' exists in your database by using SQL Mgmt. Studio to view your stores database.

If the "dbo.Smith_GetZone" stored proc does not exist, you can rn the following script to create it:


CREATE PROCEDURE [dbo].[Smith_GetZone]
(
@ZoneID int
)
AS

SELECT * FROM Smith_ShipZone WHERE [ZoneID] = @ZoneID


GO

Thanks,
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartThe stored procedure The stored procedure 'dbo.Smith_GetZone' doesn't exist.




Questions? Contact us for answers!

Contact Us!