View Single Post
  #8  
Old 02-20-2022, 09:47 PM
BillB1 BillB1 is offline
 
Join Date: Jan 2022
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by socialteenz View Post
Create a blank index.php file to your root to prevent your files from appearing on the root (https://dantdubai.org)
Sure thing, and thanks for the heads-up

--------------- Added [DATE]1645404853[/DATE] at [TIME]1645404853[/TIME] ---------------

Updating the topic in case someone faces a similar Charset issue with non english language.
After going through so many suggestions, forums, and stackoverflow
especially this Hell of Latin1 vs. utf8 arguments, I feel silly.

The reason why I had all these ?????? and Gibberish characters was the very Locale
setting on the Centos7 server.

This is how it was solved:
logged in as root> terminal
# yum update
# localectl status
checked the system locale:
# cat /etc/locale.conf
list available locale on server:
# localectl list-locales | grep en_
pick AR support locale:
# localectl set-locale LANG=<<locale_name>>
and confirm
# localectl status.

Then I importing the same OLD Latin1 database charset and collation.
Since Arabic is not my language, I copied several pages worth of global phrases from xampp
and pasted them into global phrases on the host, charset is just fine!
https://dantdubai.org/vb/

Still not out of the woods yet, Next step:
Restore about 90.000 users with 1.3 million posts.
I'll stay with vb3.8 to see if impex is up to the task.
Had anyone tried impex to selectively import some tables and exclude old styles, language pack, outdated mods etc?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04022 seconds
  • Memory Usage 1,763KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete