Home Search Tags Members

Home » Kartris ASP.NET Ecommerce Software » Kartris technical issues » DBNull error on Live site. Site down

DBNull error on Live site. Site down

Posted By footie Sat 8 Jan 2011
Add to Favorites1

DBNull error on Live site. Site down

Topic View Topic View Topic Options Topic Options
Author Message
footie
Posted Sat 8 Jan 2011
Supreme Being

Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)

Group: Forum Members
Last Active: Sat 22 Jan 2011
Posts: 6, Visits: 14

While testing out adding a product to the shopping cart on the live site, I received the message:


Error!

An error occurred. The system has written a log file entry.


When checking the log, I find the following Error message referring to a DBNull error:


----------------------------------------------------------------------------

>>     URL:http://angelwingscompany.com/Product.aspx?ProductID=11&L=1

>>     Page:

-----------------------------------------------------------------------------

>>     1/8/2011 3:56:57 AM

>>     98.200.145.30

>>     DESCRIPTION:

System.InvalidCastException: Conversion from type 'DBNull' to type 'Double' is not valid.

   at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags)

   at Microsoft.VisualBasic.CompilerServices.NewLateBinding.CallMethod(Container BaseReference, String MethodName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, BindingFlags InvocationFlags, Boolean ReportErrors, ResolutionFailure& Failure)

   at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCall(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn)

   at Product.Page_LoadComplete(Object sender, EventArgs e)

   at System.EventHandler.Invoke(Object sender, EventArgs e)

   at System.Web.UI.Page.OnLoadComplete(EventArgs e)

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Now when I try going on to the site not even the Default.aspx page will display.  It generates a similar error.  I'm assuming its an issue with the product, but when editing the product in the Admin, it edits fine.  Not sure where the DBNull value is that its referring too.

Subsequent Error messages are logged referring to the Basket.  Take a look:


-----------------------------------------------------------------------------

>>     URL:http://angelwingscompany.com/Basket.aspx

>>     Page:

-----------------------------------------------------------------------------

>>     1/8/2011 3:57:08 AM

>>     98.200.145.30

>>     DESCRIPTION:

System.InvalidCastException: Conversion from type 'DBNull' to type 'Double' is not valid.

   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value, NumberFormatInfo NumberFormat)

   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value)

   at BasketBLL.LoadBasketItems()

   at Templates_BasketView.LoadBasket()

   at Templates_BasketView.Page_Load(Object sender, EventArgs e)

   at System.Web.UI.Control.OnLoad(EventArgs e)

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


-----------------------------------------------------------------------------

>>     URL:http://angelwingscompany.com/default.aspx

>>     Page:

-----------------------------------------------------------------------------

>>     1/8/2011 4:03:06 AM

>>     98.200.145.30

>>     DESCRIPTION:

System.InvalidCastException: Conversion from type 'DBNull' to type 'Double' is not valid.

   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value, NumberFormatInfo NumberFormat)

   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value)

   at BasketBLL.LoadBasketItems()

   at Templates_BasketView.LoadBasket()

   at Templates_BasketView.Page_Load(Object sender, EventArgs e)

   at System.Web.UI.Control.OnLoad(EventArgs e)

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Is this a Basket issue or an issue with the Product Data?

Tags
Edited Sat 8 Jan 2011 by footie
Post Information
footie
Posted Sun 9 Jan 2011
Supreme Being

Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)

Group: Forum Members
Last Active: Sat 22 Jan 2011
Posts: 6, Visits: 14

I tried this again today.  Adding a product to the Basket.  The basket does not update and when I click on the link to view the basket I received this error:


----------------------------------------------------------------------------
>>     URL:http://angelwingscompany.com/Product.aspx?ProductID=12&L=1
>>     Page:
-----------------------------------------------------------------------------
>>     1/9/2011 6:05:48 AM
>>     98.200.145.30
>>     DESCRIPTION:
System.InvalidCastException: Conversion from type 'DBNull' to type 'Double' is not valid.
   at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags)
   at Microsoft.VisualBasic.CompilerServices.NewLateBinding.CallMethod(Container BaseReference, String MethodName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, BindingFlags InvocationFlags, Boolean ReportErrors, ResolutionFailure& Failure)
   at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCall(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn)
   at Product.Page_LoadComplete(Object sender, EventArgs e)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Page.OnLoadComplete(EventArgs e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

==================================================
Post Information
Paul
Posted Thu 13 Jan 2011
große Käse

große Käse - (552,774 reputation)große Käse - (552,774 reputation)große Käse - (552,774 reputation)große Käse - (552,774 reputation)große Käse - (552,774 reputation)große Käse - (552,774 reputation)große Käse - (552,774 reputation)große Käse - (552,774 reputation)große Käse - (552,774 reputation)

Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807, Visits: 2,748
can you confirm which version of kartris you are using? (minor version)

--
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
footie
Posted Fri 14 Jan 2011
Supreme Being

Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)

Group: Forum Members
Last Active: Sat 22 Jan 2011
Posts: 6, Visits: 14
Version 1.2000
Post Information
Medz
Posted Tue 18 Jan 2011
Kartris Expert

Kartris Expert - (71,396 reputation)Kartris Expert - (71,396 reputation)Kartris Expert - (71,396 reputation)Kartris Expert - (71,396 reputation)Kartris Expert - (71,396 reputation)Kartris Expert - (71,396 reputation)Kartris Expert - (71,396 reputation)Kartris Expert - (71,396 reputation)Kartris Expert - (71,396 reputation)

Group: Administrators
Last Active: Tue 3 Dec 2013
Posts: 99, Visits: 1,400
Hi, can you try to execute this query in the backend and see if it fixes the issue?

* navigate to backend -> configuration -> database admin -> run query tab


DISABLE TRIGGER [dbo].[trigKartrisVersions_DML] ON [dbo].[tblKartrisVersions];UPDATE [dbo].[tblKartrisVersions] SET V_Weight = 0 WHERE V_Weight IS NULL;UPDATE [dbo].[tblKartrisVersions] SET V_RRP = 0 WHERE V_RRP IS NULL;UPDATE [dbo].[tblKartrisVersions] SET V_CustomizationCost = 0 WHERE V_CustomizationCost IS NULL;ENABLE TRIGGER [dbo].[trigKartrisVersions_DML] ON [dbo].[tblKartrisVersions]


Regards,

Medz
Post Information
footie
Posted Sat 22 Jan 2011
Supreme Being

Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)Supreme Being - (4,786 reputation)

Group: Forum Members
Last Active: Sat 22 Jan 2011
Posts: 6, Visits: 14
That didnt work.  Same error.  Guess its time to move to another platform. 
Post Information
Mart
Posted Sat 22 Jan 2011
Top Banana

Top Banana - (103,907 reputation)Top Banana - (103,907 reputation)Top Banana - (103,907 reputation)Top Banana - (103,907 reputation)Top Banana - (103,907 reputation)Top Banana - (103,907 reputation)Top Banana - (103,907 reputation)Top Banana - (103,907 reputation)Top Banana - (103,907 reputation)

Group: Administrators
Last Active: Wed 18 Nov 2020
Posts: 148, Visits: 3,450
Is it possible you can zip up the db and send me a link (private message) to download it?

It'll be much easier for us to see whats going wrong.
Post Information

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse
Active: 1 - 1 guest, 0 members, 0 anonymous.
Refresh
No members currently viewing this topic!

Back To Top

Powered By InstantForum.NET 2012-1 © 2025
Execution: 0.062. 11 queries. Compression Enabled.