https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 14:47:27 +0000 Fri, 09 Jun 2006 09:13:37 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20204 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/cannot-insert-null_topic20204_post108726.html#108726 Author: WebWiz-Bruce
Subject: 20204
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.
]]> Fri, 09 Jun 2006 09:13:37 +0000 https://forums.webwiz.net/cannot-insert-null_topic20204_post108726.html#108726 https://forums.webwiz.net/cannot-insert-null_topic20204_post108702.html#108702 Author: Flyman30
Subject: 20204
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...
]]> Thu, 08 Jun 2006 20:17:19 +0000 https://forums.webwiz.net/cannot-insert-null_topic20204_post108702.html#108702 https://forums.webwiz.net/cannot-insert-null_topic20204_post108594.html#108594 Author: Flyman30
Subject: 20204
Posted: 07 June 2006 at 7:49pm

-boRg- wrote: 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.

Yes you are true, they say it is for security...
]]> Wed, 07 Jun 2006 19:49:08 +0000 https://forums.webwiz.net/cannot-insert-null_topic20204_post108594.html#108594 https://forums.webwiz.net/cannot-insert-null_topic20204_post108580.html#108580 Author: WebWiz-Bruce
Subject: 20204
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.
]]> Wed, 07 Jun 2006 14:56:25 +0000 https://forums.webwiz.net/cannot-insert-null_topic20204_post108580.html#108580 https://forums.webwiz.net/cannot-insert-null_topic20204_post108568.html#108568 Author: Flyman30
Subject: 20204
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
]]> Wed, 07 Jun 2006 11:40:38 +0000 https://forums.webwiz.net/cannot-insert-null_topic20204_post108568.html#108568 https://forums.webwiz.net/cannot-insert-null_topic20204_post108567.html#108567 Author: WebWiz-Bruce
Subject: 20204
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.
]]> Wed, 07 Jun 2006 11:27:45 +0000 https://forums.webwiz.net/cannot-insert-null_topic20204_post108567.html#108567 https://forums.webwiz.net/cannot-insert-null_topic20204_post108566.html#108566 Author: Flyman30
Subject: 20204
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 ]]> Wed, 07 Jun 2006 10:50:11 +0000 https://forums.webwiz.net/cannot-insert-null_topic20204_post108566.html#108566