Web Wiz Forums - Error when trying to move a post

Error when trying to move a post

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24745
Printed Date: 04 April 2026 at 8:10am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error when trying to move a post

Posted By: Craig
Subject: Error when trying to move a post
Date 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.

Replies:

Posted By: WebWiz-Bruce
Date 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.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Packrat
Date 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 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.

/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.

Posted By: WebWiz-Bruce
Date 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.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Craig
Date 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.

Posted By: freakyfred
Date Posted: 17 December 2007 at 9:02pm

I have generated this error in the past.