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

[SAFAD]

Hi All
I Don't Know Why& How I Did This
I Just DId It
No Back Ups Nothing More Than My Dead Forum

All My Members Upgraded To ? Only The English Ones Didn't (Arabic )
But The Categories Topics Evrything Else was Good
I Entred Phpmyadmin
Then i Found Not All The Tables Are UTF8 They Was Latin1
i thinked About It A Lil
Then I Dicided To Convert To UTF8
There Was 76 Table
So I Mad A Script And Converted Em All In No Time :d

But At The End It Is All The Same
Please AnyOne Help Me
Best Regards

[Arantor]

How exactly did you perform the conversion?

[SAFAD]

uploaded full upgrade package from the download section
run upgrade.php
PS : I Didn't Find "Use UTF-8 Charset "Option When Converting
Then Delete Upgrade Files And See The New World

[Arantor]

You haven't answered my question: you've said you wrote a script to do the conversion:

So I Mad A Script And Converted Em All In No Time :d

What did this script have in it?

[SAFAD]

no
i didn't make a script to upgrade
i did it to convert charset to utf-8
and this after i did all the possible to fix it from the forums

this is the content

<?php
//connection code
mysql_connect("localhost","usr","pw");
mysql_select_db("db");

// convert code
$res = mysql_query("SHOW TABLES");
while ($row = mysql_fetch_array($res))
{
    foreach ($row as $key => $table)
    {
        mysql_query("ALTER TABLE " . $table . " CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci");
        echo $key . " =&gt; " . $table . " CONVERTED<br />";
    }
}
?>

thats all

[Arantor]

From phpMyAdmin, go into your database, and execute the following query and please tell me what it says.

Code Select Expand

SELECT * FROM smf_settings WHERE variable = 'global_character_set'

Of course if your table isn't called smf_settings, please edit the query to reflect the settings table.

[SAFAD]

From phpMyAdmin, go into your database, and execute the following query and please tell me what it says.

Code Select Expand

SELECT * FROM smf_settings WHERE variable = 'global_character_set'

Of course if your table isn't called smf_settings, please edit the query to reflect the settings table.

ok ok
but bro
i can handle silly things like

Of course if your table isn't called smf_settings, please edit the query to reflect the settings table.

:d:d:d

[SAFAD]

O
It Shows a table

variable is global_charcter_set
and value is UTF-8

[Norv]

Please check, for the tables that were utf8, what character set is set, for each of their text columns.
If there's a chance to recover the data, then each of the columns must also be converted.

But before doing this and any other operations, please, make a backup of the database, to avoid further losses.

[SAFAD]

I Didn't Understand You Correctly
There Was Alot Of Clomuns character set : latin1_swidish_ci
and some else : utf8_general_ci

Is This What Did You Mean ?

[Norv]

I'm afraid that is exactly what I meant, you still have columns that are latin1.

All these three must be utf8: the database itself, the tables (you made a conversion script for them), and the columns in the tables.

But please, before anything else, make a backup of the database.
Also, I understand you have no recent backup. But do you have an older backup? When was the last backup made?

[SAFAD]

hmmmm
i don't remember exact
but far long much that i can't back it up
more than 100 member registred (really rarly to hapen to me)
and maybe another more 200 topic

and don't think they are till now latin1
i converted em to UTF-8

I Will Make A BackUp & Wait The Next Step From You

[SAFAD]

done with the backup
whats next ?

[Norv]

Well, honestly I'm afraid the data that doesn't appear anymore in this database is already corrupted and cannot be recovered. So please keep that old backup at hand. You may need it.

But before giving up, I propose to try to make sure the conversion to utf8 is complete. (and maybe, just maybe there will be something that will prove the pessimism to be wrong.)

Please tell what the following query results in:

Code Select Expand


show create database your_database_name;


[SAFAD]

Its Allways On Hand
AnyWay
I Can't Create DB From Any PHP Script
Cuz My Acoun't Doesn't Have Previligies
I Can By My CPanel (Confixx)

[Norv]

Please, try running the statement. It only shows what "create database" did when the current database was created. It doesn't try to create another. (please replace "database_name" with your current database)

[SAFAD]

ah ok

CREATE DATABASE `:)` /*!40100 DEFAULT CHARACTER SET utf8 */

UTF-8

[Norv]

Okay.
Now, please select your database, and look at its "structure" in phpMyAdmin: you will see the list of tables.
You said before they are all utf8, can you please say though, which were latin1 ?

For each of them, please look at the table's structure. You will see the column definitions. Or, you can run:

Code Select Expand


show full columns from table_name;

Are there any of the columns latin1?

[SAFAD]

Members table was Latin1

there is no latin1
there is NULL
and UTF8_generale_ci

Here Is A Pic

[Norv]

Ah okay, thank you.

The data in this table, in phpMyAdmin, does it also show as " "? For all text-based columns, or only member names?