Gender - Error if left to private
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=29785
Printed Date: 01 April 2026 at 2:51am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Gender - Error if left to private
Posted By: AndreasE
Subject: Gender - Error if left to private
Date Posted: 19 September 2011 at 10:42pm
|
On a new registration where you don't select "male" or "female" you will receive the following error msg on my web-wiz config. Server Error in Forum Application An error has occurred while writing to the database. Please contact the Forum Administrator. Support Error Code:- err_SQLServer_register_USR File Name:- register.asp Forum Version:- 10.03 Error details:- Microsoft OLE DB Provider for SQL Server The INSERT statement conflicted with the CHECK constraint "SSMA_CC$tblAuthor$Gender$disallow_zero_length". The conflict occurred in database "terrangb", table "dbo.tblAuthor", column 'Gender'. On my earlier installation ver 8-9 I have altered the code so that Gender never is a zero length if you leave it to "private". But Im not keen to do that any more  Best regards Andreas Eriksson |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 20 September 2011 at 9:38am
|
You would need to change back your modified database so that the 'Gender' field in the 'tblAuthor' table allows 'null' values. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: AndreasE
Date Posted: 20 September 2011 at 9:54am
Will do that, but I have never modified my database to allow anything other then default... it´s table content was generated by the forum in its time back in 2006.
|
WebWiz-Bruce wrote: