• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.3 Thread Database Changes.

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

Well-known member
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?
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..


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