| Author |
 Topic Search  Topic Options
|
iSec 
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Page can’t be displayed: msSQL_server_update.asp
Posted: 28 March 2006 at 3:15pm |
Edit: I went ahead and uploaded the new forum version then performed the db conversion... at last, he conversion page gave me page cannot be displayed and then when I try acessing the forum I get: Server Error in Forum Application
An error has occured while executing SQL query on database.
Please contact the forum administrator.
Support Error Code:- err_SQLServer_get_active_topics
File Name:- active_topics.asp
Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid column name 'Icon'.
Edited by Info_Tech - 28 March 2006 at 4:23pm
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 March 2006 at 4:23pm |
|
The version of the Upload Tool you have requires that it is placed in with the other version 8 files in the main forum directory.
However, I have just created a new version that can run in it's own directory.
You can download this new version from the Upgrade Tool page, I've simply changed the download file over to the newer version.
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 March 2006 at 4:25pm |
Opss, you skipped me....
I edited my last post ..I'll re-try with the updated tool.
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 March 2006 at 5:22pm |
|
How long does the conversion tool take to finish? It already took about 30 minutes and still goin... is this normal?
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 March 2006 at 5:28pm |
|
It all depends on how big your forum is.
Also for SQL Server it will depend on how fast the SQL Server is and the network speed.
It is the part that populates the new database that can take time, for each topic the Thread_ID of the first and last posts need to be read from the tblTopics table then that data needs to be placed into the tblTopics table. This is some de-normalisation on the database to speed up performance with SQL queries.
It took around 6 minutes on this forum to do with around 15,000 topics, but the SQL Server is installed locally so I didn't have the issue of network load that can slow things down and the server is a dedicated server so web sever load was also not an issue.
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 March 2006 at 5:35pm |
I see, I'll give it another 30 minutes and see... I just hope that it is doing the right thing ... I've been up since last night working on it  .. Does it matter which forum version is uploaded...because I still have 7.9x on the server while the conversion is going on...and the common file and default file are both removed.
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 March 2006 at 5:41pm |
|
As long as the common.asp file is removed from the old version it will mean that no-one can access the database while the precess is going on.
Once the process is complete you can not use your version 7.x anymore.
I'm surpriesed how long it is taking, but you haven't said what size your database is and if it is on a slow server or network.
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 March 2006 at 5:45pm |
|
If I recall, the forum has about 40,000 topics... The server that hosts the db is not slow...
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
|
