XF 1.3 Thread Database Changes.

[Iomega0318]

So got everything transferred over, for the most part and I going through modifying threads. I have reset all the post dates to their originals by hand which was a pain lol.. Now I need to update the the last post date.. I was wondering if someone could give me a query I can run in MySQL to copy "post_date" of each thread to "last_post_date" I don't use MySQL all to often so no idea where to begin on that one

Any help would be appreciated, thank you.

 

[Steve F]

What software did you import from? Not sure I have heard of anyone needing to "modify post dates" after a import. What exactly are you trying to accomplish?

 

[Iomega0318]

SMF -> phpBB -> Xenforo
If went okay but I did have a few complications lol, that being one of them. Somehow the dates were all reset and it bugged the crap out of me so I have been fixing them in the database by hand. I fixed the post dates but was looking for an easier way to change/copy the last post dates before I have to do them by hand as well..

 

[Mike]

Changing dates by hand is a very dangerous thing, but if you rebuild thread information including post counters, that should probably sort it.

 

[Iomega0318]

Changing dates by hand is a very dangerous thing, but if you rebuild thread information including post counters, that should probably sort it.

Got it fixed, thanks guys.