Upgrade questions---what does the upgrade affect

Upgrade questions---what does the upgrade affect

Home » Kartris ASP.NET Ecommerce Software » Kartris technical issues

https://forum.kartris.com/Topic1521.aspx

Print Topic | Close Window

By saturation - Tue 17 Jan 2012

Are there changes to both the database and the .NET pages if I run the data tool upgrade? I'm scared my customizations will get overwritten if I run the upgrade. I'm on 1.3003 (?) and am attempting to do the upgrade by replacing only the files I've changed. I've made good progress, but I seem to have run into some database issues, so I'm wondering if I should just troubleshoot the errors or run the upgrade from the data tool. One error I can't seem to get past on the admin login screen after I submit the page (Admin/_Default.aspx):

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

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

I'm guessing there won't be many more issues past this, but I just don't know. Any suggestions are appreciated.

By Paul - Tue 17 Jan 2012

One of the things we've added in the latest 1.3007 zip is incremental SQL update scripts to handle db changes. If you go to the following location, you can see these:

/Uploads/Resources/

For example, UpdateSQL_1.3000_To_1.3003.sql should be run first if your present db is 1.3002 or lower.

Then run each subsequent update until you arrive at 1.3007.

This should avoid you having to use the data tool for minor db updates.

We will have similar for 1.4 too - so v1.3 Kartris sites should be able to be upgraded to 1.4 without using the data tool (although it is still an option).

By thedrumdoctor - Tue 17 Jan 2012

I successfully upgraded from 1.3 to 1.4 using the appropriate update script from the Uploads\Resources directory. Smile