Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - SQL server problem...
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL server problem...

 Post Reply Post Reply
Author
CeeWulf View Drop Down
Newbie
Newbie


Joined: 17 February 2004
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote CeeWulf Quote  Post ReplyReply Direct Link To This Post Topic: SQL server problem...
    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.




Edited by CeeWulf
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Semikolon View Drop Down
Senior Member
Senior Member


Joined: 09 September 2003
Location: Norway
Status: Offline
Points: 1718
Post Options Post Options   Thanks (0) Thanks(0)   Quote Semikolon Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
CeeWulf View Drop Down
Newbie
Newbie


Joined: 17 February 2004
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote CeeWulf Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.