vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   DB Transfer Encoding issues (https://vborg.vbsupport.ru/showthread.php?t=326479)

msoms 06-18-2018 05:10 AM
DB Transfer Encoding issues
 
Hello,

I am facing an issue that took a while for me now and am not moving any where and got stuck. I have vB 4.2.5 with DB size of around 6.5 GB. I am changing to a new server and I have already migrated all my other sites (wordpress based) with no issues at all and they work just the way they should.

I followed the normal mysqldump commands to backup and restore several times and in several types however, the site will always show strange text encoding.
Both servers use MySQL correct versions and PHP7.
I can't seem to figure out what is wrong exactly.

The old server was CENTOS 6 with CPANEL and the new server is DEBIAN 9 with ISPCONFIG ,does that have any issue? Does MariaDB in new server has an effect on normal mysql in old server? both server encoding is UTF-8

I am lost and already initated a support request with vb team but no response till now.

Can you please help?

Dave 06-18-2018 06:48 AM
Where does it show the strange text encoding? Do you have a screenshot?
Do posts also look messed up? If you check the post table in the database, does it look fine there?

msoms 06-18-2018 07:04 AM
The whole site encoding is messed up! Not a single line is showing correctly, however on the db side it is ok.

I tried changing the charset for the installed languages and I can see some changes in the messed up text but no luck in making it work.

I will arrange for a screen shot in the mean while

snakes1100 06-18-2018 07:34 AM
Is there a php.ini in the domains public_html folder, verify it dont have a charset setting in it.

Plesk is known to do that with their inserting a charset by default in an account.

msoms 06-18-2018 07:58 AM
Quote:
Originally Posted by snakes1100 (Post 2595154)
Is there a php.ini in the domains public_html folder, verify it dont have a charset setting in it.

Plesk is known to do that with their inserting a charset by default in an account.
No there isn't, I am using ISPConfig 3 control panel not Plesk.

webmastersun 06-19-2018 01:39 AM
Quote:
Originally Posted by msoms (Post 2595151)
I followed the normal mysqldump commands to backup and restore several times and in several types however, the site will always show strange text encoding.
There are some works to do before moving your database to a new server that support and keep same encode, that is:
- Select utf8 unicode ci for your database.
- Enable force to use utf8 in your config file
- Change encode to utf8 in your tool/program that you are using to move your database.

This will help you to avoid errors about special characters/symbol when moving vB databases.

snakes1100 06-19-2018 06:41 AM
Quote:
Originally Posted by msoms (Post 2595155)
No there isn't, I am using ISPConfig 3 control panel not Plesk.
I didnt say you was using plesk.


All times are GMT. The time now is 05:34 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01053 seconds
  • Memory Usage 1,723KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete