Errors in SQL File

  • Resolved Karin H Olsson

    (@kaolss)


    7 years ago

    Checking the sql-file for one of my sites
    INSERT INTO xxxxx_options VALUES(33, ‘permalink_structure’, ‘/{b4d3dcea7a9d931b0c7af8e515402636d879361049b4b285be482a3ac071e113}postname{b4d3dcea7a9d931b0c7af8e515402636d879361049b4b285be482a3ac071e113}/’, ‘yes’);

    WP 4.8.3
    TC 1.14.0
    Repo Dropbox

    Correct value is /%postname%/

    If I check older sql-files before updating to 1.14.0 they are correct.
    Karin

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter Karin H Olsson

    (@kaolss)

    I checked what will happen if I restored a site and it will be destroyed. The errors in the sql file seems to be everywhere a % should have been in the database tables

    After the restore the setting looks like this
    https://www.dropbox.com/s/am7lzwmsll96l7q/Screenshot%20from%202017-11-08%2016-25-54.png?dl=0

    Thamaraiselvam

    (@thamaraiselvam)

    Usually, We won’t change anything on your server while backing up database or files. Please check the other plugins could installed on your site which might have changed it. Also, check your current permalink_structure key in the wp_options table.

    Thread Starter Karin H Olsson

    (@kaolss)

    My permalink structure is correct
    It is when i use the restore it gets messed up.

    I checked the other sites where i use your plugin. 10 of 17 sites have strange strings in the backup file for the sql-dump. They are on different hosts.

    I have also checked the database, and the values in the tables are correct.

    The added strings in the sql-dump-file are always at the same length but contains a random value

    Plugin Author WPTimeCapsule

    (@wptimecapsule)

    Ah! That shouldn’t happen. Looks like a unique issue. Can you email us at help at wptimecapsule dot com? We would be glad to get this fixed. We may need access to your site to look into it. Hence interacting via email helps.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Errors in SQL File’ is closed to new replies.