Search Forum Home   DotNetNuke  CATALooK.netStore  Invoices not pr...  Invoices not produced - Object cannot be cast from DBNull to other types    1/24/2011 3:49:15 PM DavidT 30 posts Invoices not produced - Object cannot be cast from DBNull to other types I have just started receiving this error: A critical error has occurred. Object cannot be cast from DBNull to other types. It happens every time an invoice is attempted - on checkout, on viewing orders and trying to send the email... always and for all users (incl. superusers). Details: AssemblyVersion: 04.09.05 PortalID: 0 PortalName: UserID: 1 UserName: ActiveTabID: 711 ActiveTabName: Orders RawURL: /MyAccount/SiteAdmin/CATALooKnetStore/Orders/tabid/711/OrderID/126/CustomerID/926/ModuleID/1587/Custx/0/Default.aspx?StartDate=01%2f01%2f2011&EndDate=24%2f01%2f2011 AbsoluteURL: /Default.aspx AbsoluteURLReferrer: https://.../MyAccount/SiteAdmin/CATALooKnetStore/Orders/tabid/711/OrderID/126/CustomerID/926/ModuleID/1587/Custx/0/Default.aspx?StartDate=01%2f01%2f2011&EndDate=24%2f01%2f2011 UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.1.16) Gecko/20101130 Firefox/3.5.16 GTBDFff GTB7.0 DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider ExceptionGUID: 268b1048-d30b-40c9-870b-d73b5dd133d7 InnerException: Object cannot be cast from DBNull to other types. FileName: FileLineNumber: 0 FileColumnNumber: 0 Method: System.DBNull.System.IConvertible.ToDouble StackTrace: Message: DotNetNuke.Services.Exceptions.PageLoadException: Object cannot be cast from DBNull to other types. ---> System.InvalidCastException: Object cannot be cast from DBNull to other types. at System.DBNull.System.IConvertible.ToDouble(IFormatProvider provider) at System.Convert.ToDouble(Object value) at CATALooK.Forms.RenderInvoiceForm(Int32 orderId, Int32 UserID, Int32 InvoiceNumber, Int32 PortalID) at CATALooK._OrderDetails.SendInvoiceEmail(Int32 InvoiceID) at CATALooK._OrderDetails.btnInvoiceEmail_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- Source: Server Name: A418 Where might this error be happening? What can I do to fix it? Thanks  1/31/2011 9:35:35 AM DavidT 30 posts Re: Invoices not produced - Object cannot be cast from DBNull to other types Any hints into this at all? At least the RTE seems to be working now.  2/18/2011 6:02:37 AM DavidT 30 posts Re: Invoices not produced - Object cannot be cast from DBNull to other types Any possibly help into where to look in the database to sort this would be appreciated. It's completely killed being able to produce invoices!  Such an important part as the last step of the cart process!!! What tables and columns are needed for the invoice to be emailed? PLEASE HELP!!!  4/5/2011 12:11:19 PM DavidT 30 posts Re: Invoices not produced - Object cannot be cast from DBNull to other types Still having this problem, so any help would be appreciated. Thinking otherwise just to develop my own cart, or use the PayPal one.  4/5/2011 1:05:27 PM steve123 84 posts stefporter.com Re: Invoices not produced - Object cannot be cast from DBNull to other types Hi David, which email templates you are using (standard or advanced)? Did you changed them ? Which CATALooK version you are using ? Regards, Stefan. Feel free to contact me: service@stefporter.com  4/5/2011 1:22:47 PM DavidT 30 posts Re: Invoices not produced - Object cannot be cast from DBNull to other types Hi Stefan I'm using the standard email template, changed of course for branding but little else. It's Catalook 5.9.7, and DNN 4.9.5 (can't upgrade due to Catalook not running on DNN 5+). The invoice seems to work for some but certainly not for any that have subscriptions or roles. Thanks David  Page 1 of 2 12Next    DotNetNuke  CATALooK.netStore  Invoices not pr... Flat View Tree View Oldest To Newest Newest To Oldest