Error when trying to move a post

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Craig Members Profile Find Members Posts Newbie Joined: 30 May 2007 Status: Offline Points: 7	Post Options Post Reply Quote Craig Report Post Thanks(0) Quote Reply Topic: Error when trying to move a post 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.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Packrat Members Profile Find Members Posts Newbie Joined: 24 January 2006 Status: Offline Points: 4	Post Options Post Reply Quote Packrat Report Post Thanks(0) Quote Reply 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.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Craig Members Profile Find Members Posts Newbie Joined: 30 May 2007 Status: Offline Points: 7	Post Options Post Reply Quote Craig Report Post Thanks(0) Quote Reply 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.

freakyfred Members Profile Find Members Posts Groupie Joined: 29 March 2007 Location: United Kingdom Status: Offline Points: 171	Post Options Post Reply Quote freakyfred Report Post Thanks(0) Quote Reply Posted: 17 December 2007 at 9:02pm
	I have generated this error in the past.

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum