I’m so exited and happy about the new version of vCC. I rewrote it from the ground up, and almost approached the Gold version. but I chose to consider it as beta release, because it needs more testing.
New features included:
- The process is totally automated, your turn is to install the script, modify settings to suite your needs, start the conversion and stand by.
- If accidentally, the process had been interrupted, return to the start screen, click start to continue from the interruption point.
- vCC analyzes the database and decides what tables to convert, no matter how many or what mods or ad-ons you have installed.
- vCC converts the collation of the database to suite your new charset for better database functionality. Of course you have to choose the appropriate collation for your new charset (easy step in most cases). Thanks to El_Muerte who donated the main code for this.
- Even if you had converted using a previous version of vCC which unfortunately doesn’t converts the collation, there is a new option to update the collation only.
- A small final report. yet to be improved.
Things to remember:
- Always do multiple tests using a test board and a shot of your database.
- Don’t convert your live public board, before you get convenient with the test conversions.
- Always have backups, they are the only rescue for you in case of database damage.
- Read every page (License, FAQs, etc..) in this site to completely understand what you are about to do.
- If you don’t know what to do, then don’t hesitate and hire me to get more professional results.
Give thanks back:
There are many ways to thank my efforts. may be a PayPal shot, an article about vCC or even about me to spread the word 
, hiring me to convert your database or a link back to this site.
Please try it and write your feedback, and report bugs & errors.
Best Regards
I’m sooo glad to read this. Thank you! Let’s dance..
I\’ve tested it an I see two issues.
First, it will convert all tables within the database, it apparently ignores the set table prefix. Quite some users have multiple applications using the same database but with different prefixes. I think it\’s better to check for the prefix (if there is any).
Secondly, it converts all data even if it\’s not needed in the first place. The mod I\’m working on (vbDrupal) already has all its data in utf8. Converting it again will of course result in broken content.
So it might be best to have a user selection of tables to convert when suspicious tables have been found:
- tables without the same prefix as vBulletin
- tables that already have the collation set to utf8
Of course it\’s always useful to allow the user to (de)select tables to convert.
For got mention this, the conversion time is not correct.
It reported:
Conversion had been completed, it took 4 hour(s), 6 minute(s) and 21 second(s).
And I am pretty sure that I did not wait 4 hours. It took only a few minutes (test forum did not have much data).
Thank you, elmuerte.
I’ll do a check against the TABLE_PREFIX, if (TABLE_PREFIX != ”), I’ll suggest only prefixed table to be converted.
It converts every table even if it doesn’t need, because I had to get red of the legacy demanded inputs for non-default tables by the user. There are a wide range of hacks that add many alterations to the database, some of them add columns not tables, then the instructions have to includes: “add the column X to the table Y” which is already decided to be converted by vCC. I realized that I can’t provide instructions for all hacks and mods.
Anyway, I’ll allow user to see a suggested list of tables, and user will be able to check / un-check the tables, according to his database structures.
Thanks again
It would be great if the script can automatically convert database encoded in latin-1 with English and Asian Chars to UTF-8
while you use unified HTML charset for all of your languages, There is no problem for English chars in a non-English forum.
when can we expect the next release?
I can’t give a certain date.
Hey
Awesome script. Just did a test run on my forum. Found only one issue.
It does not let me choose collation. It will only let me choose charset. After conversion the collation defaults to utf8_generic_ci, but I need it to be utf8_danish_ci.
I noticed that your SQL statements only do \
اخى ميلاد انا ركب الاسكربت ولا حصل معى
The iconv PHP module isn’t presented, please contact your system administrator to enable/install it.
ممكن تحلها لى
هذا يعني أن ألـ
iconv
غير منصب في السيرفر لديك، أطلب من شركة الاستضافة أن تضيفه … وهو عبارة عن
PHP extension
any comment
السلام عليكم
أخي ميلاد أولا أشكرك على هذا الإنجاز
ثانيا أنا عندي منتدى باللغة الأوردو
واللغة هذي ما تشتغل إلى على ترميز utf-8
انا يوم انشأت قاعدة بيانات على الموقع ما كنت أدري والحين أكشتفت ان ترميز القاعدة هي latin1_swedish_ci
برأيك ماذا أفعل اللآن؟؟؟
هل يممكنني تحويل ترميز القاعدة الحاليه الى ترميز utf-8 بهذا السكربت؟
ياريت لو في شرح بالعربي أو راسلني على بريدي
أخي أنت تخلط بين ترميز القاعدة والـ collation في قاعدة البيانات
أنت تحتاج إلى تحويل الـ collation فقط
وهذا يحدث باختيار نعم بالنسبة للخيار الرابع
مرحبا ..
انا عندي منتدى 3.7.3 في بي ..
بس ما مشي حال التحويل ..
وقت بيوصل لعند الـ datastore بيطول كتير و بعدا بيطلع خطأ..
vBulletin datastore error caused by one or more of the following:
You may have uploaded vBulletin 3.6 files without also running the vBulletin upgrade script. If you have not run the upgrade script, do so now.
The datastore cache may have been corrupted. Run Rebuild Bitfields from tools.php, which you can upload from the do_not_upload folder of the vBulletin package.
Fatal error: vBulletin datastore cache incomplete or corrupt in \includes\init.php on line 203