Print Page | Close Window

Some SQL error´s

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=25741
Printed Date: 03 April 2026 at 6:19am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Some SQL error´s
Posted By: Andreas.E
Subject: Some SQL error´s
Date Posted: 20 May 2008 at 7:24am
Hi all
Have some small SQL error’s I have to iron-out... I know it’s something in my DB and probably caused by the converter-software. But is there a solution?

Web Wiz Version: 9.50
DB Version: SQL
Plattform: MSSQL Server 2005


Page: http://xxxx.xxxxxx.xxx/register.asp?FID=0
Happens: When you only enter the required fields in the registration page.
Error:
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

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'.



Page: http://xxxx.xxxxxx.xxx/admin_web_wiz_forums_configuration.asp
Happens: When im trying to change any, or some of the fields.
Error:

Microsoft OLE DB Provider for SQL Server error '80040e2f'

The UPDATE statement conflicted with the CHECK constraint "SSMA_CC$tblConfiguration$NewsPad_URL$disallow_zero_length". The conflict occurred in database "terrangb", table "dbo.tblConfiguration", column 'NewsPad_URL'.

/forum/admin_web_wiz_forums_configuration.asp, line 141


Many thanks Smile



Replies:
Posted By: WebWiz-Bruce
Date Posted: 20 May 2008 at 8:57am
You mention that you use converter software, but not what you were converting from?


-------------
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: Andreas.E
Date Posted: 20 May 2008 at 9:12am
Sorry Bruce Embarrassed ... I converted from Access to MSQL with the Microsoft SQL Server: SQL Server 2005 Migration tool


Posted By: WebWiz-Bruce
Date Posted: 20 May 2008 at 9:26am
It looks like it may not have recreated allot of the default values.

I have found the best way to migrate from Access to SQL Server for Web Wiz Forums is to use the Upsize Wizard in Access 2007 to create a new database on the SQL Server.

Have used this method 100's of times with 99% success rate. Only once had an issue with a large 200MB Access database and had to remove some posts in order to get it upsize correctly, otherwise it would be 100% success rate.


-------------
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: johnnysqueeb
Date Posted: 24 May 2008 at 5:02am
Where are these default values set? I use SQL Server 2000.
 
I recently switched over to your forums due to security issues with my old forums and SQL Injection attacks. I was copying posts over from the old forum, a bunch of people had registered and I activated their accounts and we had some new posts put in to the new forum and then the database was attacked, again. The tables which store the data for the Web Wiz forums were impacted, as the attack compromises the entire database. I had backed up a copy of all the web wiz forum tables locally, and copied them back to the server, but am receiving this error now whenever a newbie registers:
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

Error details:-
Microsoft OLE DB Provider for SQL Server
Cannot insert the value NULL into column 'Newsletter', table 'tblAuthor'; column does not allow nulls. INSERT fails.
 

Any help here would be greatly appreciated as I do not know where to set the defaults or where to even check to see if their not set...
 
Thanks!


Posted By: Andreas.E
Date Posted: 26 May 2008 at 9:00am

As going back and do the convert again, but this time in Access 2007 is not an option, i found a solution, work-around.

 

 

Page: http://xxxx.xxxxxx.xxx/register.asp?FID=0
Happens: When you only enter the required fields in the registration page.
Error:
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

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'.

 

My solution:
Change line 1673 in the Register.asp file so that “Private” is always selected/checked if you don’t select male or female. Solved my problem with getting the Zero error.

 

 

 

Page: http://xxxx.xxxxxx.xxx/admin_web_wiz_forums_configuration.asp
Happens: When im trying to change any, or some of the fields.
Error:

Microsoft OLE DB Provider for SQL Server error '80040e2f'

The UPDATE statement conflicted with the CHECK constraint "SSMA_CC$tblConfiguration$NewsPad_URL$disallow_zero_length". The conflict occurred in database "terrangb", table "dbo.tblConfiguration", column 'NewsPad_URL'.

/forum/admin_web_wiz_forums_configuration.asp, line 141

 

My solution:
The easiest way around this problem is to click “checked”, that you have the NewsPad installed, that cancelled the Zero error in SQL.




Posted By: jacobisrael
Date Posted: 11 September 2008 at 12:13am

Is there any other way to solve this problem other than the way described here?

If not, exactly what specific change needs to be made to register.asp (it doesn't seem to be on line 1673)?

Nobody can register without getting the following error message:

 

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

Error details:-
Microsoft OLE DB Provider for SQL Server
Cannot insert the value NULL into column 'Author_ID', table 'forum.dbo.tblAuthor'; column does not allow nulls. INSERT fails.




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net