Web Wiz Support and Community Forums : Error when trying to move a post https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 14:37:14 +0000 Mon, 17 Dec 2007 21:02:19 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24745 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Error when trying to move a post : I have generated this error in...]]> https://forums.webwiz.net/error-when-trying-to-move-a-post_topic24745_post130173.html#130173 Author: freakyfred
Subject: 24745
Posted: 17 December 2007 at 9:02pm

I have generated this error in the past.]]> Mon, 17 Dec 2007 21:02:19 +0000 https://forums.webwiz.net/error-when-trying-to-move-a-post_topic24745_post130173.html#130173 <![CDATA[Error when trying to move a post : Problem solved Borg. You were...]]> https://forums.webwiz.net/error-when-trying-to-move-a-post_topic24745_post130141.html#130141 Author: Craig
Subject: 24745
Posted: 16 December 2007 at 8:06pm

Problem solved Borg. You were right on the money. I was using the wrong tool. Using the "Topic Options" from the "Moderator Tools" drop down allowed me to acheive the required results. Thanks again.]]> Sun, 16 Dec 2007 20:06:32 +0000 https://forums.webwiz.net/error-when-trying-to-move-a-post_topic24745_post130141.html#130141 <![CDATA[Error when trying to move a post : We will look into these issues...]]> https://forums.webwiz.net/error-when-trying-to-move-a-post_topic24745_post129758.html#129758 Author: WebWiz-Bruce
Subject: 24745
Posted: 03 December 2007 at 9:13am

We will look into these issues you are reporting, but I believe you are using the wrong tool, this tool moves a post from one topic to another topic.

If you wish to move a whole topic to a new forum then you need to use the 'Topic Options' from the 'Moderator Tools' drop down. This then allows you to move a whole topic to a new forum.
]]> Mon, 03 Dec 2007 09:13:50 +0000 https://forums.webwiz.net/error-when-trying-to-move-a-post_topic24745_post129758.html#129758 <![CDATA[Error when trying to move a post : I&#039;m using Version 9.06...]]> https://forums.webwiz.net/error-when-trying-to-move-a-post_topic24745_post129732.html#129732 Author: Packrat
Subject: 24745
Posted: 01 December 2007 at 6:11am

I'm using Version 9.06
 I too have generated this error.  Its a BUG.
  I have just set up a fresh install of version 9.06 with a Premium License.

To reproduce the error
Using    POST OPTIONS (as admin) to MOVE POST

Step 1 states
  Select the Forum you would like this post to be in
  [  list of all the forums, selected one ]
    Did that
Step 2 states
Select the Topic you would like this post to be in
  [  list of topics in the new forum area, if any ]
    Or, type the Subject of a new Topic
  [  BLANK entry to enter new topic  ]

   So I chose to type the Subject of a new Topic
     (QUESTION: Why do I have to choses a new topic title? why does it not keep the one in teh origina post? )
  anyway,  when I click the MOVE POST button I get the following

ERROR MESSAGE:
-----------------

Microsoft JET Database Engine error '80040e21'

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

/discussion/move_post.asp, line 156


-----------------

Please NOTE:  If you use an existing topic from the destination forum in the pull down, this works. no error, and it does move / copy the message (although I don't like the fact I can not keep the existing topic of the original message.

  (and is the older message in the newer forum being over-written by the message being moved? I did not test this, but it seems that it is. if this is the case, this would be Bug2 of the process.

This seems to mean that instead of adding a new record, which creates new id's in the destination forum, it tried to add a record with and existing record id.  I'll have to look at the code to see what is going on.  But I do want to report this BUG.

]]> Sat, 01 Dec 2007 06:11:12 +0000 https://forums.webwiz.net/error-when-trying-to-move-a-post_topic24745_post129732.html#129732 <![CDATA[Error when trying to move a post : It sounds like you make have lost...]]> https://forums.webwiz.net/error-when-trying-to-move-a-post_topic24745_post128958.html#128958 Author: WebWiz-Bruce
Subject: 24745
Posted: 05 November 2007 at 8:12am

It sounds like you make have lost the default values for your database.

Have you recently moved the SQL Server DB?

The reason being is that SQL Server 2005 import/export tools are really bad and often do not copy across default values, so you end up with a database that doesn't work.

With SQL Server 2005 the best way to move a database from server to server, is to either create a backup of the SQL Server database, or detach then reattach the database.
]]> Mon, 05 Nov 2007 08:12:21 +0000 https://forums.webwiz.net/error-when-trying-to-move-a-post_topic24745_post128958.html#128958 <![CDATA[Error when trying to move a post : I&#039;m receiving the error...]]> https://forums.webwiz.net/error-when-trying-to-move-a-post_topic24745_post128933.html#128933 Author: Craig
Subject: 24745
Posted: 04 November 2007 at 3:54am

I'm receiving the error shown below when trying to move a post to another forum when trying to use the "Or, type the Subject of a new Topic" option.
 
-----------------------------------------------------------------------------------
Microsoft OLE DB Provider for SQL Server error '80040e2f'

Cannot insert duplicate key row in object 'dbo.tblTopic' with unique index 'tblTopic$Start_Thread_ID'.

/move_post.asp, line 156

-------------------------------------------------------------------------------------
 
I can succesfully move the post to the another forum when I choose to move it to an exisiting topic. Any thoughts? Do I need to modify the 'dbo.tblTopic' table?
 
 
Any suggestions would be greatly appreciated. I recently upgraded to ver9.06 from ver8 but expereinced the same problem then as well. This seems to be the only problem I've had with the forums since I began using it earlier this year. My forum is running on my Win2K3 Server EnterpriseEdition, MS SQL Server 2005.
 
 
 
 
 
 
 
 
]]> Sun, 04 Nov 2007 03:54:54 +0000 https://forums.webwiz.net/error-when-trying-to-move-a-post_topic24745_post128933.html#128933