Web Wiz Support and Community Forums : problem upgrading 7.01->7.6 https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 15:38:45 +0000 Tue, 02 Dec 2003 04:20:34 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=7643 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[problem upgrading 7.01->7.6 : Solved the problem. I did an online...]]> https://forums.webwiz.net/problem-upgrading-7-017-6_topic7643_post39273.html#39273 Author: psycotik
Subject: 7643
Posted: 02 December 2003 at 4:20am

Solved the problem. I did an online copy of the database to another name then downloaded that isntead of the live version. Which solved the issue.

Thanks for your help.

]]> Tue, 02 Dec 2003 04:20:34 +0000 https://forums.webwiz.net/problem-upgrading-7-017-6_topic7643_post39273.html#39273 <![CDATA[problem upgrading 7.01->7.6 : I tried running a new install...]]> https://forums.webwiz.net/problem-upgrading-7-017-6_topic7643_post39270.html#39270 Author: psycotik
Subject: 7643
Posted: 02 December 2003 at 3:51am

I tried running a new install of 7.01. I get the same error.

Could it be that users are accessing the database whilst im downloading it? Would that cause any problems? Because normally there are 10-12 users posting regularly at any time.

]]> Tue, 02 Dec 2003 03:51:07 +0000 https://forums.webwiz.net/problem-upgrading-7-017-6_topic7643_post39270.html#39270 <![CDATA[problem upgrading 7.01->7.6 : The repair compact didnt fix the...]]> https://forums.webwiz.net/problem-upgrading-7-017-6_topic7643_post38507.html#38507 Author: psycotik
Subject: 7643
Posted: 27 November 2003 at 11:52pm

The repair compact didnt fix the problem.

I might try running it off a clean version of 7.01 see what happens

 

. might have to write an sql-transfer script which does an insert/select between databases.. But thats a bit of effort.



Edited by psycotik]]> Thu, 27 Nov 2003 23:52:52 +0000 https://forums.webwiz.net/problem-upgrading-7-017-6_topic7643_post38507.html#38507 <![CDATA[problem upgrading 7.01->7.6 : Could be a corrupted database...]]> https://forums.webwiz.net/problem-upgrading-7-017-6_topic7643_post38408.html#38408 Author: WebWiz-Bruce
Subject: 7643
Posted: 27 November 2003 at 12:26pm

Could be a corrupted database use the compact and repair feature in the admin area of the MS Access version.]]> Thu, 27 Nov 2003 12:26:45 +0000 https://forums.webwiz.net/problem-upgrading-7-017-6_topic7643_post38408.html#38408 <![CDATA[problem upgrading 7.01->7.6 : Hi, Im in the process of updating...]]> https://forums.webwiz.net/problem-upgrading-7-017-6_topic7643_post38315.html#38315 Author: psycotik
Subject: 7643
Posted: 27 November 2003 at 4:54am

Hi,

Im in the process of updating a 7.01 forum to 7.6. As far as i can see the only database change is the activeusers "browser" field, from length 15-20.

I have a clean version of 7.6 running, pointing to the old database and i get the following error whilst trying to create a post:

 Microsoft JET Database Engine error '80040e21'

The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

/forum/post_message.asp, line 756

I've tried a few times and cant seem to work out what is causing this error. Would anyone else have an idea?

Thanks.

]]> Thu, 27 Nov 2003 04:54:18 +0000 https://forums.webwiz.net/problem-upgrading-7-017-6_topic7643_post38315.html#38315