Web Wiz Support and Community Forums : Issues with upgrade tool discovered https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 22:53:39 +0000 Wed, 03 May 2006 09:29:20 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19597 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Issues with upgrade tool discovered : Good point. thanx for the feedback...]]> https://forums.webwiz.net/issues-with-upgrade-tool-discovered_topic19597_post106082.html#106082 Author: Jesper
Subject: 19597
Posted: 03 May 2006 at 9:29am

Good point. thanx for the feedback guys.]]> Wed, 03 May 2006 09:29:20 +0000 https://forums.webwiz.net/issues-with-upgrade-tool-discovered_topic19597_post106082.html#106082 <![CDATA[Issues with upgrade tool discovered : Also, since many of us have modified...]]> https://forums.webwiz.net/issues-with-upgrade-tool-discovered_topic19597_post106066.html#106066 Author: wistex
Subject: 19597
Posted: 03 May 2006 at 2:24am

Also, since many of us have modified the forums, some of us may have legacy code that still uses those fields.  Its better that the field be left in the database for this reason.  For example, almost all code I write would be able to handle a situation where the expected field is blank/empty, but would crash if there was no field there at all.  Also, in some situations, it might be useful for us to modify version 8 to continue using the field since we have started using it to control other parts of our website.  All in all, its better if old fields are left in the database.

Like Borg said, if you are sure you don't need them, you can delete them yourself.
]]> Wed, 03 May 2006 02:24:24 +0000 https://forums.webwiz.net/issues-with-upgrade-tool-discovered_topic19597_post106066.html#106066 <![CDATA[Issues with upgrade tool discovered : Once you have upgraded your 7.x...]]> https://forums.webwiz.net/issues-with-upgrade-tool-discovered_topic19597_post105773.html#105773 Author: WebWiz-Bruce
Subject: 19597
Posted: 28 April 2006 at 9:16am

Once you have upgraded your 7.x database you can now use that database with version 8, just point web wiz forums version 8 at you upgraded version 7.x database using the 'database/database_connection.asp' file.

Copy and pasting data from one database to another will NOT work, for a number of reasons and not just the reason you mention, but also tables and post will not be associated correctly with each other, thus your forum will fail to work if you attempt to use this method.

The problem with auto dropping old fields in the database is that many have indexs accoiated with them, these often have unique names, and therefore can not be dropped using a standard generic tool. These fields that are no longer used do no harm to the upgraded database and if you really want or need to remove these redundant fields you can use the Version History file to get a list of dropped fields.
]]> Fri, 28 Apr 2006 09:16:39 +0000 https://forums.webwiz.net/issues-with-upgrade-tool-discovered_topic19597_post105773.html#105773 <![CDATA[Issues with upgrade tool discovered : I took my 7.x db and used the...]]> https://forums.webwiz.net/issues-with-upgrade-tool-discovered_topic19597_post105744.html#105744 Author: Jesper
Subject: 19597
Posted: 27 April 2006 at 9:08pm

I took my 7.x db and used the upgrade tool. Since I appearantly am uncapable of creating a copy of the database from our host that includes the seed identity parameters I decided to create a new empty version 8 database, upgrade the 7.x copy and then copy the data to the new empty database.
 
All looked good and fine, but when I copied the contents I was presented with errors about columns that exist in the source but not in the destination.
 
I am not sure if that is my only problem (I hope), but would it be possible to modify the upgrade tool so that it drops the columns in the tables that are no longer used. Also you should consider removing the 'beta warnings' in the tool Wink
]]> Thu, 27 Apr 2006 21:08:23 +0000 https://forums.webwiz.net/issues-with-upgrade-tool-discovered_topic19597_post105744.html#105744