vb.org Archive - Administrative and Maintenance Tools

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Administrative and Maintenance Tools - UTF-8 Coallition Conversion (https://vborg.vbsupport.ru/showthread.php?t=282183)

Quote:

Originally Posted by Boofo (Post 2324541)

I guess I was referring to running it in case there were a few table that weren't set as UTF-8, for whatever reason. Does this also set the default collation to UTF-8 for the whole db?

Yes, that will set the collation to utf-8 for the entire database.

Quote:

Originally Posted by Merjawy (Post 2324598)

I take it back :(

After checking the site again this morning.. I found few issues
1- Although all tables in db have been converted to UTF-8, the sum at the buttom still shows the total tables are still "latin"

2- Arabic language got totally messed up in Mobile styles

3- when I tried to upgrade to latest release 4.1.12PL1, it hung at 41%, had to rerun upgrade script to get it done.

4- Arabic language with all different settings became garbage (windows-1256 and UTF-8)

I even installed a UTF-8 Arabic file that I use on another site and it didn't display right.

That's my latest report.. I am going back to reload the backup and finish my upgrade.. Thanks anyway.. I will try to play with this again later after I am done with restoring my site and getting it back running.

Regards

Thank you for your report. I have tried this tool on several sites, small and medium ones, and I never encountered any issues during my tests. It converted the collation character as it was supposed to and the special characters worked properly.

About the upgrade hang up that you describe, I do not think it is related to my mod as it has nothing to do with that part.

But as long as a database backup is made beforehand then you are covered as you can easily revert back in case of any issues.

I have a forum with +0.5 million posts. I will copy the forum to another database now and start my test for this mod.

BRB

Completed

Actually this product is converting only the structure without the content
After complete try to enter the database from phpmyadmin and read the (post) table, still you cannot read the special characters, what this mod did is the same when you open the database and change the charset for all tables manually.

We need to develop something like this:
https://vborg.vbsupport.ru/showthread.php?t=118308
http://www.vcharset.com/

With that mod you will be able to convert the database to UTF-8 and you can read all the special characters from phpmyadmin which means both structure and content has been converted.

Can you please download the new package that I attached and give it another go?

P.s. Does your forum language support utf-8 btw?

Quote:

Originally Posted by sadiq6210 (Post 2324666)

Actually this product is converting only the structure without the content
After complete try to enter the database from phpmyadmin and read the (post) table, still you cannot read the special characters, what this mod did is the same when you open the database and change the charset for all tables manually.

This is true, I was expecting more from this product. It did change the charsets, but content remains the same. Conversion was successful, no problems so far...

Hi Borbole

I test this on a test site, I was having problems with weird character sets within the forum. This hack has removed them ok, just one thing it has replace all the weird characters to a ? is there a way to fix this?

I would like to run this on the live forum.

Regards,
Dave

Wow, What an excellent job! Borbole sir! I am not going to use this now, but I def gave it a 5 Stars, because this will help may out with their forums! Thanks for your amazing work and contribution!

Regards CM

Is there any reason/benefit to doing this?

I have installed vb 5.4. If i use the app are not displayed correctly charachters à ù è ò
This files xml works for vb 5.4?

Quote:

Originally Posted by migratoria (Post 2593639)

I have installed vb 5.4. If i use the app are not displayed correctly charachters ? ? ? ?
This files xml works for vb 5.4?

No, this product is designed to work with vB 4.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01066 seconds Memory Usage 1,740KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: