Print Page | Close Window

There are no Forums to display

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=26310
Printed Date: 03 April 2026 at 9:37am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: There are no Forums to display
Posted By: quinnjacobson
Subject: There are no Forums to display
Date Posted: 29 September 2008 at 10:07am
I recently switched servers and moved the forums/db (MSSQL). Everything seemed fine until I had several users emailing me telling me when they login they get the message, "There are no Forums to display" - and can't post or see anything. Even when they try to create new accounts, it still gives them problems?
 
Any ideas what's wrong here?

Thanks,
Quinn
www.studioQ.com/forum



Replies:
Posted By: WebWiz-Bruce
Date Posted: 29 September 2008 at 10:43am
You did not mention how you transferred the SQL Server data to the new server.

The transfer tools built into SQL Studio Manager will not work for transferring the database as they do not transfer the entire database schema.

What you need to do is have your old host create a backup of the database (a .bak file) which can then be used to recover the database on the new server.

Many hosts will give you online tools to do this, but if yours do not then you will need to contact them.


-------------
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: quinnjacobson
Date Posted: 29 September 2008 at 1:47pm
Hi, thanks for the response.
 
I updated and detached the MSSQL database from the old server and uploaded it (with the log) to the new server. They attached it (Enterprise manager) and I ran the mssql .asp file - I'm not sure why attaching a db wouldn't work in this case - going from MSSQL2000 to 2005?
 
It seems only new accounts and some old accounts are showing that there are "no forums" I thought it was a "cookie" problem, but it's far more serious. I don't have access to the old server - but I do have the data and log files. Will those work?


Posted By: WebWiz-Bruce
Date Posted: 29 September 2008 at 4:24pm
You say you ran the mssql .asp. Are you refering to the mssql setup file?

If so this is where you have gone wrong as this file should only ever be run on a new installation, otherwise it will create extra accounts and settings in the database which will mess it up, as is what has happened to your database.

Hopefully you made a backup of the detached database before you uploaded it to the new server as you will need to go back to that and restore it from that. This time DON'T run the mssql server setup file on it.


-------------
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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net