Problems getting backend to run on localhost

Problems getting backend to run on localhost

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

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

Print Topic | Close Window

By southwor - Tue 26 Jul 2011

Hi

We have been trying to do an update on a local server but have problems getting into the backend. Often the browser fails to establish a connection, reporting the site seems valid but failed to connect. Sometimes we get the backend login screen and this then fails with 'An error occurred the system has written a log file entry". A typical entry is below.

Any help appreciated. Thanks southwor

-----------------------------------------------------------------------------
>>     URL:http://localhost/Kartris/Admin/_Default.aspx
>>     Page:
-----------------------------------------------------------------------------
>>     26/07/2011 21:31:33
>>     127.0.0.1
>>     DESCRIPTION:
System.InvalidCastException: Conversion from type 'DBNull' to type 'Boolean' is not valid.
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToBoolean(Object Value)
   at _CategoryMenu.BuildTopLevelMenu()
   at _CategoryMenu.LoadCategoryMenu()
   at _CategoryMenu.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.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

==================================================

By Mohammad - Wed 27 Jul 2011

Hi,

Make sure the CAT_Live field in tblKartrisCategories doesn't allow NULL values, if it allows NULL values (which means the table has been altered), then try to run the below SQL into your database:

DISABLE TRIGGER trigKartrisCategories_DML ON dbo.tblKartrisCategories;
UPDATE dbo.tblKartrisCategories SET CAT_Live = 1 WHERE CAT_Live IS NULL;
ENABLE TRIGGER trigKartrisCategories_DML ON dbo.tblKartrisCategories;

After running the above SQL, modify the table so it will not allow NULL values for that field, then try to log-in into the back-end.

By southwor - Wed 27 Jul 2011

Mohammad

Thanks for prompt reply. I will check this out.

We are rebuilding and re-installing to make sure we have latest scripts...

Thanks Southwor