https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 20:44:05 +0000 Thu, 23 Mar 2006 11:00:23 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18840 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/server-error_topic18840_post102137.html#102137 Author: WebWiz-Bruce
Subject: 18840
Posted: 23 March 2006 at 11:00am

Glad to hear it has now worked.

I have also placed a note about this on the download page in the hope that others don't have the same issue.

I will also place a list of field names into the upgrade installation instructions later to help aid others with a modified databases.
]]> Thu, 23 Mar 2006 11:00:23 +0000 https://forums.webwiz.net/server-error_topic18840_post102137.html#102137 https://forums.webwiz.net/server-error_topic18840_post102049.html#102049 Author: javi712
Subject: 18840
Posted: 22 March 2006 at 3:40pm

Ahhh... I wish I could have seen your last post before I started looking at the databases myself! lol. But you are correct, I removed those three columns and that allowed the upgrade script to update successfuly. Thank you very much for all your help and patience!]]> Wed, 22 Mar 2006 15:40:06 +0000 https://forums.webwiz.net/server-error_topic18840_post102049.html#102049 https://forums.webwiz.net/server-error_topic18840_post102044.html#102044 Author: WebWiz-Bruce
Subject: 18840
Posted: 22 March 2006 at 2:58pm

The following are fields you have created yourself that are coursing the conflict:-

'Hide' already exists in table 'tblTopic'.
'Hide' already exists in table 'tblThread'.
'Display_post' already exists in table 'tblPermissions'.

If you remove these fields you have created in the database and then run the upgrade tool it should work.
]]> Wed, 22 Mar 2006 14:58:09 +0000 https://forums.webwiz.net/server-error_topic18840_post102044.html#102044 https://forums.webwiz.net/server-error_topic18840_post102043.html#102043 Author: WebWiz-Bruce
Subject: 18840
Posted: 22 March 2006 at 2:54pm

Thanks javi712 I've got the database and can see the problem.

You have modified the database yourself adding in new fields, this is coursing the update to fail.

The update tool is failing because it is attempting to alter tables with new fields with the same names as fields you have already created yourself. This is coursing the entire SQL Alter statement to fail on those tables.

For the upgrade to be successful, you must restore the database to the original 7.x state.
]]> Wed, 22 Mar 2006 14:54:42 +0000 https://forums.webwiz.net/server-error_topic18840_post102043.html#102043 https://forums.webwiz.net/server-error_topic18840_post102036.html#102036 Author: javi712
Subject: 18840
Posted: 22 March 2006 at 2:26pm

Actually, I'll zip it up and send you the url to download via PM]]> Wed, 22 Mar 2006 14:26:56 +0000 https://forums.webwiz.net/server-error_topic18840_post102036.html#102036 https://forums.webwiz.net/server-error_topic18840_post102035.html#102035 Author: javi712
Subject: 18840
Posted: 22 March 2006 at 2:26pm

Sure, how can I get it over to you... its 124.82MB]]> Wed, 22 Mar 2006 14:26:02 +0000 https://forums.webwiz.net/server-error_topic18840_post102035.html#102035 https://forums.webwiz.net/server-error_topic18840_post102031.html#102031 Author: WebWiz-Bruce
Subject: 18840
Posted: 22 March 2006 at 2:10pm

Could you let me have a copy of your original version 7.x database so that I can run some tests on it and find the exact course of the issue?

This way hopefully I can refine the upgrade tool so no-one else gets this issue.
]]> Wed, 22 Mar 2006 14:10:59 +0000 https://forums.webwiz.net/server-error_topic18840_post102031.html#102031 https://forums.webwiz.net/server-error_topic18840_post102029.html#102029 Author: javi712
Subject: 18840
Posted: 22 March 2006 at 2:07pm

Hi Borg, I appreicate your patience!

These are the steps I took to upgrade the database:

1) Downloaded a copy to my local machine to keep as a back-up.
2) Uploaded a copy of that db to my database folder in the new forum directory i created with WWF 8.0.
3) I ran acces_update.asp and pointed the script to database/wwForum.mdb (i renamed the uploaded db to wwForum.mdb)
4) The script still produced the same error.


I never ran any of the beta sites, so there is no way I could have updated the database already and I am not getting any error when running the db I copied from on my live site.]]> Wed, 22 Mar 2006 14:07:38 +0000 https://forums.webwiz.net/server-error_topic18840_post102029.html#102029 https://forums.webwiz.net/server-error_topic18840_post102005.html#102005 Author: WebWiz-Bruce
Subject: 18840
Posted: 22 March 2006 at 11:58am

Yes I know that.

But you are having a problem with upgrading, please follow my suggestions in my previous post and try the upgrade process again on your version 7.x database, NOT one you have already tried to upgrade.
]]> Wed, 22 Mar 2006 11:58:56 +0000 https://forums.webwiz.net/server-error_topic18840_post102005.html#102005 https://forums.webwiz.net/server-error_topic18840_post102002.html#102002 Author: javi712
Subject: 18840
Posted: 22 March 2006 at 11:53am

Hi Borg,

I am currently running version 7.9 of the forum. And it is the original database that I am using.]]> Wed, 22 Mar 2006 11:53:41 +0000 https://forums.webwiz.net/server-error_topic18840_post102002.html#102002