Blog Documentation Book a Demo
Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Anti-date

doschdosch New
in Vanilla 2.0 - 2.8

Is it possible to change the publish date of a post?

I am migrating (by hand) from another system to Vanilla and it would be great to keep the old date-order in tact...

Comments

  • whu606whu606 MVP

    @dosch

    Could you give an example of what you mean?

  • doschdosch New

    Sure!

    I am moving a multiple author blog over to vanilla to allow for more discussion.

    But the blog has posts going back to the start of 2013.
    Currently I am copy/pasting the blogs over, and that goes fine, it is just that original order is getting lost. As some posts refer to events or dates, I'd like to change the date of the post on the forum so it appears, for example, to be posted on 3 july 2013.

    I hope that clarifies stuff.

  • whu606whu606 MVP
    edited April 2016

    I saw somewhere else it is a relatively small number you are dealing with, so you could just edit

    DateInserted

    in the GDN_Comment table (and GDN_Discussion if relevant)

    rather than do multiple SQL find and replaces.

  • doschdosch New

    yeah, I am not a real MySQL master.. (not at all to be honest) and I was hoping for a point and click solution with a plugin or a forum feature I have missed thus far...

  • R_JR_J Admin

    There is no point and click solution in Vanilla. See if you can get access to the mysql with phpMyAdmin.

    If not, you can try adminer, that's a one file mysql management script. You can simply copy that somewhere where you can access it with the browser.

    Changing the "DateInserted" column in the GDN_Discussion table is really easy with such a config script.

Sign In or Register to comment.