Title: Errors in SQL File
Last modified: November 7, 2017

---

# Errors in SQL File

 *  Resolved [Karin H Olsson](https://wordpress.org/support/users/kaolss/)
 * (@kaolss)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/errors-in-sql-file/)
 * 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](https://wordpress.org/support/users/kaolss/)
 * (@kaolss)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/errors-in-sql-file/#post-9663204)
 * 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](https://www.dropbox.com/s/am7lzwmsll96l7q/Screenshot%20from%202017-11-08%2016-25-54.png?dl=0)
 *  [Thamaraiselvam](https://wordpress.org/support/users/thamaraiselvam/)
 * (@thamaraiselvam)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/errors-in-sql-file/#post-9663241)
 * 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](https://wordpress.org/support/users/kaolss/)
 * (@kaolss)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/errors-in-sql-file/#post-9666861)
 * 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](https://wordpress.org/support/users/wptimecapsule/)
 * (@wptimecapsule)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/errors-in-sql-file/#post-9667124)
 * 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.
    -  This reply was modified 8 years, 6 months ago by [WPTimeCapsule](https://wordpress.org/support/users/wptimecapsule/).

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

The topic ‘Errors in SQL File’ is closed to new replies.

 * ![](https://ps.w.org/wp-time-capsule/assets/icon-256x256.png?rev=1614914)
 * [Backup and Staging by WP Time Capsule](https://wordpress.org/plugins/wp-time-capsule/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-time-capsule/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-time-capsule/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-time-capsule/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-time-capsule/reviews/)

 * 4 replies
 * 3 participants
 * Last reply from: [WPTimeCapsule](https://wordpress.org/support/users/wptimecapsule/)
 * Last activity: [8 years, 6 months ago](https://wordpress.org/support/topic/errors-in-sql-file/#post-9667124)
 * Status: resolved