Upgrade from 8b1 to 8b2
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=18553
Printed Date: 13 April 2026 at 6:45am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Upgrade from 8b1 to 8b2
Posted By: RadioActiveLamb
Subject: Upgrade from 8b1 to 8b2
Date 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? |
Replies:
Posted By: WebWiz-Bruce
Date 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 |
Posted By: kingjoop
Date 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:
Any ideas?
|
Posted By: WebWiz-Bruce
Date 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. |
Posted By: kingjoop
Date Posted: 02 March 2006 at 12:59pm
my bad, i overwrote the beta1 files and in my custom skin ( http://www.mopower.nl - www.mopower.nl ) file i linked to the admin_frame_set.asp and not the admin.asp  Works great now.. 
|
Posted By: RadioActiveLamb
Date 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.
|
Posted By: WebWiz-Bruce
Date Posted: 03 March 2006 at 9:44am
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. |
-boRg- wrote:Posted By: namtoday
Date 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 ??? |