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
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.
When going on one of the 'threads', the date is correct, as shown here:
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
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.
When going on one of the 'threads', the date is correct, as shown here:
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
0
This discussion has been closed.
Comments
You can update that with an SQL query. Do you have access to phpMyAdmin or some other way of querying the database?
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)