Wrong character set after restore

  • Resolved wsoftware

    (@wsoftware)


    1 year, 2 months ago

    I updated my site with WP6.3 and some plugins earlier today. Then I discovered an error on the site related to a Envira gallery plugin and was forced to restore. I always take a Duplicator backup before any updates of course so I could just use this backup created 10 min before.

    After restore I discovered that alla the special characters in the Swedish language (???) was replaced with junk characters in the whole site. I then tried to restore to a backup from previous update in May (4 months ago) but the same error still remained.

    I was able to climb out of this shit by using my hosting providers daily SQL dump file from yesterday, then the Swedish characters returned.

    What could possibly gone wrong? I can recreate the error so there is some error in my Duplicator packages but I cannot find any clues in my settings.

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Support mohammedeisa

    (@mohammedeisa)

    Hi @wsoftware ,

    Thanks for reaching out to Duplicator Support.

    This issue is related to the database charset and collation.

    You need to select the proper charset and collation during the backup restoration.

    This screenshot shows how to select the charset and collation during the backup restoration.
    https://a.supportally.com/i/3UlySm

    Note: To change the Charset and Collation, you need to enable the advanced mode in the first step of the installer from the top right of the page, proceed until step 2 and you will be able to change the charset and collation

    Thanks!

    Thread Starter wsoftware

    (@wsoftware)

    Thanks for reply, I will try.

    Has there been a change of default settings in recently updates or why have this problem started now?

    Plugin Support mohammedeisa

    (@mohammedeisa)

    Hi?@wsoftware?,

    This is the standard behavior of Duplicator and is not indicative of an issue with the plugin itself. The challenge arises from migrating between databases with differing charset and collation settings, leading to migration difficulties.

    Thread Starter wsoftware

    (@wsoftware)

    Ok, I have to try to see if I can avoid this problem using some other charset on backup/restore then.

    But I only did a backup and a restore from the same database, on the same site and on the same hosting provider. Maybe a half hour in between backup/restore and did only update WP and some plugins. I have done exactly the same backup-update-restore process before summer with no problems so I suspected some change in your default settings.

    Plugin Support mohammedeisa

    (@mohammedeisa)

    Hi @wsoftware ,

    We understand that you’re facing an issue that requires further investigation, and it may involve sharing log files containing sensitive information about your website. Unfortunately, such sharing is not allowed in www.remarpro.com forums for security reasons.

    To ensure your privacy and get the necessary support, kindly contact us through the form on our Contact Us page, and we’ll be more than happy to assist you promptly:

    https://duplicator.com/contact/?form=1

    Looking forward to hearing back from you.

    Thanks!

    Plugin Support mohammedeisa

    (@mohammedeisa)

    Hi @wsoftware ,

    I’m closing this support topic for inactivity. Please don’t hesitate to contact us in a Support Topic if you need any help with Duplicator.

    Thanks! 

    I had the same problem and kept reading about changing the encoding in the advanced section but as far as I can tell, this option is only available in the Pro version of Duplicator. This points to something having been changed in the defaults and, as a result, in my case at least, Duplicator has become unusable.

    Such a shame. It is the best plugin of its kind out there.

    Plugin Support mohammedeisa

    (@mohammedeisa)

    Hi @thevp1,

    I’m sorry to see that you encountered a problem using Duplicator.

    Investigating this issue requires sharing sensitive data about your website which is not recommended for your website’s security and it’s not permitted in this forum.

    Kindly, contact us through this form and be assured that we will do our best to help you:
    https://duplicator.com/contact/?form=1

    I’m looking forward to hearing back from you.

    Thanks!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Wrong character set after restore’ is closed to new replies.