MyBB Community Forums

Full Version: Problem Convert from VB to Mybb
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello all ...

Mybb : 1.6.3
Merge : 1.6.1

i have problem converting VB4 datebase (it was vb 3 last year we upgrade to vb 4) to Mybb 1.6.3

most of things returned But The Problem is with encoding

its arabic forum ( arabic name users, posts and threads)

its shows me symbols & unknowns things
------
when i open the backup with text editor :

1st line :
MySQL dump 10.13  Distrib 5.1.56, for unknown-linux-gnu (x86_64)

------
some misc info from inside backup :

/*!40101 SET character_set_client = utf8 */;

ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

-----

Any english words from the backup it shows ok without problem just the arabic words shows symbols things

example :
ÇáãäÊÏì ÇáÚÇã
 ÇáãÑßÈÜÇÊ æÇáÓíÇÑÇÊ ÇáãÚÏáÉ 




More Info about mybb database mysql :

i create new database with collation utf8_general_ci

More info about mybb merge :

when i run merge for Database i selected encoding UTF8

& i tried both (yes) & (No) choice for convert tables to UTF8 messages


Note : If there is more info needed form me tell me about it !


My Regards ...


EDIT :

more info inside phpmyadmin :

the collation of tables is : latin1_swedish_ci



i also restored the backup in my local pc but same forum (VB) it returned like same as in hosting before

i did that to make sure the database not broken or wrong converting


wow over 22,000 views

and there no reply !

that's sad Sad
vB4 is not officially supported at this time.

However your problem is caused by not correctly setting the table & database encoding for the source database when you run the DB Configuration step. Please make sure the drop down box is set to the correct table encoding. If this still doesn't work for you, try turning off the Convert to UTF8 checkbox on the same page.

You will need to restore MyBB to a pre-merge backup and merge again for this to take effect.
so what i have gonna to do is

1- create new databse with what collation i choose (in phphmyadmin) or just leave it as default without change collation ?

2- reinstall mybb & set encoding (what i should select ) ?

3- merge again & choose what encoding also ?

i will choose both utf converting turned on & off.

i just need a clear steps to try , because i spent over 5 days doing this.

==== Problem Resolved ====


Now i have problem with language encoding because i change the encoding of language forum to show the encoding correctly ( change client browsers encoding)