Active Topics issue after DB migration

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
iSec Members Profile Find Members Posts Senior Member Joined: 13 February 2005 Status: Offline Points: 1140	Post Options Post Reply Quote iSec Report Post Thanks(0) Quote Reply Topic: Active Topics issue after DB migration 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

iSec Members Profile Find Members Posts Senior Member Joined: 13 February 2005 Status: Offline Points: 1140	Post Options Post Reply Quote iSec Report Post Thanks(0) Quote Reply 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 10 March 2008 at 4:27pm
	Check the user permissions in the same way as well.
	Web Wiz Forums Hosting ASP.NET Web Hosting

iSec Members Profile Find Members Posts Senior Member Joined: 13 February 2005 Status: Offline Points: 1140	Post Options Post Reply Quote iSec Report Post Thanks(0) Quote Reply 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

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.