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.

Imported IPB to Vbulletin and into Vanilla - Wrong dates on Discussion List

edited March 2011 in Vanilla 2.0 - 2.8
Hi there,
I was originally using IPBoard but since I found Vanilla I have moved all my forums (originally phpBB) over to Vanilla. The only problem I had with the IPBoard forum is that the converter doesn't directly support it. So, I converted the IPB to Vbulletin and now into Vanilla. Everything has converted fine, just the dates in the Discussion Lists are wrong.

image

When going on one of the 'threads', the date is correct, as shown here:

image

How do I go about fixing this? I don't really want to have to manually key all of the dates in correctly!

Cheers, Dean
Tagged:

Comments

  • Weird. I wonder how that got lost in translation. If should've calculated that at the end of the import process.

    You can update that with an SQL query. Do you have access to phpMyAdmin or some other way of querying the database?
  • LincLinc Admin
    edited March 2011
    I believe this is what you need:
    update GDN_Discussion d set DateLastComment = COALESCE( (select c.DateInserted from GDN_Comment c where c.DiscussionID = d.DiscussionID order by c.DateInserted desc limit 1 ), d.DateInserted)
  • That's excellent! Worked straight away, thanks! :)
This discussion has been closed.