| Author |
 Topic  |
|
webby4x4
Starting Member
44 Posts |
 Posted - 18 May 2008 : 17:25:45
|
Hi all - I've read through all of the other posts, yet I'm still having some issues when migrating from SQL 2K to 2005.
I've copied all tables over, corrected a few entries in the FORUM_CONFIG_NEW database, have setup the appropriate users and have updated the config.asp file. I can successfully run setup.asp on the site too.
However, when I browse to: http://209.62.126.245/discussions2/ , I get the following error:
Microsoft SQL Native Client error '80040e37'
Invalid object name 'FORUM_ACTIVE_USERS'.
/discussions2/inc_func_common.asp, line 121
Obviously, I'm running the Active Users mod, which works fine on the old SQL2000 server/site.
Line 121 = set rs = my_conn.execute (strSql)
This is for the active users mod.
Anyhow, I'm really at a loss here. All seems to be fine on the site and the SQL server, but I just can't get past this error.
Any suggestions?
Thanks so much in advance!!!
Rick< |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
webby4x4
Starting Member
44 Posts |
Posted - 18 May 2008 : 19:48:35
|
Hi Podge - thanks for the speedy reply.
The table is indeed there. I also truncated the table, and re-ran setup.asp. All *seemed* well, but alas, I still get the same error message.
I don't know what the "Active Users DBS" file is... could you elaborate? It's been many years since I installed that mod, and I can't even find the source anywhere (online or on my PC). [sheepish, embarassed grin].
thanks!
RW< |
 |
|
|
webby4x4
Starting Member
44 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
webby4x4
Starting Member
44 Posts |
Posted - 18 May 2008 : 21:10:51
|
Hi Podge, I can't believe I didn't think of that. ;) Here's the SQL: SELECT AU_LASTACTIVETIME FROM FORUM_ACTIVE_USERS WHERE MEMBER_ID = 1
Ruirib - Thanks for passing that on. This is a totally different version than I have now... mine is many years old. I'm going to install the newer version and see if that helps.
thanks,
Rick
< |
|
|
|
webby4x4
Starting Member
44 Posts |
Posted - 18 May 2008 : 21:14:24
|
oops... the instructions on the newer version of Active Users say: "WARNING: This mod is not compatible with mods based on older versions of the active users mod."
that's not good. :(< |
Edited by - webby4x4 on 18 May 2008 21:22:40 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
webby4x4
Starting Member
44 Posts |
Posted - 18 May 2008 : 21:56:04
|
| OK! Here goes! :)< |
|
|
|
webby4x4
Starting Member
44 Posts |
Posted - 18 May 2008 : 22:24:30
|
OK... I installed the new files and followed the instructions. I'm still getting the same error message. Note that Response.Write (strSql) is at the top, in red:
SELECT AU_LASTACTIVETIME FROM FORUM_ACTIVE_USERS WHERE MEMBER_ID = 1
Microsoft SQL Native Client error '80040e37'
Invalid object name 'FORUM_ACTIVE_USERS'.
/discussions2/inc_func_common.asp, line 121
quote:
Ruirib - You mentioned "you need to execute the dbs for the file, from the Mod Setup menu, in Admin Options.".
However, I can't get to the admin options, since the forum wont load. ;)
I really appreciate your help, guys! Any other thoughts on this one?
I'm SOOOOO close to cutting over my old site and getting onto my own server, I can taste it. Any help you can provide will be greatly appreciated.
thanks,
Rick< |
|
|
|
webby4x4
Starting Member
44 Posts |
Posted - 18 May 2008 : 22:50:33
|
OK, I just went through and removed every reference to the Active Users mod in all of my code. I'm now able to log into the forums, BUT... (there's always a but) now I'm getting the following error (with response.write of course):
SELECT T.TOPIC_ID FROM FORUM_TOPICS AS T INNER JOIN FORUM_CAL_EVENTS AS C ON T.TOPIC_ID = C.TOPIC_ID WHERE T.T_LAST_POST > '20080518161258' GROUP BY T.TOPIC_ID
Microsoft SQL Native Client error '80040e37'
Invalid object name 'FORUM_CAL_EVENTS'.
/discussions2/active.asp, line 289
So... here's the million dollar question:
Did somethign go horribly awry when I copied over my database to the new server??? I ask, because I'm guessing that if I remove all instances of the Calendar Mod, then some other mod will pop up just like it.
Again, thank you guys for you help! Its sincerely appreciated.
Rick< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 May 2008 : 03:18:22
|
| What it seems is that you did not run the mod setup for each of the mods you have installed. This makes me wonder how the DB transfer process went through. How did you do the database transfer? Maybe you will have other issues, if it was "faulty", as it seems...< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
webby4x4
Starting Member
44 Posts |
Posted - 19 May 2008 : 14:27:38
|
I did a simple copy of the tables from the old server, to the new server.
Rick< |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 May 2008 : 15:25:35
|
quote:
Originally posted by webby4x4
I did a simple copy of the tables from the old server, to the new server.
Rick
How did you copy the tables?
Podge's strategy would be an easy way to accomplish what you need.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Topic |
|
Topic Locked
