| Author |
 Topic Search  Topic Options
|
freebs 
Groupie
Joined: 04 March 2005
Location: South Africa
Status: Offline
Points: 53
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Problems installing
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
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
freebs
Groupie
Joined: 04 March 2005
Location: South Africa
Status: Offline
Points: 53
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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/
|
|
|
|
freebs
Groupie
Joined: 04 March 2005
Location: South Africa
Status: Offline
Points: 53
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
freebs
Groupie
Joined: 04 March 2005
Location: South Africa
Status: Offline
Points: 53
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
