| Author |
 Topic  |
|
|
preg-cal
Starting Member
11 Posts |
 Posted - 15 January 2009 : 15:09:32
|
Interesting problem,
We ported our Forums DB from an old shared hosting provider to our new dedicated server about 2 years ago now.
Now that we are doing more work around the forums, we have noticed that there seem to be many tables which have not come across – even though the forums are actually working.
So here is my question – how can we get the DB structure back into place, and then get all the posts and member info into the DB?
We are currently using 3.4.05 – would doing an upgrade to 3.4.06 fix this and recreate the correct DB structure?
< |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
|
|
preg-cal
Starting Member
11 Posts |
Posted - 15 January 2009 : 17:00:38
|
One of the issues we were having was when we were trying to archive or delete topics wew were getting this message;
Microsoft OLE DB Provider for SQL Server error '80040e37'
Invalid object name 'FORUM_A_REPLY'.
/forums/admin_forums.asp, line 489
see topic: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=67845
we had to recreate the FORUM_A_REPLY table and then it worked.
Other issues we are having include:
* Archiving is still not 100%
* Running the Mod setup tells me I need to be a forum admin - yet, I am the forum admin
We suspect that their are probably more issues, and if there is a way to export all the forums and topic posts, members, etc into a clean setup that would probably eliminate lots of poking around.< |
 |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 15 January 2009 : 17:07:43
|
| When you moved your forum, did you let setup.asp create the tables before you moved the data?< |
|
|
|
preg-cal
Starting Member
11 Posts |
Posted - 15 January 2009 : 17:11:09
|
no - it was a complete DB move, so backup DB, then restore on new server.
But somewhere between going from SQL2000 to SQL 2005 tables went missing
< |
Edited by - preg-cal on 15 January 2009 17:16:36 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 16 January 2009 : 03:34:49
|
quote:
Originally posted by preg-cal
no - it was a complete DB move, so backup DB, then restore on new server.
But somewhere between going from SQL2000 to SQL 2005 tables went missing
Never heard of that before, I have done hundreds of backup/restores from sql 2000 to 2005 and never lost a single record let alone a table. Did you look in the db to ensure the table was missing, or was it an error message that said it was missing ? SQL tables have owners and if the owner has changed or become orphaned in the restore, the user you use may not be able to see the tables even though they are there.< |
|
|
| |
Topic |
|
Topic Locked
