This topic has 11 replies, 4 voices, and was last updated 6 months, 3 weeks ago ago by Andrew Mitchell
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
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
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
Hello, Jordan,
Thank you for wp-admin access, please provide FTP access also.
Best Regards,
8Theme’s Team
Sure!
I can provide credentials for the cPanel as well, if its easier for you?
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
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.
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
The problem is everywhere when you start the word with the symbol “И”
Try to make a post and or product starting with “И”
Example : Искам да направя изпитание на сайта
Any updates?
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
You must be logged in to reply to this topic.Log in/Sign up