Return to previous page

Header disapeared problem with encodin chars

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

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.

#395341 Copied Theme version: 9.3.9

10 Answers

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

#395396 Copied

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.

#395491 Copied

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

#395497 Copied

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.

#395507 Copied

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

#395573 Copied

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.

#395602 Copied

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

#395638 Copied

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 : Искам да направя изпитание на сайта

#395656 Copied

Jordan

Participant

May 20, 2024 at 10:20

Any updates?

#395933 Copied
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
#395978 Copied
Tagged: encoding characters solution, encoding chars problem, header disappearance issue, resolve header disappearance, woocommerce theme fixes, wordpress troubleshooting, wordpress woocommerce themes
Viewing 11 results - 1 through 11 (of 11 total)