After Upgrade To SMF 2 My Member Names Became "????"!

[SAFAD]

This Is The Screen

[Norv]

Ah. But then, not only smf_members was affected, but at least smf_messages as well.

Please let's see what is intact:
Please check each table structure, to see if there is any column latin1.
Post here which are or were latin1, at lest we should know exactly what was damaged.

[SAFAD]

Now Its Impossible to remember
76 Table

Look I Remember Important things

Messages And Boards Were UTF8

Members And Member Groups Were Latin 1

Thats What I Remeber For Now

[Norv]

What character set has now smf_messages.poster_name? The column, not the table.
Please run:

Code Select Expand


show full columns from smf_messages;


[SAFAD]

Null
Utf8

[Norv]

I see, thank you.
Please, restore the copy made at the beginning of these tests.

On another note, the usernames are missing in any table.
You still have the emails, it seems, and the IPs, but not the usernames, nor the passwords, or it will look that way.
I would propose that we try inserting the email addresses in the name field, and write some warning on the login page about it. 
Like this: "Please reset your password", and after you receive the notification for the password, log in in the forum using your email address, not username".

Users can always set a different "display name", to be used, so that their email is not displayed anymore.

[SAFAD]

a great idea
but a failure success For The Ones Who Use Arabic On Pass !!!
ok ok thx for this bro
it took alooooot of time
thank u very much

[Arantor]

It shouldn't change their password at all; it's not stored in Arabic.

[Norv]

Note that the rest of the table must be at least cleaned up (from the "" in other fields) even if the email trick works for the moment. And then, usenames (the new usernames, well) need to be updated in posts as well.

[N3RVE]

I'm going through old 'unresolved' topics, do you require any further support?
If they are none, please mark this topic as solved to indicate

-[n3rve]