|
By thopcroft - Wed 24 Jul 2013
|
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)
==================================================
|
|
By Paul - Wed 24 Jul 2013
|
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
|
|
By thopcroft - Wed 24 Jul 2013
|
|
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.
|
|
By thopcroft - Sat 27 Jul 2013
|
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
|