vb.org Archive - View Single Post

BillB1 · #4 02-19-2022, 12:17 AM

Quote:

Originally Posted by snakes1100

Verify the charsets match for sql when you export it out of xampp server & the charsets match what xampp is when importing it into the host server.

character_set_client latin1
character_set_connection latin1
character_set_database latin1
character_set_results latin1
character_set_server latin1
character_set_system utf8

You could also try settings the charset in vb's config file.

Thank you for the promp reply!
I'll export the DB from Xampp following charset above, upload it to host and then restore.
I've noticed one difference: Xampp has MariaDB 10.1 while the host has MariaDB 10.2
I am not sure if this is what causing issues!

Thanks again
Bill

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

Quote:

Originally Posted by BulliM

Thereis an error in your header.

Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="En">

should be:

Code:

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="En">

And the content charset is...

Code:

content="text/html; charset=windows-1256"

Should be utf-8.

Thanks for the reply,
To be honest, I don't know where or how to do it, but I assume if I can get out of the gibberish, I'll be able to make these changes from admincp. correct?

Thanks again
Bill

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01091 seconds Memory Usage 1,766KB 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 (3)bbcode_code (2)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
Messages: