Header disapeared problem with encodin chars

This topic has 11 replies, 4 voices, and was last updated 6 months, 3 weeks ago ago by Andrew Mitchell

  • Avatar: Jordan
    Jordan
    Participant
    May 15, 2024 at 17:14

    I am experiencing problems with my website. Firstly, my website’s header has disappeared. Secondly, after migrating the website, some Cyrillic characters are being replaced with symbols for certain words.

    Currently, in my wp-config file, I have the following setting:
    /** Database charset to use in creating database tables. */
    define( ‘DB_CHARSET’, ‘cp1251’ );

    I’ve read that it should be changed to UTF-8, but when I make this change, all the characters on the website turn into symbols, and the header also disappears. I need help with restoring the header and guidance on how to correctly convert to UTF-8 to avoid seeing symbols instead of the Cyrillic characters like И at the beginning of the word

    Please, contact administrator
    for this information.
    Files is visible for topic creator and
    support staff only.
    10 Answers
    Avatar: Rose Tyler
    Rose Tyler
    Support staff
    May 16, 2024 at 07:05

    Hello, Jordan,

    Thank you for reaching out to us with your concerns regarding your website.

    To assist you more effectively, we kindly request the following information:

    1. Please provide the URL of the page from which the screenshot was taken where the issue is visible.

    2. We were unable to log in using the credentials provided in the Private Content area. Could you please verify these details and provide the correct wp-admin access?

    We appreciate your cooperation.

    Best Regards,
    8Theme’s Team

    Avatar: Jordan
    Jordan
    Participant
    May 16, 2024 at 14:02

    Yes of course, because of the fact your team didn’t respond super fast I’ve restored a backed up version of the website in order to show my header again and forgot to recreate your credentials. I apologies for that inconvenience. In many pages there are symbols instead of Cyrillic letters but I’m going to give you one or two so its easier for you to find
    The thing is that it is showing only word starting with the letter “И”(i) the character И(i) as symbol:
    https://gourmanic.bg/blog/
    https://gourmanic.bg/istinskata-cherna-havajska-sol-morska/
    If you need I can provide you ftp credentials as well

    Please contact administrator
    for this information.
    Avatar: Rose Tyler
    Rose Tyler
    Support staff
    May 16, 2024 at 14:21

    Hello, Jordan,

    Thank you for wp-admin access, please provide FTP access also.

    Best Regards,
    8Theme’s Team

    Avatar: Jordan
    Jordan
    Participant
    May 16, 2024 at 15:34

    Sure!
    I can provide credentials for the cPanel as well, if its easier for you?

    Please contact administrator
    for this information.
    Avatar: Justin
    Luca Rossi
    Support staff
    May 17, 2024 at 08:58

    Dear Jordan,

    We hope this message finds you well. Could you please specify which texts are currently experiencing issues?

    We would like to address these concerns by editing the texts accordingly. We have successfully made edits in one category, which appears to be functioning correctly, as shown here: https://prnt.sc/zVpw5e-lUAg0.

    Thank you for your attention to this matter.

    Best regards,
    8Theme’s Team

    Avatar: Jordan
    Jordan
    Participant
    May 17, 2024 at 10:56

    Yea sure, well, there is on many places, for example when i transferred the website everything looked good, something happened and now a blog post with slug istinskata-cherna-havajska-sol-morska has no title, but when try to edit the name to : “Истинската черна хавайса сол морска” in the blog post itself it the И is becoming as symbol but when i check all the blog posts it is still as (no title) that’s why i think i have to convert to utf-8. And its shown on many places, blog posts products etc.

    Files is visible for topic creator and
    support staff only.
    Avatar: Justin
    Luca Rossi
    Support staff
    May 17, 2024 at 14:11

    Dear Jordan,

    We are reaching out to request your assistance in drafting some texts for testing purposes. Could you please help us by writing these texts and advising on their appropriate placement?

    Thank you in advance for your cooperation.

    Best Regards,
    8Theme’s Team

    Avatar: Jordan
    Jordan
    Participant
    May 17, 2024 at 15:09

    The problem is everywhere when you start the word with the symbol “И”
    Try to make a post and or product starting with “И”
    Example : Искам да направя изпитание на сайта

    Avatar: Jordan
    Jordan
    Participant
    May 20, 2024 at 10:20

    Any updates?

    Avatar: Andrew Mitchell
    Andrew Mitchell
    Support staff
    May 20, 2024 at 14:10

    Hello, Jordan,

    I hope this message finds you well. Unfortunately, the changes you requested cannot be implemented directly as they involve complex modifications not only to the WordPress encoding but also to the database encoding.

    It is advisable not to perform such modifications on the live site, as they will affect the database directly. Instead, I recommend creating a staging environment – a complete copy of your current website – where these changes can be safely implemented.

    After updating the values in wp-config fromdefine( ‘DB_CHARSET’, ‘cp1251’ ); to define( ‘DB_CHARSET’, ‘utf8mb4’ );, the following code will need to be executed:

    
    SET @DATABASE_NAME = 'your_database_name';
    
    -- Change database character set
    ALTER DATABASE @DATABASE_NAME CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    
    -- Generate ALTER TABLE commands for all tables
    SELECT CONCAT('ALTER TABLE ', table_name, ' CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;') 
    FROM information_schema.tables 
    WHERE table_schema = @DATABASE_NAME;
    
    -- Generate ALTER TABLE MODIFY commands for all text columns in each table
    SELECT CONCAT('ALTER TABLE ', table_name, ' MODIFY ', column_name, ' ', column_type, ' CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;') 
    FROM information_schema.columns 
    WHERE table_schema = @DATABASE_NAME 
    AND data_type IN ('char', 'varchar', 'text', 'tinytext', 'mediumtext', 'longtext');
    

    However, it would be best if these tasks were carried out by a system administrator to ensure accuracy and to prevent any potential issues.

    Thank you for your understanding and cooperation. Should you have any further questions or require assistance, please do not hesitate to contact us.

    Best Regards,
    8Theme’s Team

  • Viewing 11 results - 1 through 11 (of 11 total)

You must be logged in to reply to this topic.Log in/Sign up

We're using our own and third-party cookies to improve your experience and our website. Keep on browsing to accept our cookie policy.