Web Wiz Forums - How 2 upgade from 7.01 to 7.5

Print Page | Close Window

How 2 upgade from 7.01 to 7.5

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=6136
Printed Date: 29 March 2026 at 1:25pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: How 2 upgade from 7.01 to 7.5

Posted By: WebWiz-Bruce
Subject: How 2 upgade from 7.01 to 7.5
Date Posted: 03 October 2003 at 9:06am

REMEMBER BACK-UP ALL FILES FIRST INCASE THINGS DON'T GO TO PLAN!!!!

All Users
Skins and Language files for version 7.01 will NOT work with version 7.5, some mods for 7.01 may also not run.

Upgarding Access Version
Upgrading from version 7.01 to 7.5 Access version is straight forward. Just replace the old files with the new ones keeping the same database file. In the Access database you will have to increase the size of the field Browser to 20 in the table tblActiveUsers.

Upgrading MS SQL Server Version
Upgrading from version 7.01 to 7.5 MS SQL Server version is a little more complcated. You need to replace all the old files with the new ones. You then also need to change the stored procedure wwfSpLastAndFirstThreadAuthor, in the SQL Enterprise Manager to the following:-

CREATE PROCEDURE [dbo].[wwfSpLastAndFirstThreadAuthor] (


@lngTopicID int 


)  


AS 


SELECT tblThread.Thread_ID, tblThread.Author_ID, tblThread.Message, tblThread.Message_date, tblAuthor.Username 


FROM tblAuthor, tblThread 


WHERE tblAuthor.Author_ID = tblThread.Author_ID AND tblThread.Topic_ID = @lngTopicID 


ORDER BY tblThread.Message_date ASC;


GO

You will also need to add the following new stored procedure if you wish to use the SQL Server Stats page in the admin section. The new SP is:-

CREATE PROCEDURE [dbo].[wwfSpDBinfo] As 


Declare @low int


Declare @dbsize dec(10,2)


Declare @dbpath nvarchar(100)


Declare @logpath nvarchar(100)


Declare @dbfilesize dec(10,2)


Declare @logfilesize dec(10,2)


Declare @maxdbfilesize dec(10,2)


Declare @maxlogfilesize dec(10,2)


 


--Minimum Database Size


select @low = low from master.dbo.spt_values


            where type = N'E' and number = 1


--Calculation of current Database Size in MB


select @dbsize = (convert(dec(15),sum(size)) *  @low  / 1048576)


from [sysfiles]


--Actual File Size of Log and Data File


Select TOP 1 @dbpath = [filename] from [sysfiles] where groupid = 1


Select TOP 1 @logpath = [filename] from [sysfiles] where groupid = 0


Select @dbfilesize =  convert(dec(10,2),sum([size]))/128 from
[sysfiles] where [filename] = @dbpath     --in MB


Select @logfilesize = convert(dec(10,2),sum([size]))/128 from [sysfiles] where [filename] = @logpath   --in MB


Select TOP 1 @maxdbfilesize = convert(dec(10,2),[maxsize])/128 from [sysfiles] where [filename] = @dbpath


Select TOP 1 @maxlogfilesize = convert(dec(10,2),[maxsize])/128 from [sysfiles] where [filename] = @logpath


If @maxdbfilesize = (-.01) Set @maxdbfilesize = -1


If @maxlogfilesize = (-.01) Set @maxlogfilesize = -1


 


---Creating Output Table


select     @dbsize Databasesize, @dbpath DataLocation , @logpath LogLocation, 


    @dbfilesize DatabaseFileSize, @logfilesize Logfilesize,


    @maxdbfilesize MaxDBSize, @maxlogfilesize MazLogSize,


    ServerProperty('edition') Edition, 


    CASE ServerProperty('IsCluster') 


     WHEN 0 THEN 'No Cluster'


     WHEN 1 THEN 'Cluster'


      ELSE  'No Cluster/Unknown' 


    END Cluster,


    CASE ServerProperty('License_Type')


     WHEN 'PER_SEAT' THEN 'Seat Licensing (' + Convert(nvarchar(5),ServerProperty('NumLicenses')) + ')'


     WHEN 'Per_Processor' THEN 'Processor Licensing
(' + Convert(nvarchar(5),ServerProperty('NumLicenses')) + ')'


     ELSE 'Licensing Disabled / Unknown'


    END Licensing,


    ServerProperty('ProductLevel') PLevel


GO

You will also need to increase the size of the field Browser in the table tblActiveUsers to 20.

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

Replies:

Posted By: crusad3r
Date Posted: 03 October 2003 at 10:14am

What do you do if you do not have access to the ServerProperty() function.

Posted By: simpson
Date Posted: 03 October 2003 at 10:26am

-boRg- wrote:

All Users
Skins and Language files for version 7.01 will NOT work with version 7.5, some mods for 7.01 may also not run.

But you can copy/paste your old language file into the new one above the "New to 7.05", right?

Posted By: WebWiz-Bruce
Date Posted: 03 October 2003 at 10:34am

Yes simpson that should work.

Sorry crusad3r if the SQL DB Stats stored procedure won't run then you won't be able to view the SQL srever stats, but it's more eye candy then a feature that you need.

-------------
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: crusad3r
Date Posted: 03 October 2003 at 12:06pm

-boRg- wrote:

Yes simpson that should work.

Sorry crusad3r if the SQL DB Stats stored procedure won't run then you won't be able to view the SQL srever stats, but it's more eye candy then a feature that you need.

Yea I know but I'm a tweaker. Could I replace the values that it is getting with the GetServerPerperty with somthing static?

for instance replace

    ServerProperty('edition') Edition,
    CASE ServerProperty('IsCluster')
    WHEN 0 THEN 'No Cluster'
    WHEN 1 THEN 'Cluster'
     ELSE 'No Cluster/Unknown'
    END Cluster,
    CASE ServerProperty('License_Type')
    WHEN 'PER_SEAT' THEN 'Seat Licensing (' + Convert(nvarchar(5),ServerProperty('NumLicenses')) + ')'
    WHEN 'Per_Processor' THEN 'Processor Licensing (' + Convert(nvarchar(5),ServerProperty('NumLicenses')) + ')'
    ELSE 'Licensing Disabled / Unknown'
    END Licensing,
    ServerProperty('ProductLevel') PLevel

With somthing like

    'Unknown' Edition,
    'No Cluster' Cluster,
    'Licensing Disabled / Unknown' Licensing,
    '2000' PLevel

If that will work.. What is Plevel?

Thanks

Posted By: crusad3r
Date Posted: 03 October 2003 at 12:14pm

crusad3r wrote:

Yea I know but I'm a tweaker. Could I replace the values that it is getting with the GetServerPerperty with somthing static?

for instance replace

With somthing like

    'Unknown' Edition,
    'No Cluster' Cluster,
    'Licensing Disabled / Unknown' Licensing,
    '2000' PLevel

If that will work.. What is Plevel?

Thanks

Sorry for spamming up your topic here, but I answered my own question, it does work.

Thanks alot.

cRusad3r

Posted By: tnt266
Date Posted: 03 October 2003 at 1:47pm

I'm getting the following error message when loggin in.

Microsoft VBScript runtime error '800a01f4'

Variable is undefined: 'strTableBottomRowColour'

/login_user.asp, line 392

I'm not sure if this has to do with the size of the field browser in the Access database. If so, can someone help me out with how to do this? (I'm not a database guy at all, pretty clueless).

Posted By: tnt266
Date Posted: 03 October 2003 at 1:50pm

Never mind, I answered my own question. Great forum upgrade!

Posted By: MadDog
Date Posted: 03 October 2003 at 4:09pm

-boRg-,

Did you change a couple of stored procedures from v7.5 beta 1 to v7.5 final?

I had to update 2 (that i know of) stored procedures for the forum to run.

-------------
http://www.iportalx.net" rel="nofollow">

Posted By: wistex
Date Posted: 04 October 2003 at 12:07am

I'm moving to a new server and going to upgrade to 7.5 of the forums. We are going to get a backup copy of the database from our old web host which contains our forum's data as well as other data from other parts of the site.

Which method would you suggest?

Use backup from previous web host to restore database (tables & stored procedures) to the new server.
Copy version 7.01 forum asp code to new server via ftp.
Install 7.5 asp code.
Change stored procedures in database to new 7.5 version.

or how about this?

Install 7.5 on new server (clean install).
Import data in 7.01 tables into 7.5 database.

What do you think?

Also, is there anything I need to be aware of when moving the forums to a new server. I know that we will need to take the forums down for maintanence before we do, but other than that is there anything else I need to know about?

-------------
http://www.wistex.com" rel="nofollow - WisTex Solutions
http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums

Posted By: Badaboem
Date Posted: 04 October 2003 at 6:56am

I'm sure other folks are wondering as well.

Is it possible to skip the security check the login has? (number check). I don't find it necesarry + I think old login scripts (7.01) aren't working because of that.

Posted By: WebWiz-Bruce
Date Posted: 04 October 2003 at 12:53pm

wistex which ever way you want will work I imagine I just altered the old database.

Badaboem you can change a boolean value in teh common.asp file to turn off the login security check but as many people seem to have been hacked recently by password tools through the login page I would leave it in place.

-------------
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: Lamur
Date Posted: 04 October 2003 at 8:13pm

I just upgraded my forum, but I am unable to enter into the Admin control panel. I click on admin and it comes up "Sorry, only members with sufficent persmission can access this page" I am logged in as the OWNER of the forum... i wonder whats up?

Posted By: WebWiz-Bruce
Date Posted: 05 October 2003 at 6:55am

Could be a corruption, try reuploadingeverything again.

Also try logging in directly to the admin section by pointing your browser at the default.asp page in the admin directory.

-------------
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: SKY2nd
Date Posted: 05 October 2003 at 11:08am

OK, I went to change the database tblActiveUser field Browser to 20, it was set at 30. When I put 20 in it went to 40, tried again and now it's at 60. HELP !! I didn't know it was adding, how do I get it where it should be?

Posted By: Badaboem
Date Posted: 05 October 2003 at 12:06pm

-boRg- wrote:

Badaboem you can change a boolean value in teh common.asp file to turn off the login security check but as many people seem to have been hacked recently by password tools through the login page I would leave it in place.

Thanks, i changed the login and it's working with security check enabled and disabled.

Posted By: whittibo
Date Posted: 05 October 2003 at 9:26pm

oh.. this is the scary part!! I don't think you guys are up to helping me get through this..

I just changed the skin on my forum 3 days ago.. and now it won't work?!

OK.. who can I pay to do this for me? anyone??

-------------
Live and learn through trial and error ~ when all else fails, ASK!

Posted By: b_bonnett
Date Posted: 05 October 2003 at 11:58pm

Lamur wrote:

I just upgraded my forum, but I am unable to enter into the Admin control panel. I click on admin and it comes up "Sorry, only members with sufficent persmission can access this page" I am logged in as the OWNER of the forum... i wonder whats up

Just an idea - did you change the name of the cookie in the common.asp file? If so, you need to change it in the admin/common.asp file as well, otherwise the login won't carry over to the Admin section.

Bruce, you might want to add a warning comment to this effect above the cookie name code.

Blair

-------------
Webmaster, http://www.planegallery.net/ - The Plane Gallery
Greetings From Christchurch

Posted By: l15aRd
Date Posted: 06 October 2003 at 1:24am

I get this error when trying to access either the admin console or the memberslist????

Technical Information (for support personnel)

Error Type:
Provider (0x80040E4D)
Authentication failed.
/forum/admin/common.asp, line 174
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Page:
GET /forum/admin/frame_set.asp
Time:
06 October 2003, 08:22:34
More information:
http://www.microsoft.com/ContentRedirect.asp?prd=iis&sbp=&pver=5.0&ID=500;100&cat=Provider&os=&over=&hrd=&Opt1=&Opt2=%2D2147217843&Opt3=Authentication+failed%2E - Microsoft Support

-------------

http://www.drunkentechie.net - DrunkenTechie.net

You can logoff, but you can never leave

Posted By: b_bonnett
Date Posted: 06 October 2003 at 2:30am

OK, I've just uploaded an upgrade script which will make the neccessary changes for the Microsoft Access version.

Further details and download http://forums.webwiz.net/forum_posts.asp?TID=6189 - here .

Blair

-------------
Webmaster, http://www.planegallery.net/ - The Plane Gallery
Greetings From Christchurch

Posted By: WebWiz-Bruce
Date Posted: 06 October 2003 at 5:29am

l15aRd could be a problem with connecting to the SQL server.

-------------
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: l15aRd
Date Posted: 06 October 2003 at 6:17am

it seems to have resolved itself... ????, computers who'd have em ???

-------------

http://www.drunkentechie.net - DrunkenTechie.net

You can logoff, but you can never leave

Posted By: Gifmenger
Date Posted: 08 October 2003 at 1:46am

I want to upgrade my forum from version 6 to 7.5, but the migrationtool doesn't work wel.

When I run the tool, compact, rename and upload the database it works. But I can't post a new topic, reply or poll. Everytime I get a "error 500"!

Help!!!!!

Posted By: b_bonnett
Date Posted: 08 October 2003 at 2:12am

Turn off friendly error messages (see http://www.webwiz.net/asp/faq/friendly_HTTP_error_messages.asp - this article to find out how to do so), and search this forum for the error number. If you can't find anything that helps, then start a new thread rather than posting in a thread on a different topic.

Blair

-------------
Webmaster, http://www.planegallery.net/ - The Plane Gallery
Greetings From Christchurch

Posted By: wack
Date Posted: 08 October 2003 at 11:45am

hi i'm using the 7.01 in sql version. When i want to change my dbTables or stored procedures with enterprise manager they all change of owner & become useless cos the forum needs dbo as owner for each table or procedure. Will it work if i just delete the tblActiveUsers (since it has no permanent data in it) and the stored procedure that i need to change and then just run ms_sql_server_setup.asp. That script doesn't overwrite existing tables or procedures i presume?

Will this work or will i ruin my database ?

Posted By: svpworld
Date Posted: 09 October 2003 at 6:20am

Dear Borg,

I put off upgrading to ver 7 as I felt the extra's didn't warrant the effort, but now with your latest release I am drooling (and I know my members will be too!). My problem, I am running the MS SQL version 7 beta 3 (yep I know I deserve a smack!) and I have nearly 1600 members and 6145 posts... What's the best way for me to upgrade without losing anything? I noticed there is a script to upgrade from 6.34 to 7.01 SQL, could i use this for the beta 3 version, perhaps with some simple mods to get to the full 7.01, and then upgrade from 7.01 to the latest version?

Hope someone can offer some advice and not swear too strongly at me for being a beta user!

Simon Williams
SVPWorld

Posted By: Lamur
Date Posted: 09 October 2003 at 10:28pm

Sorry for the late reply. I just re-uploaded a few of the files and it worked out great for me. Thanks alot for the great product!

Posted By: WebWiz-Bruce
Date Posted: 10 October 2003 at 2:46am

svpworld wrote:

Dear Borg,

Hope someone can offer some advice and not swear too strongly at me for being a beta user!

Simon Williams
SVPWorld

I think beta 3 was one of the later ones so hopefully you won't need to do to much, but you will have to go through the version history file and make any changes to the database by hand.

-------------
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: TimD
Date Posted: 10 October 2003 at 11:20am

Greetings all. I will be upgrading from 7.01 to 7.5 Access version but am a little concerned with the messages regarding login problems after the upgrade is uploaded.

I know I will need to backup the database, is there anything else I should be aware of before I proceed?

Also, will my members still be able to upload pictures to the site? I didn't notice that feature here on this board?

Posted By: WebWiz-Bruce
Date Posted: 10 October 2003 at 11:26am

The login problem is a problem with the way people setup the board preventing the browsere reading cookies and if people searched the forum it has been posted on 1000's of times in the last year. If it doesn't effect your present imstallation it won't after upgrading.

Upload is the same, it's just not avaialable on this board for security reasons.

-------------
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: TimD
Date Posted: 10 October 2003 at 11:40am

-boRG-

Thank you, as always you have the answers. I am hoping that it will not be required for me to post again however I will do so just to say all is OK.

Thanks again,

Tim

Posted By: Awes
Date Posted: 10 October 2003 at 11:47am

I'll be upgrading this weekend... Great work -boRg-!

Best advice I can give you TimD is to make a backup and print your admin settings before you convert to reference during the new set-up. I changed my cookie name so this is just an example of how I will need to refer back to the old setings. Print your skin files out too if you have a custom one like I do;)

All this will help if you run into a problem after installation!

Posted By: TimD
Date Posted: 10 October 2003 at 9:32pm

Loaded the upgrade with no problems at all. A good backup of the database was all I needed.

Thank you -boRg-

I would only like to make one change and hate to admit it but I have been messing with it for hours and can't figure it out.

I want to get rid of the Engineer Pad looking background and just go to an all white background or light gray - ANY HELP?

Thanks to everyone.

Posted By: TimD
Date Posted: 10 October 2003 at 10:01pm

Wouldn't you know. Put up a post to ask for help and then figure it out.

Sorry but thatnk you all anyway as I know tomorroq I would have had many responces.

So got it all figured out and all is running great.

Only thing I could use now would be additional Emoticons and allow for larger Avatars. - Any ideas for those?

Thanks again,

TimD

Posted By: WebWiz-Bruce
Date Posted: 11 October 2003 at 5:10am

There is an emaoticons include file in the includes directory that you can add further emoticons to.

The avatar size can be change in the skin_file.asp also in the includes directory.

-------------
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: gantocks
Date Posted: 11 October 2003 at 6:52pm

Hi I have just installed the new version 7.5

When clicking on Profile I receive this message

Edit Profile
Web Wiz Forums : Edit Profile	http://www.bcbb-team.co.uk/bcbb_utopia/forum/member_control_panel.asp%20

Posted By: yataylimit
Date Posted: 12 October 2003 at 8:42am

"In the Access database you will have to increase the size of the field Browser to 20 in the table tblActiveUsers."

I really couldn't understand what you mean by the relevant size. Is that the width of the table "Browser", preceding the "Hide". If you mean that then it is something like "15,4111". I increased this to 20 and my forum crashed with the following error:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/yedek/common.asp, line 271

Soryy for being such an idiot; I need your help!

Posted By: BrownGhost
Date Posted: 13 October 2003 at 6:14am

is there a list of changed files from 7.01 to 7.5 ??

i use SQL WWF 7.1.. and want to upgrade to 7.5...

But my forum is integratet in to my website.. have we have modifyed it a lot.. So i want to add only the new changed files, that will make my job of upgrading easyer..

Any one have a Changed files list?

Posted By: WebWiz-Bruce
Date Posted: 13 October 2003 at 6:31am

The version history file that comes with the forum software lists all changed files between versions.

-------------
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: tareq
Date Posted: 13 October 2003 at 8:50am

oops , it seems like there is A problem In include a Flash in the post

try :

[FLASH] http://www.actionscript.org/tutorials/advanced/constrain_to_ arc/ConstraintoArc.swf[/FLASH]

& see the result , On the webWiz 7.5 final