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: General / Classic ASP versions(v3.4.XX)
 Error 80040E37 after upgrade		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

bulldale
Starting Member

14 Posts
Posted - 04 February 2005 :  18:00:58  Show Profile
I am trying to update to the current version from 3.4.03, and am receiving an error when I "Check Installation" after upgrade.

The error code is: 80040E37

This is the rest of the message:

Invalid object name 'FORUM_TOPICS'

strUpdateSql: UPDATE FORUM_TOPICS SET T_STICKY = 0 WHERE (T_STICKY IS NULL)

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

Invalid object name 'FORUM_CONFIG_NEW'.

/forums/setup.asp, line 4506

I'm not sure exactly what happened, the forums are up, and everything is working correctly, just trying to make sure nothing happens down the line as far as upgrading the database.

Any help would be greatly appreciated!

Thanks!

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 04 February 2005 :  20:15:35  Show Profile  Send ruirib a Yahoo! Message
Do you have any way to have a look at the database? Enterprise Manager, for example?

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

bulldale
Starting Member

14 Posts
Posted - 07 February 2005 :  09:22:39  Show Profile
Yes, I can view the SQL Database in Enterprise Manager. I can look at it in SQL Query Analyzer also, though I'm not too familiar with it.

We have one more forum to upgrade, which is the larger of the two and would like to get this to work correctly first.

Is this forum going to experience problems down the line if we don't upgrade the database, and only upgrade to the newest version?
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 07 February 2005 :  10:06:09  Show Profile  Send ruirib a Yahoo! Message
The problem you're facing now is, quite likely, a table ownership problem. Can you check who owns the tables with EM?

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

bulldale
Starting Member

14 Posts
Posted - 07 February 2005 :  10:57:04  Show Profile
Fixed. I was logged on with the Admin account that we use for most databases in SQL. For some reason when checking EM it was a different account!

Thanks!!
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 07 February 2005 :  11:10:55  Show Profile  Send ruirib a Yahoo! Message
You're welcome.

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.5 seconds. Powered By: Snitz Forums 2000 Version 3.4.07