FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

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
Return to the default flat view Create a new topic Submit Reply
Re: Insert a message into a thread [message #169270 is a reply to message #169263] Mon, 16 September 2013 17:08 Go to previous messageGo to previous message
naudefj is currently offline  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.
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: How to Delete ALL Unconfirmed Users?
Next Topic: Reset admin password from database
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 12 21:05:04 GMT 2024

Total time taken to generate the page: 0.06332 seconds