Date issue porting phpbb2 to Vanilla

sejo

Recently i moved my community of around 680000 messages and 3500 users from phpbb2 to vanilla, everything was ok except for post timestamp, moving the pointer over post time shows no time details but month and year. In adittion topics are shown in wrong order, most recent post are in last pages.

Therefore i make conversion from phpbb2 to phpbb3, and then to vanilla. That gave me better results. Topics show in correct order, but when i want to see comments of a single topic, its empty. However topic shows i.e. "23 comments".

Using phpMyAdmin to check Vanilla database i realize that post content is on every row of post table.

Also it called my attention that phpbb2 Vanilla Porter file size is larger than phpbb3, ~71MB vs ~35MB.

I need your help cause i really really want to give a try to Vanilla Forums.

Todd

First question: does GDN_Comment contain any data after the import?

sejo

Yep. Has all comments.

UnderDog

Let's focus on 1 discussion and comment that you transferred from phpbb2 / phpbb3 to Vanilla. You most likely need to tell the information you see on your screen in Vanilla and then the exact information (discussion ID, Comment ID, etc) in phpMyAdmin.

sejo said: moving the pointer over post time shows no time details but month and year.

Which month and year do you see with that post?
What is the address you are looking at? Is it /discussions or is it /discussion/123/this-is-my-discussion.
If you look in phpMyAdmin for that discussion which information do you see?
Do you see the field 'Body' and is that filled with text?

In adittion topics are shown in wrong order, most recent post are in last pages.

Do you have any special plugins active? Is it a clean install of vanilla without plugins or did you install a couple of plugins?

but when i want to see comments of a single topic, its empty. However topic shows i.e. "23 comments".

Do you see in the Discussions table the field 'Body' and is that filled with text?

Using phpMyAdmin to check Vanilla database i realize that post content is on every row of post table.

Interesting. Do you mean the discussions table?

peregrine

If I am not wrong.... (famous last words).

in the Discussions table - two fields have a major impact on date shown and positioning within the discussions topics.

DateLastComment -

affects the position (assuming you are not using reversecomment sort plugin or sink or announce) - the most recent date in the table floats the discussion to the top

DateInserted -

affects the date shown on the topic on discussion page and within the discussion.

DateInserted -

will not show the time for discussions that are a day old. will not show year if the the discussion has a date for the current year. You need to modify vanilla if you want to change those parameters.

422

youd think it would default to epoch 1970 date/time

peregrine

422 said: youd think it would default to epoch 1970 date/time

I don't know how the plugin works but he could easily set all the dates in a field with an update command putting a now() in the update field setting

http://vanillaforums.org/discussion/20838

http://vanillaforums.org/discussion/comment/163813/#Comment_163813

sejo

UnderDog said: Let's focus on 1 discussion and comment that you transferred from phpbb2 / phpbb3 to Vanilla. You most likely need to tell the information you see on your screen in Vanilla and then the exact information (discussion ID, Comment ID, etc) in phpMyAdmin.

sejo said: moving the pointer over post time shows no time details but month and year.

Which month and year do you see with that post?
What is the address you are looking at? Is it /discussions or is it /discussion/123/this-is-my-discussion.
If you look in phpMyAdmin for that discussion which information do you see?
Do you see the field 'Body' and is that filled with text?

The date i see is July 2011, and viewing font code of page there is a body field.

In adittion topics are shown in wrong order, most recent post are in last pages.

Do you have any special plugins active? Is it a clean install of vanilla without plugins or did you install a couple of plugins?

Yes, i have some plugins active in the phpbb2 port, but in phpbb3 none.

but when i want to see comments of a single topic, its empty. However topic shows i.e. "23 comments".

Do you see in the Discussions table the field 'Body' and is that filled with text?

Yes i can see it.

Using phpMyAdmin to check Vanilla database i realize that post content is on every row of post table.

Interesting. Do you mean the discussions table?

Discussion and Comment table.