| Author |
 Topic  |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
chp
Starting Member
16 Posts |
 Posted - 19 December 2008 : 13:01:29
|
| OK, I ran Gremlin's code to make dbo owner of the tables, and in Enterprise Manager the dbo is still not showing up as the owner of those tables! Strange and stranger. When I point my config file to the new database I still get the Invalid object name 'FORUM_MEMBERS' error.< |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
chp
Starting Member
16 Posts |
Posted - 19 December 2008 : 13:24:50
|
Yes - I did all these changes within the database that was migrated onto my dedicated server, using Enterprise Manager. I even made sure I had the right database selected before I ran the query.
I'm wondering if I should run setup.asp again so we can see the details about those duplicate tables that are being created? I don't want to mess up anything even more than it already is, but I'm running out of ideas. I'm also very reluctant to do anything that might inadvertently mess up the database that IS still working and being used (hosted elsewhere).< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 19 December 2008 : 13:40:12
|
chp, if you have remote desktop access to your dedicated server, if you create me an acount and email me login details I will logon and fix the problem if you wish, will probably be a lot quicker than bouncing round posts in the forum  < |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 December 2008 : 13:42:27
|
quote:
Originally posted by HuwR
chp, if you have remote desktop access to your dedicated server, if you create me an acount and email me login details I will logon and fix the problem if you wish, will probably be a lot quicker than bouncing round posts in the forum
That does sound like a great idea .< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
chp
Starting Member
16 Posts |
Posted - 19 December 2008 : 14:04:28
|
| You guys are just too much. THANK YOU. HuwR, be on the lookout of an email!< |
|
|
|
chp
Starting Member
16 Posts |
Posted - 19 December 2008 : 16:01:43
|
| HuwR, I've emailed you with all the details about an hour ago, and I eagerly await your insight as to what could possibly be going wrong. Thank you again.< |
|
|
|
chp
Starting Member
16 Posts |
Posted - 20 December 2008 : 12:08:51
|
I wanted to send a mighty THANK YOU shout-out to Huw for helping me resolve this issue.
For anybody with similar problems, the fix was just what he suggested here, to modify the strTableprefix values in config.asp and change the db owner to the table name, so that instead of FORUM_ it said [dbo].FORUM_ (where DBO was the name of the person who owned those tables). He posted the fix here but had forgotten that the dbo had to be in brackets.
Now that the new database is connected, I noticed that my server disk queue length is pretty much constantly maxed out at the very top of the chart. Could this be at all related to that fix, or is it an issue of needing to add more RAM/ROM to the box? If you'd rather I post separately about this, let me know. I just thought I'd note it here since it could be related to the same issue. Not sure.
Thanks you guys!
< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
