| Author |
 Topic Search  Topic Options
|
RadioActiveLamb 
Groupie
Joined: 29 December 2005
Location: United States
Status: Offline
Points: 171
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Upgrade from 8b1 to 8b2
Posted: 01 March 2006 at 8:00pm |
|
Is there a documented lossless upgrade procedure for the SQL database for those of us running 8b1? I ready through the "read me first" file, but didn't find mention of it. Will the application do it on its own?
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 March 2006 at 10:41am |
|
I'm sorry to appear rude, but as I keep saying, the Beta version is for testing only and not be used on a live server as there will not be an upgrade path between beta versions.
This is also why no upgrade tool has become available to upgrade from version 7.x. An upgrade tool from 7.x to 8 will be available when the full version 8 is released.
For the moment you are on your own with any upgrade between betas, but what you will need to do is:-
1. Replace ALL beta 1 files with beta 2 files
2. Go through the version history file and make all listed database changes to the database
The second part will involve creating a few new fields in the database as well as a new table. Database changes are listed below:-
Database changes version 8 beta 2
---------------------------------
Changes to tblConfiguration
New fields:-
1. Guest_SID - data type = boolean - default value = true
2. Calendar - data type = boolean - default value = true
3. Member_approve - data type = boolean - default value = true
4. RSS - data type = boolean - default value = true
5. Install_ID = datatype = text/vchar 15 characters
Changes to tblPermissions
New fields:-
1. Calendar_event - data type = boolean - default value = false
Changes to tblTopic
New fields:-
1. Event_date - data type = date
Changes to tblAuthor
New fields:-
1. Login_attempt - data type = interger - default value = 0
2. Banned - data type = boolean - default value = false
4. Info - datatype = text/vchar 255 characters
Changed fields:-
1. Signature - datatype text/vchar 255 characters - changed from text/memo type to increase database performance by decreasing allocated database data blocks for table
New table tblSession
New fields:-
1. Session_ID - datatype = text/vchar 50 characters - primary key
2. IP_address - datatype = text/vcahr 50 characters
3. Last_active - datatype = date/time - default value = now()/GetDate()
4. Session_data - datatype = text/vchar 255
|
|
kingjoop
Newbie
Joined: 01 September 2004
Status: Offline
Points: 11
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 March 2006 at 11:46am |
The upgrade worked fine for me, great work 
Only problem is is that my user account lost his Admin permissions. When i login with my admin account and click on ADMIN it says:
| Error |
| Only members with sufficient permission can access this page. |
Any ideas?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 March 2006 at 11:53am |
|
Please make sure that you upgrade all files as the admin section has a new login system that requires the admin to re-login using the admin.asp file.
This has been done to add extra security to the Admin Control Panel after researching into the habits of hackers who target Web Wiz Forums.
|
|
kingjoop
Newbie
Joined: 01 September 2004
Status: Offline
Points: 11
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 March 2006 at 12:59pm |
my bad, i overwrote the beta1 files and in my custom skin ( www.mopower.nl) file i linked to the admin_frame_set.asp and not the admin.asp  Works great now.. 
Edited by kingjoop - 02 March 2006 at 12:59pm
|
|
RadioActiveLamb
Groupie
Joined: 29 December 2005
Location: United States
Status: Offline
Points: 171
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 March 2006 at 12:39am |
Sorry to appear incompetent, but I did my best to search for any information along these lines. I tried "8 upgrade instructions", but it didn't like the "8". "upgrade instructions" returned no results. I browsed through some of the threads that I thought might pertain to the issue, but I found nothing regarding the issue. I looked through the readme and other text files in the ZIP. Believe me, I spent plenty of time looking for the answer before posting. The last thing I want to do is waste your time on this forum when you could be spending it either developing or enjoying some personal free-time (I've heard that it exists  ).
Your database change log is very valuable. I'll see if I can make it work with what you've given me. Otherwise no big deal. This is not a production server. My production box is running 7.97, waiting for v8 to go gold.
Thanks for all you do, you do it all so well.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 March 2006 at 9:44am |
 -boRg- wrote:
This is also why no upgrade tool has become available to upgrade from version 7.x. An upgrade tool from 7.x to 8 will be available when the full version 8 is released.
|
I believe I have already answered this. To discourage users attempting to upgrade before the final version and then running into difficulties there isn't an upgrade tool available or any alternative instructions. However, I have successfully upgraded the forum on this site by just following the database changes in the Version History file.
|
|
namtoday
Senior Member
Joined: 15 February 2005
Status: Offline
Points: 212
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 March 2006 at 4:41am |
|
kingjoop, i wonder if you are running WWF beta 2 because i DONT see any
ad in your forum, as well as powered by or watever related to
Web Wiz. The answer is WHY ???
|
|
