Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Problem with MS SQL after upgrading		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

destinee
Starting Member

3 Posts
Posted - 07 February 2007 :  11:29:31  Show Profile
This is an example of the error mesage I get for every area of the forum that need needs input:

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

Cannot insert the value NULL into column 'REPLY_ID', table 'jhdcfrmbck.dbo.FORUM_REPLY'; column does not allow nulls. INSERT fails.

/forum/post_info.asp, line 1044

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 07 February 2007 :  11:38:59  Show Profile  Send ruirib a Yahoo! Message
That happens because you did not follow the advice given in this forum, on the process advised to upgrade from Access. You need to redo the upgrade process as explained here:

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=63884

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

destinee
Starting Member

3 Posts
Posted - 07 February 2007 :  18:23:41  Show Profile
Sorry, I did not explain myself properly. I upgraded from Snitz verion 3.4.05 to 3.4.06. I did not upgrade from Access to MS SQL. The database was SQL already.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 07 February 2007 :  22:01:34  Show Profile  Send ruirib a Yahoo! Message
A forum upgrade does not change the database like that. The error means the columns definitions in the database were changed, which is something our upgrade script does not do.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

destinee
Starting Member

3 Posts
Posted - 08 February 2007 :  09:43:28  Show Profile
Thank you for your help. What I did was to upgrade my backup database and I pointed to that in my config file. I have now reverted back to my original DB and upgraded it. Everything is fine now.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 08 February 2007 :  14:09:42  Show Profile  Send ruirib a Yahoo! Message
Glad all is working :).

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.15 seconds. Powered By: Snitz Forums 2000 Version 3.4.07