Cannot insert NULL
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=20204
Printed Date: 11 April 2026 at 1:21pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Cannot insert NULL
Posted By: Flyman30
Subject: Cannot insert NULL
Date Posted: 07 June 2006 at 10:50am
|
Hello, I have a problem with the SQLServer base at my hosting (installation with a script mssql wwForum.bak) coming from my local Server. When one tries to be registered with the forum veiled the error message which one obtains: Server Error in Forum Application An error has occured 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 'Login_attempt', table 'heb788_.Patrick.tblAuthor'; column does not allow nulls. INSERT fails. I specify that that functions without errors on my local Server. In the administration if I try to create a new group I have this error message: Microsoft OLE DB Provider for SQL Server error '80040e2f' Cannot insert the value NULL into column 'Starting_group', table 'heb788_.Patrick.tblGroup'; column does not allow nulls. INSERT fails. /Forumsql/admin_group_details.asp, line 146 What to make?? Thank you |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 07 June 2006 at 11:27am
|
It looks like by using the SQL script method you are using has not created the database correctly and the default values for table columns have not been created. You should delete all the tables from your database and start again, using the supplied SQL Server database setup installation file. ------------- 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: Flyman30
Date Posted: 07 June 2006 at 11:40am
|
I can't cause i update from vers7 (Access) to vers8 (Access) --> to SQLserver on my Server, and they are many columns more ! On my Server it works fine.. Can y Update the default values for table columns ohter side ? I have no access to Entreprise Manager for my hosting  |
Posted By: WebWiz-Bruce
Date Posted: 07 June 2006 at 2:56pm
|
It sounds like your forum is created correctly on your own server, but you need to use Enterprise Manager to move the database to your hosts SQL Server. If you're host won't allow you to access you're SQL Server with Enterprise Manager then they are not a good web host and you should look for a new web host. ------------- 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: Flyman30
Date Posted: 07 June 2006 at 7:49pm
Yes you are true, they say it is for security... |
-boRg- wrote:Posted By: Flyman30
Date Posted: 08 June 2006 at 8:17pm
|
Finally i do like that : Alter Table Patrick.tblAuthor Add Constraint CK_no_post DEFAULT 0 FOR No_of_posts That works, but its still some lost default values and i can't change... |
Posted By: WebWiz-Bruce
Date Posted: 09 June 2006 at 9:13am
|
There are lots of columns that require default values. The only solution is to go through the database on your PC with the defaults values and re-create everyone of them on your web hosts SQL server. You could always try talking to your web host and see if they have a solution to this, if they don't allow Enterprise Manager they should put some other option in place for this type of issue. ------------- 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 |