How 2 upgade from 7.01 to 7.5

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

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.

Edited by -boRg-