| Author |
 Topic  |
|
|
Mark Minasi
Starting Member
9 Posts |
 Posted - 21 October 2005 : 17:52:09
|
Similar to a recent post but I may have more info...
I'm running a Snitz forum (version 3.4.04) and am trying to move it from one system to another. The old system is a 2000 box w/IIS 5.0 and SQL Server 2000, the new one is a 2003 box with IIS 6.0 (ASP scripts are enabled) and SQL Server 2000. (Only other difference is that I have disabled network protocols, which seems reasonable as the IIS 6.0 runs on the same computer as does the SQL Server.)
I backed up the database from system one, moved the backup to system two and restored it. All seems well; for example, the following osql run works as expected:
1> use forumdb
2> select left(name,40) from sysobjects where type='U'
3> go
----------------------------------------
FORUM_TOTALS
FORUM_ACTIVE_USERS
FORUM_POLLS
FORUM_POLL_VOTES
dtproperties
FORUM_A_REPLY
FORUM_A_TOPICS
FORUM_MEMBERS_PENDING
FORUM_ALLOWED_MEMBERS
FORUM_CATEGORY
FORUM_GROUP_NAMES
FORUM_CONFIG_NEW
FORUM_FORUM
FORUM_GROUPS
FORUM_MEMBERS
FORUM_MODERATOR
FORUM_NAMEFILTER
FORUM_REPLY
FORUM_SUBSCRIPTIONS
FORUM_BADWORDS
FORUM_TOPICS
(21 rows affected)
Running this on the old server shows a match.
I then copied the \Forum folder from my old Web server to the default directory of my new Web server. (It's not in c:\inetpub\wwwroot because I've moved that default directory to another folder but it's the same idea -- defaultdirectory\forum.) I have verified that there are the same number of objects in each folder.
I adjusted the connection string for the new server and, just to check that things were working, temporarily told it to use sa and the sa password.
I then ran the forum/setup.asp file and got the message that the forum setup was completed without errors.
Trying to enter the forum, however, gets this error message:
Microsoft OLE DB Provider for SQL Server error '80040e37'
Invalid object name 'FORUM_ACTIVE_USERS'.
/forum/inc_func_common.asp, line 58
The next logical move was to fire up osql (using the same credentials that I told Snitz to use) and see what I could do about it. I tried to dump the first row of FORUM_ACTIVE_USERS and got an error like so:
1> use forumdb
2> select top 1 * from FORUM_ACTIVE_USERS
3> go
Msg 208, Level 16, State 1, Server WEB2, Line 2
Invalid object name 'FORUM_ACTIVE_USERS'.
Aha, I thought -- the database was damaged somehow on the way over. So I went to the working, functioning Snitz forum system at x220.win2ktest.com/forum and got the very same response.
To make matters worse, using Enterprise Manager to examine FORUM_ACTIVE_USERS turns up no errors on X220, the functioning Snitz forum.
So I'm stumped. Why would I get an "invalid object name" on a table that's clearly working? Thanks in advance for any ideas and help.
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Mark Minasi
Starting Member
9 Posts |
Posted - 21 October 2005 : 18:18:26
|
I JUST ran across that and was about to post...
We had our system set up so that the connection string referred not to sa but to a user "fuser."
It turned out that SQL liked
select top 1 * from fuser.forum_active_users
So my next question was... now that the select statement works on osql, why doesn't Snitz work?
|
 |
|
|
Mark Minasi
Starting Member
9 Posts |
Posted - 21 October 2005 : 18:36:52
|
Now I think I see what's going on.
In creating the mod as "forumuser" I'm getting in trouble with an "sa" connection string.
I need a login named "forumuser" but it won't let me create one named "forumuser" and associate it with a database user "forumuser" because the ownership information for the "forumuser" user came with the database restore... but I didn't have a login named "forumuser."
Dunno quite what to do next but I'm working on it. |
|
|
|
Mark Minasi
Starting Member
9 Posts |
Posted - 21 October 2005 : 18:57:16
|
Okay, I got it, I think.
A table was, for some reason, not owned by dbo but the fuser user. So I seized ownership back to dbo like so:
1>use forumdb
2>exec sp_changeobjectowner 'forumuser.forum_active_users','dbo'
3>go
Now it's working. Hope this helps someone. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 21 October 2005 : 23:42:35
|
Hi Mark, is the moved version online now?
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
| |
Topic |
|
Topic Locked
