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

 

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.

 

 

 

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.