Web Wiz Forums - SQL server problem...

Print Page | Close Window

SQL server problem...

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=9901
Printed Date: 08 April 2026 at 5:02am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL server problem...

Posted By: CeeWulf
Subject: SQL server problem...
Date Posted: 17 February 2004 at 2:50pm

I recently upgraded to 7.7a, and also switched from an Access database to MS SQL.

However, I discovered that I cannot post new comments to the board, nor can anyone new register with the board. However, for some reason, I can edit posts.

This is the error message I'm getting when I try to create a new member:

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

Cannot insert the value NULL into column 'Author_ID', table 'sherida_forums.dbo.tblAuthor'; column does not allow nulls. INSERT fails.

/starwars/forum/register.asp, line 954

This is the message I get when I try to post something:

ADODB.Recordset error '800a0cb3'

Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

/starwars/forum/post_message.asp, line 746

I've tried talking to my provider, but they haven't been able to help. I don't know if this is a problem with the database or the forum code, but I am in desperate need of help.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 17 February 2004 at 3:06pm

This is a problem with the database.

The database has not been created properly. Delete the database and run the msSQL_setup.asp file again.

-------------
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: Semikolon
Date Posted: 17 February 2004 at 3:09pm

try reinstall and replace all the forum files..

the first one looks like its not set to autonumber, the second one looks like a corrupt file or permission problems on the SQL Server

Posted By: CeeWulf
Date Posted: 17 February 2004 at 3:27pm

What about all the posts and members? Should I dump the database, then use the forum to re-create all the tables, then import the Access database?