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  |
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  ... 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 My solution: Page:
http://xxxx.xxxxxx.xxx/admin_web_wiz_forums_configuration.asp My solution: |
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 |