Web Wiz Forums - Error:cannot insert null value

Print Page | Close Window

Error:cannot insert null value

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=31108
Printed Date: 30 March 2026 at 5:41am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error:cannot insert null value

Posted By: dizzyd123
Subject: Error:cannot insert null value
Date Posted: 23 October 2014 at 10:39am

I have Web Wiz forum 10.15 installed and when I try to update any of the admin Security Filters I get a ASP error 500. In the logs I see an error updating the ID field in the table in the database.

The error I am getting for updating the spam filter is below in Spanish

POST /forum/admin_spam_filter_add.asp |77|80040e2f|No_se_puede_insertar_el_valor_NULL_en_la_columna_'Spam_ID'__tabla_'ivipaises_foro_nuevo.dbo.tblSpam'._La_columna_no_admite_valores_NULL._Error_de_INSERT

I have similar error for the IP address filter.

I have upgraded the installation to 11.01 and the error is the same, so I guess the problem is with the database.

Any Ideas

Paul

Replies:

Posted By: dizzyd123
Date Posted: 23 October 2014 at 11:12am

This has been solved, it was a problem with the properties of the ID colunms in the Table, you need to have Is Identity set to yes.