I have installed version 8 on my new website. Now i need to import all the posts that has been made on my old website.

How do you import data from wwForum version7 to version8 ?

But after running the script (without errors) the result is not that good. The threads are split into duplicate topics. I have several topics with the same name in the newly created database...

 

Original database (after running the script):

http://mattiasnordin.net/web2005/forum/default.asp - http://mattiasnordin.net/web2005/forum/default.asp

 

New database:

http://mattiasnordin.net/web07/tab5/default.asp - http://mattiasnordin.net/web07/tab5/default.asp

 

For example. In the original database i had a forum topic called "Mattias webforum", after the migration to version 8 i have two forum topics called "Mattias webforum".

 

I have opend the database and compared the fields etc but it's hard to see anything wrong without debugging the code.

 

Another thing... if i open the web wiz forums control panel the forum list looks fine (!). All forums and topics are grouped as usually.

 

Could this be a bug on the "default.asp" page?

 

Please help me

I compared the wrong version of the database yesterday. The original version 8 database and the upgraded version 7 database do NOT match.

 

For example the field Sub_ID does not exist in the tblForum table in the upgraded database (the old 7).

 

Do you have a tool to import data from the old database into the blank database instead? Then it isnt nessesary to modify the tables at all.

 

I like version 8 better then 7. It's very good!

 

Best regards

Mattias

 

Below i have quoted the instructions available for me.

 

The pink changes is a suggestion on how to be more specific. I might not be that clever but it was not clear to me if i should put the  ‘access_update.asp’ file in my version 7 or version 8 folder (different paths on my server). I guess that what made it un-logical för me was that i downloaded and installed the version 8 at a different path on the server before i even found the upgrade tool.

 

Anyway i don't follow you... Where do i find the place to "reset the forum permissions"? I can't find any option to do that in the version 8 Admin -> control panel interface.

 

Super thanks !

 

Instructions wrote: Web Wiz Forums version 7.x to 8.x Upgrade Tool v1 ------------------------------------------------- This tool comes with NO GURANTEE that it will work or will not loose, destroy, or corrupt data in the database that is being upgraded. USE THIS TOOL AT YOUR OWN RISK. Modified version 7.x databases ------------------------------- If you have modified your version 7.x database you may need to un-modify the database in order for the upgrade tool to work.   How to use this tool --------------------- 1. Back-up your database 2. Back up your database, this is so important I thought I had better repeat this step. 3. To prevent errors you must ensure that no-one else access the database during the update, the simplest way to do that is to remove the file ‘common.asp’ from the forum directory. 4. Place the file ‘access_update.asp’ in the version 7 forum directory 5. Browse to your forum version 7 and open the file ‘access_update.asp’ in your favourite web browser. 6. Type in the connection details for your forums database into the form fields provided. 7. Submit the form to the web server to start the update process. Once the update process is started DO NOT HIT REFERSH. As each stage of the update process is executed you will be informed. Some of these stages may take sometime so please be patient. 8. Once the upgrade is complete you will be displayed a message telling you of this. 9. Delete the file ‘access_update.asp’ from the web server. 10. The database update will now be complete. 11. Upload Web Wiz Forums version 8 to the web server, make sure you do NOT overwrite your updated Access database file and do NOT attempt to run Web Wiz Forums version 7.x on the new updated database. 12. Run your new Web Wiz Forums version 8. Security Notice!!! ------------------ Forum Group and Member permissions may have changed, so please check these before setting your new forum live.

 

 

This is how i do it.

 

1) Install wibwiz version8 on the path "/web07/" on my webserver. I don't want it to interfere with the "/web2002/" version of my website.

...

2) I follow the instructions above and copy the "access_update.asp"-file into the root of the webwiz ver7 folder.

...

3) I backup the database by creating a duplicate file with a different file name.

...

4) I verify that the IUSR_machinname have access rights to the access database file.

...

5) I run the "access_update.asp" file via the "/web2002/" website hosting the version 7 of webwiz.

...

6) No errors in the process. The database is modified in some way since the file size is bigger then before.

...

7) I copy the wwForum.mdb file to the "/web07/ path.

...

8) I move the file to a secure location and set the IUSR_machinename access rights on the file. I also rename the database according to your suggestion.

...

9) I open the address to the new forum (version8) on my new website ( http://mattiasNordin.Net/web07/tab5/ - http://mattiasNordin.Net/web07/tab5/ )

...

10) I log on to the forum. And i log on once more when pressing the admin link.

...

11) I check the "forum admin" page in the control panel. Everything looks fine here (but not in the actual forum).

...

12) I have tried all kind of things. Removing all the groups creted. Creating new forums and moving threads etc... but i havent found anything that removes all the duplicate topics in default.asp file view.

 

Also in the database, i dont seem to have duplicates. It looks fine in the database.

 

What is the difference on the default.asp page and on the admin_view_forums.asp page? The latest of them work.

 

I would be very glad if you could help me because i really need to keep the old posts and their dates intact.

 

Thank you.

 

Here are two screenshots that describes the problem.

1) http://mattiasnordin.net/forum_incorrect.gif - The incorrect default.asp view

2) http://mattiasnordin.net/forum_is_correct.gif - The correct admin_view_forums.asp

 

I will try to delete the tblPermissions to see if that helps. I'll get back to you soon. :)

 

I deleted all 89 rows in the tblPermissions table and as you said, the forum seemed to be blank on the webserver.

 

I went into the control panel and started to reset the permissions. It worked as you explained untill...

 

http://mattiasnordin.net/forum_is_correct2.gif - http://mattiasnordin.net/forum_is_correct2.gif

 

... I reset the permissions on the "access database" forum. When i did that i got the same response on the default.asp page as earlier...

 

http://mattiasnordin.net/forum_incorrect2.gif - http://mattiasnordin.net/forum_incorrect2.gif

 

... suddenly i have two forums called "Mattias webforum".

 

Could it still have something to do with the permissions?

 

Would it help if i sent my database to you?

 

Best regards

Mattias

 

 

THANK YOU...

 

It had to do, as you said, with the forum order. If i changed the forum order to different numbers on each it works fine again.

 

THANK YOU...

 

I would mark this thread as solved. Mostly i get questions in my forum and it would be good if the thread starter could mark a specifik post as the problem solver and that should also be marked in the user interface.

 

Sorry for posting in the wrong part of the forum.