FUDforum: How To » Insert a message into a thread

Home » FUDforum » How To » Insert a message into a thread (Can we add a message to the middle of a thread?)

Show: Today's Messages :: Polls :: Message Navigator

Re: Insert a message into a thread [message #169270 is a reply to message #169263]

Mon, 16 September 2013 17:08

naudefj

Messages: 3771
Registered: December 2004

Karma:

Senior Member
Administrator
Core Developer

Not all databases will allow you to update the primary key. If yours do, create a test message, record its ID and delete it. You can now use this ID to perform the swap operation between messages X and Y:

UPDATE fud30_msg set id = [TEST_MSG_ID] where id = [X];
UPDATE fud30_msg set id = [X] where id = [Y];
UPDATE fud30_msg set id = [Y] where id = [TEST_MSG_ID];

Let us know if it works.

Report message to a moderator

[Message index]

		Insert a message into a thread By: Parrot on Sat, 14 September 2013 18:37
		Re: Insert a message into a thread By: naudefj on Sun, 15 September 2013 07:26
		Re: Insert a message into a thread By: Parrot on Sun, 15 September 2013 12:27
		Re: Insert a message into a thread By: naudefj on Mon, 16 September 2013 17:08
		Re: Insert a message into a thread By: Parrot on Mon, 16 September 2013 18:15
		Re: Insert a message into a thread By: Parrot on Thu, 19 September 2013 03:22
		Re: Insert a message into a thread By: naudefj on Fri, 20 September 2013 16:07

Previous Topic:	How to Delete ALL Unconfirmed Users?
Next Topic:	Reset admin password from database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 16:47:08 GMT 2024

Total time taken to generate the page: 0.22921 seconds