| Author |
 Topic Search  Topic Options
|
Flyman30 
Groupie
Joined: 09 December 2004
Location: France
Status: Offline
Points: 99
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Cannot insert NULL
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
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
Flyman30
Groupie
Joined: 09 December 2004
Location: France
Status: Offline
Points: 99
|
Post Options
Thanks(0)
Quote Reply
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 
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
Flyman30
Groupie
Joined: 09 December 2004
Location: France
Status: Offline
Points: 99
|
Post Options
Thanks(0)
Quote Reply
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...
|
|
Flyman30
Groupie
Joined: 09 December 2004
Location: France
Status: Offline
Points: 99
|
Post Options
Thanks(0)
Quote Reply
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...
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
