Problems installing
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=29557
Printed Date: 01 April 2026 at 4:40am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Problems installing
Posted By: freebs
Subject: Problems installing
Date Posted: 23 July 2011 at 7:16pm
I have V9 and have just installed V10 on my server under a directory called new instead of forum. When I try and set up, it goes straight to the default page, with nowhere for me to upgrade. Even if I type in setup.asp, if still goes back to the forum. Any help appreciated
URL is
http://www.e-dirt.co.zaew - http://www.e-dirt.co.za/new
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 23 July 2011 at 7:53pm
Make sure you have replaced all the files including those in the database folder with those form the latest version.
-------------
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: freebs
Date Posted: 23 July 2011 at 7:58pm
I created a new directory to install it into as I still want to run the old one while I test and run the new version. The old version is still running.
|
Posted By: WebWiz-Bruce
Date Posted: 23 July 2011 at 8:06pm
It sounds t me that you have either edited manually the files in the database folder or copied them over from your old installation, thus preventing the setup/upgrade wizard from running.
Make sure you follow the upgrade intructions on the page below and do not edit or change the files in the database folder:-
http://www.webwiz.net/web-wiz-forums/kb/" rel="nofollow - http://www.webwiz.net/web-wiz-forums/kb/
-------------
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: freebs
Date Posted: 23 July 2011 at 9:24pm
Thank you Bruce, No Idea what happened, I re uploaded and it went fine. Now I have this problem when trying to read a post. I can see everything else, just cannot read individual posts.
Server Error in Forum Application
An error has occurred while executing SQL query on database.
Please contact the Forum Administrator.
Support Error Code:- err_SQLServer_get_topic_posts_data
File Name:- forum_posts.asp
Forum Version:- 10.01
|
Posted By: WebWiz-Bruce
Date Posted: 23 July 2011 at 11:54pm
Have seen this happen before with upgrades if there is not enough file space for the SQL Server Database during the upgrade.
you would need to go back to the version 9 backup database you created before the upgrade and restore the database from that. once you have done this start the install/upgrade again, but this time make sure that there is adequate diskspace for the database files.
-------------
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: freebs
Date Posted: 25 July 2011 at 5:53pm
I have restored my database and then tried again. I get the message everything is complete, the when i go to the forum homw page, everything worksd but I cannot see the posts. Same error as before. I made sure there was enpough space for adding aditional tables etc, but no luck. The old forum is still working properly. I am using an MS2005 SQL database.
Please help.
Server Error in Forum Application
An error has occurred while executing SQL query on database.
Please contact the Forum Administrator.
Support Error Code:- err_SQLServer_get_topic_posts_data
File Name:- forum_posts.asp
Forum Version:- 10.01
|
Posted By: WebWiz-Bruce
Date Posted: 25 July 2011 at 5:57pm
The problem is that when it tries to add the new fields to the Thread table is that if there is not enough space to complete the operation the database will not return an error, so it looks like the upgrade has gone through correctly.
If you have a large database you need to make sure you have at least 25% space for your primary file group and that your log file is at least 50% the size of your primary file group.
The database can be shrunk after the upgrade but adding extra fields to a large table like the Thread table that holds all the posts will need allot of temporary space to add the extra fields.
If there is not enough space to create the new fields in the thread table due to the database not returning an error the first you will know is when you try and view a post, it will not display, exactly like what you describe.
-------------
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: freebs
Date Posted: 25 July 2011 at 6:10pm
OK Thank you very much. I will make sure it is at least double in size and try again.
|
Posted By: WebWiz-Bruce
Date Posted: 25 July 2011 at 6:14pm
It's the following fields in the table tblThread that have problems being created if you are limited on diskpsace, due to the size of the table as it stores all the posts:-
Table tblThread - New fields for SQL Server:-
1. Answer - datatype = bit - default value = 0
2. Thanks - data type = integer - default value = 0
If you are comfortable with database you could have a go at crating these two fields manually.
-------------
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: freebs
Date Posted: 26 July 2011 at 8:06pm
|
Thanks you Bruce, It worked like a charm
|
|