|
Group: Forum Members
Last Active: Fri 31 Oct 2014
Posts: 18,
Visits: 96
|
When I try to transfer data from a 1.3009 database to a 2.5002 database it fails to transfer the order table data because of errors in the linked promotions table. This is stopping us from migrating to the latest versions as we loose our order history
Could you please look at data tool version that fixes this problem.
Version:2.5002
>> URL:http://109.228.16.93/store/Admin/_OrdersList.aspx?CustomerID=1485&callmode=customer
>> Page:
-----------------------------------------------------------------------------
>> 24/07/2013 17:31:30
>> 109.228.16.93
>> DESCRIPTION:
System.InvalidCastException: Conversion from type 'DBNull' to type 'Boolean' is not valid.
at Microsoft.VisualBasic.CompilerServices.Conversions.ToBoolean(Object Value)
at ASP.usercontrols_back__orderslist_ascx.__DataBinding__control30(Object sender, EventArgs e)
at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
at System.Web.UI.Control.DataBindChildren()
at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
at System.Web.UI.Control.DataBindChildren()
at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
at System.Web.UI.Control.DataBindChildren()
at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
at System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource)
at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding)
at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data)
at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
at UserControls_Back_OrdersList.RefreshOrdersList(Boolean blnRetrieveTotalCount)
at UserControls_Back_OrdersList.Page_Load(Object sender, 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.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)
==================================================
|
|
Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806,
Visits: 2,737
|
There was a new data tool released today - can you confirm if this is the one you are using (v2.5000). The version number is shown at the foot of the left hand menu.
Also, there is an alternative way to upgrade a db which is probably simpler:
http://www.kartris.com/Knowledgebase/Upgrading-Kartris---incremental-updates-1.3__k-35.aspx
--
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
|
|
Group: Forum Members
Last Active: Fri 31 Oct 2014
Posts: 18,
Visits: 96
|
We are using the latest data tool v2.500. the error message is generated when I select list orders in the customer list, the order payments are displayed OK its only the order lists that are not displayed. The table tblKartrisOrders in database v2.500 contains data fields.
|
|
Group: Forum Members
Last Active: Fri 31 Oct 2014
Posts: 18,
Visits: 96
|
A Quick Update
The error is caused by table tblKartrisPromotionStrings field PS_LanguageStringName which contains Null rather than the required 10 language strings
(1 = ContentText_PromotionTextBuyVersion) etc.
I manually added the required strings and the Orders and promotions are now visible
|