Home Search Tags Members

Home » Kartris ASP.NET Ecommerce Software » Kartris technical issues » Error in Stored Procedure spKartrisProducts_GetTopList

Error in Stored Procedure spKartrisProducts_GetTopList

Posted By Valerio Thu 4 Sep 2014
Add to Favorites1

Error in Stored Procedure spKartrisProducts_GetTopList

Topic View Topic View Topic Options Topic Options
Author Message
Valerio
Posted Thu 4 Sep 2014
Supreme Being

Supreme Being - (5,308 reputation)Supreme Being - (5,308 reputation)Supreme Being - (5,308 reputation)Supreme Being - (5,308 reputation)Supreme Being - (5,308 reputation)Supreme Being - (5,308 reputation)Supreme Being - (5,308 reputation)Supreme Being - (5,308 reputation)Supreme Being - (5,308 reputation)

Group: Forum Members
Last Active: Tue 31 May 2016
Posts: 10, Visits: 42
Hi,i've an error with that store procedure. I've a catalog of 20.000 products and if I make an order for a product with an ID greater than 255, I get an error from store procedures spKartrisProducts_GetTopList:
"overflow error for data type tinyint, value" and the product id.
How can I fix?
thanks a lot of collaboration.
Post Information
Valerio Marked As Answer
Posted Thu 4 Sep 2014
Supreme Being

Supreme Being - (5,308 reputation)Supreme Being - (5,308 reputation)Supreme Being - (5,308 reputation)Supreme Being - (5,308 reputation)Supreme Being - (5,308 reputation)Supreme Being - (5,308 reputation)Supreme Being - (5,308 reputation)Supreme Being - (5,308 reputation)Supreme Being - (5,308 reputation)

Group: Forum Members
Last Active: Tue 31 May 2016
Posts: 10, Visits: 42
Solved!If anyone is interested,
i've changed @P_ID and @LANG_ID to int in fnKartrisProducts_GetName and line 20 in spKartrisProducts_GetTopList to
SELECT TOP (@Limit) vKartrisCategoryProductsVersionsLink.P_ID, [dbo].[fnKartrisProducts_GetName](vKartrisCategoryProductsVersionsLink.P_ID, @LANG_ID) AS P_Name
Post Information
Paul
Posted Thu 9 Oct 2014
große Käse

große Käse - (452,600 reputation)große Käse - (452,600 reputation)große Käse - (452,600 reputation)große Käse - (452,600 reputation)große Käse - (452,600 reputation)große Käse - (452,600 reputation)große Käse - (452,600 reputation)große Käse - (452,600 reputation)große Käse - (452,600 reputation)

Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806, Visits: 2,737
Thanks, this was updated in the latest code which will be part of the next release, but the SQL is here if anyone needs it:

https://kartris.codeplex.com/SourceControl/latest#Uploads/Resources/UpdateSQL_2.7000_To_2.7002.sql

--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.

If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
Post Information

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top

Powered By InstantForum.NET 2012-1 © 2024
Execution: 0.078. 9 queries. Compression Enabled.