Request for Help with Duplicator Migration Issues

  • Resolved innerlight

    (@chariotsoffire)


    1 year, 3 months ago

    Request for Help with Duplicator Migration Issues

    Hello, I migrated my WordPress site using Duplicator, but I encountered several problems. I need your help to solve them.

    1. Login Issue

    I tested login functions using Ultimate Member and Simple Member plugins. However, I found this problem:

    • Users are logged out on the front page. After logging in, if I go to the main page, I am automatically logged out.
    • Login works fine on the admin page. If I log in at mydomain/wp-admin, the session stays active.

    This may be caused by PHP sessions, cookies, or database migration issues.

    2. MySQL and MariaDB Version Difference

    • Previous server: MariaDB 11.3.2
    • Current server: MySQL 8.0.37

    During installation, I saw a warning about database compatibility issues. 3. Database Error Messages

    During the setup process, I got the following database errors:

    1) mysqldump Error

       DATABASE ERROR: 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump: Deprecated program name. It will be removed in a future release, use ' at line 3'
    • It seems that mysqldump is not compatible or contains incorrect SQL syntax.
    • However, I think this error happened on the source server while creating the backup. If so, it might not affect my current site.
    • Do you think this error is important? Should I be concerned about possible data corruption?

    2) time_zone Error

       DATABASE ERROR: 'Variable 'time_zone' can't be set to the value of 'NULL''
    • The time_zone variable is set to NULL, which causes an error.

    Is there a way to fix these errors when migrating from MariaDB to MySQL using Duplicator?
    I appreciate any help. Thank you!

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

    (@mohammedeisa)

    1 year, 3 months ago

    Hello @chariotsoffire ,

    Thanks for reaching out to us.

    1. Login Issue

    Duplicator Pro doesn’t affect the login/logout process of your website. This may be one of the following:

    • A caching issue:
      If it’s a caching issue, please purge the website and server cache and check if the issue gets resolved
    • Custom coding
      If there is custom code hooks into the login/logout processes, please check this code and correct it
    • Plugin Misconfiguration
      If a plugin manages the login/logout processes, please check the settings of this plugin and correct them.

    2. MySQL and MariaDB Version Difference

    It’s recommended to migrate the website using the same PHP and database engines. Can you please switch the database engine on the destination website to MariaDB 11.3.2 and retry the backup restoration?

    I hope this helps, and I’m looking forward to hearing back from you.

    Thanks!

    Thread Starter innerlight

    (@chariotsoffire)

    1 year, 3 months ago

    Hello,

    Thank you for your reply. I have two updates about the issues I reported.

    1. Login Issue:

    The login issue is now fixed. I changed the Ultimate Member plugin to the WP User Manager plugin. After changing the plugin, the login problem went away.

    2. MySQL and MariaDB Version Difference:

    I talked to my hosting company, DreamHost, about the MySQL and MariaDB version difference. They said they cannot fix this problem. Also, they are not sure what will happen in the future.

    Thank you for your time and help.

    Plugin Support mohammedeisa

    (@mohammedeisa)

    1 year, 2 months ago

    Hi @chariotsoffire ,

    I’m happy that you resolved the login issue. About the database issue, I can try to resolve this problem for you by restoring the backup for you and providing you with another backup that works with your desired database engine.

    To ensure your data 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)

    1 year, 2 months ago

    Hi @chariotsoffire ,

    We haven’t heard back from you in a few days, so I’m going to go ahead and close this thread for now. But if you’d like us to assist further, please feel welcome to continue the conversation.

    Thanks! 

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Request for Help with Duplicator Migration Issues’ is closed to new replies.