Converted Users Not Associated with their posts after conversion

[Russ]

Hey all,

Please forgive me if this has been asked before but I couldn't find anything about it.

After My users log into the converted board, their old posts show under their name with on Guest under the name.

Anything new that they post works fine, but they can no longer go back and modify their old posts.

Anyone else run into this?

Russ

[Dani]

I have the same problem!! Help please!!

[Jeff Lewis]

Were they users with names similar to others.  Like if memry serves me correctly... Jeff was different from jeff

[Russ]

Actually for our board, there was no change or new users.  I converted and as soon as they logged in with their old accounts, Everything that they had posted previously showed as being posted from the same username but with a guest status, and they couldn't modify it.  If they posted something new though it showed the correct info and they had full access to it.

Russ

[Dani]

With my board ............

Some of the posts worked .....
while others showed guest status?!

No clue what differentiated some posts from others.
But all posts since the upgrade have been good.

[Russ]

Hey there,

Just wanted to give you an update and say you were completely right...

After actually opening up the Database tables I found that it had assigned several different variations to a persons name, it seems depending on how they had been logged into the old board when the specific post was made.

ex.
ChuqNorriz
chuqnorriz
Chuqnorriz

Any posts from the first spelling worked great, but any from the other two spellings showed as guests (or member number -1).

I was able to go directly into the Messages table and re-assign the errant "guest" posts back to the actualy member, but It was done one message at a time.

Forgive me for my newness to Databases, but I'm going to be converting another board very similar soon and I was wondering if there might be a way for me to get ahead of the game and fix this prior to the conversion.

The Original board is on Yabb Gold SP1, and I am hosting it here at my house so I have complete access to all the files.

Also Dani if your still having a problem with this send me some E-Mail and I'll give you the exact Tables and Colums I changes to fix this.

Also if anyone has a suggestion as to how to fix this post conversion any faster then one message at a time I'd love to hear it.

Thanks again,
Russ

[andrea]

I had the same problem when my board was converted from 1 Gold to SE.

The Gold was on an NT server, the SE on Linux.

I made a script that converts all the usernames in the Gold files into lowercase. Run this before you convert to SE. This script is somewhere uploaded on the yabb.info site.  

[Jeff Lewis]

Yes you can do what Andrea says or you can run some queries on your database to convert the posts over. A simple update script or two should have you up and running in no time...

[andrea]

Here are the conversion scripts for the uppercase to lowercase of the login names of board members.

The first script is the main.
http://www.yabb.info/community/attachments/members_u2l.txt
Put some warnings in the script, since Joseph was afraid people could kill the board data. One runs the scripts on the 1 Gold board, before one runs the converter to SE.

Here the other half of the scripts.
http://www.yabb.info/community/attachments/members_u2l_msg.txt

If you have any questions about the script then just ask. Hope the scripts are helpful for you.

[andrea]

Yes you can do what Andrea says or you can run some queries on your database to convert the posts over. A simple update script or two should have you up and running in no time...

Are you sure this will do? Since the posts were converted to guest posts, the user id in the message table are all wrong. Don't see that simple mySql query converting that.

[Russ]

Awesome, thanks for the scripts.

Russ

[andrea]

You are welcome. I would be interested in the feedback, how the script worked.

[Jeff Lewis]

SQL queries can do anything I did some stuff like that here. I deleted my user name here once as well I used SQL queries to fix everything...however, I do suggest Andreas solution over the query one

[PioneeR]

I had a similar problem.

Out of 20,000 posts only 4 were wrong.

Somehow the memberid was wrong on the post.. membername was fine. Just used phpadmin to adjust. And all ok  

[andrea]

Without the members_u2l script, in my board half of the posts were wrong, because under Windows people did not have to take care for upper or lowercase when logging in. The application of the members_u2l script solved that problem, i.e. after the conversion to SE the post authors were the right ones.