Web Wiz Forums - There are no Forums to display

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