Members appear as guest

Started by Joris, June 02, 2007, 02:57:24 PM

Previous topic - Next topic

Joris

I have converted my YaBB 2.1 forum to SMF 1.1.2 today.
Now I just noticed this;

The first couple of posts of a topic contain proper user info (with the appropriate star rating etc.), but the posts further into the topic, all the posters are marked as guest.
The same user will appear proper and as a guest in the same thread. :o

This happens in all the threads. Is there any way to fix this?

Joris

#1
Ok, this turns out to be a conversion problem. Maybe someone can move this post over to the right board?
I don't know the cause, but on YaBB the poster info was ok, then after the conversion these problems appeard. So the conversion program messed things up in the messages table. I was able to fix it with the following query on my SMF tables:

UPDATE `smf_messages`
INNER JOIN `smf_members` ON `posterName` = `memberName`
SET `smf_messages`.`ID_MEMBER` = `smf_members`.`ID_MEMBER`
WHERE `smf_messages`.`ID_MEMBER` = 0

Advertisement: