Different PHP version between local and server

  • Resolved bruniki

    (@bruniki)


    8 years, 1 month ago

    Hi,

    There is a NOTICE when I tray to duplicate webs from local to server. And doens’t work fine the duplication

    Version: This Server: [5.5.31] — Package Server: [5.6.16]
    NOTICE: In order to avoid database incompatibility issues make sure the database versions between the build and installer servers are as close as possible. If the package was created on a newer database version than where it is being installed then you might run into issues.

    It is best to make sure the server where the installer is running has the same or higher version number than where it was built. If the major and minor version are the same or close for example [5.7 to 5.6], then the migration should work without issues. A version pair of [5.7 to 5.1] is more likely to cause issues unless you have a very simple setup. If the versions are too far apart work with your hosting provider to upgrade the MySQL engine on this server.

Viewing 10 replies - 1 through 10 (of 10 total)
  • Thread Starter bruniki

    (@bruniki)

    The problem is with the MySQL version

    Hey @bruniki,

    What kind of issues are you experiencing after the install? Does the installer-log.txt have an error messages? Please use caution to not post any sensitive data…

    Thanks~

    Thread Starter bruniki

    (@bruniki)

    Hi,

    When you finish de process and go to wp-admin is like a new WP installation. Starts with the name for web, description, user, password…any page, post or puglin keeps, only the theme.

    *Write some Errors*

    Deploy Errors: (938) Update Notices: (0) General Notices: (0)

    **ERROR** database error write ‘Unknown collation: ‘_unicode_520_ci” – [sql=
    CREATE TABLE _commentmeta (
    meta_id bigint(20) unsigned NOT NULL A…]

    **ERROR** database error write ‘Table ‘_options’ doesn’t exist’ – [sql=
    /* INSERT TABLE DATA: _options */
    INSERT INTO _options VALUES(“1”, “…]
    **ERROR** database error write ‘Table ‘_options’ doesn’t exist’ – [sql=INSERT INTO _options VALUES(“2”, “home”, “https://localhost”, “yes”)…]

    Thread Starter bruniki

    (@bruniki)

    More info

    Common Fixes:
    Query size limits: Update your MySQL server with the max_allowed_packet setting to handle larger payloads.

    Thread Starter bruniki

    (@bruniki)

    I used duplicator in this server for months and always has worked fine

    Hey bruniki,

    Nothing has changed with Duplicator, the underlying issue has to do with a change incompatibility on the server your trying to move to. The server where you build the package has had its table collation changed and now supports the newer collation ‘_unicode_520_ci’. The collation may have changed when you updated WordPress or could have been updated by your host.

    The other server where you are moving the site to doesn’t support the newer table collation, therefore you are seeing these errors… I believe this FAQ item may help or provide some clues about this issue:

    -> Browse to: https://lifeinthegrid.com/duplicator-faq
    -> Find question: “I’m getting a ‘Unknown collation’ error, what should I do?”

    Let me know if this helps!

    Thread Starter bruniki

    (@bruniki)

    Hi,

    I tried option 2 and 3 but didn’t work.
    I’ve tested with old XAMP version and duplicator works perfectly.
    I’ll open a ticket with hosting to update MySQL version.

    Thanks a lot for your help

    No Problem, thanks for the update!

    Thread Starter bruniki

    (@bruniki)

    Hi,

    New MySQL verion and working perfectly!

    Thanks again and regards,

    Excellent! Glad you got it working…

    Cheers~

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Different PHP version between local and server’ is closed to new replies.