duplicate posts

edk74

Hi, I've done the export/import from punbb to latest standalone vanilla - and it mostly looks good.

However, after importing my (eg)5000 posts, it repeats the 5000 posts again - but this time, without the thread, just the original post. Very strange!! Any idea what might cause that and how to fix?

edk74

ok, im an idiot.... they are not duplicate posts.. the issue is with sorting.

What happens is, after import - all posts with comments are shown first. Then posts with no comments are shown after. So, a new post from Feb 2013, is shown on page 30, after 1000s of older posts.

That doesn't seem to make any sense. Any way to get things sorted by date, as one would expect? thanks.

edk74

OK - checking phpmyadmin, the field 'lastdatecomment' (in discussions) is NULL, where there isn't a comment. Thus, in the import, this has pushed those posts to the back (which is wrong).

im guessing something is wrong when importing.

To fix this, i guess i could make the lastdatecomment = dateinserted?

Does anyone know of the SQL code to make that change where:

if lastdatecomment = NULL, copypaste the dateinserted into that field

thanks!

edk74

something like:

UPDATE GDN_Discussion set DateLastComment = COALESCE(
(select DateInserted from GDN_Discussion where DateLastComment IS NULL
),
DateInserted)

but that doesn't work. Anone know how to code that correctly?

Thanks,

edk74

I'm having a conversation with myself here, but this seems to have solved the issue:

UPDATE GDN_Discussion
SET DateLastComment = DateInserted
WHERE DateLastComment IS NULL;

hgtonight

Thanks for sharing your conversation with the rest of us

Welcome to the community!

Have some Awesomes.

edk74

maybe it helps someone

and thanks!