Database error - perhaps due to null value

Author	« Topic »
joetuesday Advanced Member 183 Posts Pre-sales questions only (More Details...)	Posted - 12/31/2023 : 14:34:26 Hello, I have a quick question. When I navigate to products.asp, the site is throwing the below error, probably due to something I've done wrong. Could anyone give me a hint on what field to examine in the DB to try to figure it out? I looked at the code for incfunctions.asp and the field looks like gdstatic but I am not sure. Thanks. Microsoft VBScript runtime error '800a005e' Invalid use of Null: 'cint' /vsadmin/inc/incfunctions.asp, line 1998 I am on Ecommerce PlusASP v7.6.2 Joe
joetuesday Advanced Member 183 Posts Pre-sales questions only (More Details...)	Posted - 12/31/2023 : 14:42:01 I examined the database table "products". There is a null value in one pID row. Would manually deleting it cause any issue? Thanks. Joe Joe
joetuesday Advanced Member 183 Posts Pre-sales questions only (More Details...)	Posted - 12/31/2023 : 16:30:49 I was able to fix it. I didn't delete the row because I was worried that might be some key somewhere that referenced it. Somehow I had a row in the database that had a couple of null values. This was my fault sometime in the past. I entered some placeholder value in the null fields and then manipulated the product through the control panel. Joe
	« Topic »