Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - How to upgrade ...
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

How to upgrade ...
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
Shannara View Drop Down
Newbie
Newbie


Joined: 16 April 2006
Status: Offline
Points: 9 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Shannara Quote  Post ReplyReply Direct Link To This Post Topic: How to upgrade ...
    Posted: 24 April 2006 at 12:26am
Have anybody figured out how to upgade from 7.97 to newest 8.x?
 
I copied over the 7.x tables from one host to another. Unfortunately, there is no way to copy over the stored procedures, there are no working functions to do that in Enterprise Manager nor SQL Studio. The scripts they produce from the stored procedure is 100% broken .. so ...
 
I ran the up grade script and it was done with several thousand posts in a few seconds. I thought that was cool. So I followed the upgrade instructions. Unfortunately, you cant run the new 8.0 forums without stored procedures. And the upgrade requires you to upload and run the new 8.0 forums without installing ... I thought that was interesting too :)
 
I couldnt find anywhere in the upgrade instructions on the requirement to set the database information for the forums.... ...
 
What's going on here? Ive been wanting to run the new 8.x forums, but cant do that until there are upgrade instructions to allow me to do that.
 
Any help would be wonderful.
 
(edit): Ok guys, there were some required instructions omitted from the upgrade file. You must edit the file found in the /database folder. This is a must step that is missing from the file.
 
Another thing missing is that when you do the upgrade, you will have duplicate groups! I havent found a way to fix this problem yet.
 
All forums are hidden by default. In the admin panel they are set to be shown, but will not show for any user (except in control panel).
 
Also, when press "Update Member Group Permissions", you get a page not found .. ... ..
 
I had hope there was more testing on 8.0 upgrade script before it was rolled out?
 
 
(edit): I am updating this post as I go along for anybody who wants to take the dare to try to upgrade their forums ...
 
A lengthy workaround for copying the stored procedures is to use the Alter or Modify command to get the correct SP code. This you can take and execute on the new database. However, there are some errors to take into consideration.
 
I have only started on the first SP and already ran into an error. tblPermissions.read field does not exist ... ... .. I need to figure out the alternative to that field in order to port over the stored procedure.
 
Borg, I am hoping you or someone here could help me out with this. Its really frusterating not being able to upgrade to 8.x when the instructions doesnt contain the needed steps Cry
 


Edited by Shannara - 25 April 2006 at 6:33pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 24 April 2006 at 9:42am
I think the problem is that you are trying to make the upgrade process 100 times more complicated than it is as no-one else is having these issues and find the upgrade process very painless.

For a start version 8 does NOT use any stored procedures, so you don't have to worry about these (By the way you can backup a database using DTS tools in Enterprise Manager which also includes any stored procedures).

The upgrade precess is quite simple, why you where messing around trying to create a new database etc, I really don't know.

All you need to do with the SQL Server version is remove the old version of Web Wiz Forums from the server, then run the upgrade tool on your database, after which upload version 8 to the server following the version 8 install instructions to edit the database_connection.asp file with your SQL Servers details, and thats is job done. Although you may need to reset forum permissions from the admin area.

If you do it this way you should have no issues with multiple groups being created (I'm not even sure how you managed that one!!)


Edited by -boRg- - 24 April 2006 at 9:47am
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Shannara View Drop Down
Newbie
Newbie


Joined: 16 April 2006
Status: Offline
Points: 9 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Shannara Quote  Post ReplyReply Direct Link To This Post Posted: 24 April 2006 at 9:48pm

Ok, thanks for the help. Any chance you could update the upgrade documentation concerning the need to edit the database file? It was missing from the upgrade instructions :(

Ok, I have wiped the forums directory, and nuked the tables on the new server. I then copied over from backup, the 7.x tables. After that, I uploaded the upgrade script onto that server and ran it.
 
I provided my credentials, and it started the update. Update went quite quickly. I have uploaded the v8 forums, edited the database file.
 
I started up the forums, logged in (showing no forums as you mentioned), and went to admin panel to fix the permissions. The results are as follows ... mind you this is a clean upgrade .....
 
1. There are double user groups (they showed up AFTER the upgrade, not before)
2. Unable to set group permissions, this gives a 500 internal error (I am hosted @ jodohost.com). This actually happens on every action except read with ASP enabled, so it could be the account settings is screwed.
3. All permissions are still set correctly for forums already. They are not viewable.
 
I followed the updated instructions you provided in the post above, and came out with the same result.
 
 
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 25 April 2006 at 8:59am
It sounds like your version 7.x database was either not setup correctly in the first place or it has been modified, this is why you are getting these issue, as most people are finding the upgrade process is very straight forward.

1. The upgrade tool doesn't do any thing to the groups or the groups table, so the only reason I can see that you would have the groups repeated is that either you ran the version 8 install tool on the database, which you shouldn't do, or when you originally setup the version 7.x database you ran the setup tool twice thus creating double groups and messing up your database which is coursing the upgrade to version 8 to fail.

Before upgrading your version 7 database check the database doesn't have double groups, if it does remove them manually from the database before the upgrade.

2. Turn off friendly HTTP error messages in IE so you get what the actual error is

3. If permissions are not set correctly forums will not show up correctly, again this sounds like issues that need to be sorted in your version 7.x database before you upgrade it.

What you need to do is go back to your version 7.x database, remove any modifications that you have made to it, and also check the groups table, if it has repeated groups remove these.

Just as an extra precaution also remove all entries in the tblPermissions table before you do the upgrade.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Shannara View Drop Down
Newbie
Newbie


Joined: 16 April 2006
Status: Offline
Points: 9 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Shannara Quote  Post ReplyReply Direct Link To This Post Posted: 25 April 2006 at 6:32pm
First off,  I want to say thank you for taking the time for helping me through this upgrade ... now fo the details :)
 
1. As mentioned above, there were no double groups before, if the upgrade doesnt touch them, I dont know whats going on then :( I double checked to make sure, and again, no double groups in the original database.
 
2. Thanks about the IE hint, it turns out there is an error in one of the tables during upgrade or the new forums :) The following is what I get:
 

Microsoft OLE DB Provider for SQL Server error '80040e2f'

Cannot insert the value NULL into column 'Author_ID', table 'Shannar_shannaracorp.dbo.tblPermissions'; column does not allow nulls. INSERT fails.

/forums/admin_forum_details.asp, line 307

3. The original WWF install is a vanilla install and works perfectly. In fact, I even installed the original on the new server with a copy of the original database and there are no problems :) This leads me to believe this is an upgrade issue and or v8 issue. :) Im just trying to be helpful by knocking off things that could be a problem.
 
4. I went ahead and blanked out the permissions as you said.
 
Oh, I noticed that somehow the topic of this thread have gotten changed. I went ahead and fixed it back up to how it was :) I dont know if it's a bug or anything.
 
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 26 April 2006 at 10:08am
I don't understand why you are getting all these issues when everyone else is finding the database upgrade so simple.

The only thing I can think is that all this unnecessary messing around you mention in your first post with the database has messed things up.

Go back to your original back-up of your 7.x database and do the database upgrade again. This time, follow the instructions in the readme file that come with the database upgrade tool, as this tool takes care of the entire database upgrade, you don't need to touch the database yourself.

Then upload version 8.01 and just change the connection string to point to your upgraded version 8 database, do NOT run the version 8 setup file as the database has already been created and upgraded.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Shannara View Drop Down
Newbie
Newbie


Joined: 16 April 2006
Status: Offline
Points: 9 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Shannara Quote  Post ReplyReply Direct Link To This Post Posted: 26 April 2006 at 4:53pm
Thanks for your replies. I have done as you asked and the results are exactly the same. I am going to go back to using 7.97 until this is sorted out or until 9.x is released.

Thanks again for your efforts. Smile
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.