Ask A Question Page Broken with Error

Author	« Topic »
xxcfdrr Advanced Member USA 231 Posts	Posted - 11/25/2020 : 05:00:58 I just noticed the 'Ask A Question' page doesn't work. Error: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'ssdenyid', table 'xxxdbnamexxx.dbo.multibuyblock'; column does not allow nulls. INSERT fails. /emailfriend.asp, line 68 Using Ecommerce PlusASP v7.2.3
Vince Administrator 42766 Posts	Posted - 11/25/2020 : 07:30:18 The column ssdenyid in the multibuyblock table should have the "IDENTITY" attribute which is where an index is automatically assigned when a row is added to the table. As it seems to have lost the IDENTITY attribute, nothing is added to that column (NULL) when adding a row so the DB is complaining. Is this something you or your host can fix? Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
	« Topic »