Active Topics issue after DB migration
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=25417
Printed Date: 03 April 2026 at 10:59pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Active Topics issue after DB migration
Posted By: iSec
Subject: Active Topics issue after DB migration
Date Posted: 09 March 2008 at 11:19am
|
Database Type: MS SQL
SQL Server version: 2000
Forum Version: 9.08
Issue: After migrating the database from one SQL server to another, my forum's Active Topics page shows some forum sections being repeated. On the default page it shows the forums ok (not repeated) but it happens only on active_topics.asp as shown below:
 What I have done: backed up the original database on the old server one more time, and restored it again on the new server but still no solve. I have also replaced the active_topics.asp file with a fresh one... and still having the same problem.
Your help is greatly appreciated.
------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 10 March 2008 at 9:02am
|
These types of issues are often coursed by incorrect permission settings where permissions in the db are repeated. To fix this log into the admin area and go through your forums re-submitting them so that the permissions are reset. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: iSec
Date Posted: 10 March 2008 at 3:55pm
|
Bruce, Thanks for the response. I tried the above.. it fixed one of two troubled sections... i re-did it but the second section is still being repeated... is there anything else i can try to fix it? ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: WebWiz-Bruce
Date Posted: 10 March 2008 at 4:27pm
|
Check the user permissions in the same way as well.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: iSec
Date Posted: 10 March 2008 at 5:32pm
|
Bruce, Thank you again... I did the samething with permissions group by group but it did not help...
but here is how I fixed it: I created a new forum. I then batch-moved all topics from the troubled forum over to the newly created forum... i re-synched topics/posts... then deleted the troubled forum, then re-created it... and moved back all topics to it.
This fixed it... but i only thought of this fix after you advised me that it had to do with permissions... so thank you very much :) ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |