Title: Database error and serialize() errors during change session
Last modified: April 17, 2020

---

# Database error and serialize() errors during change session

 *  [Ambyomoron](https://wordpress.org/support/users/josiah-s-carberry/)
 * (@josiah-s-carberry)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/database-error-and-serialize-errors-during-change-session/)
 * Using plugin ver.
    Using WordPress ver. 5.4 I recently ran the plugin and had
   a large number of errors displayed, of two types: 1) Database error Example:
 *     ```
       WordPress 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 's assumptions about the value of releases https://newurl.com/?p=902";}}' WHER' at line 1]
       UPDATE wp_postmeta SET meta_value = 'a:1:{s:7:"twitter";a:1:{i:262062959;s:128:"Releases and Changes: How agile methods have changed ITIL's assumptions about the value of releases https://newurl.com/?p=902";}}' WHERE meta_id = 4923
       ```
   
 * The value that should have been changed in that record is:
    `a:1:{s:7:"twitter";
   a:1:{i:262062959;s:125:"Releases and Changes: How agile methods have changed 
   ITIL's assumptions about the value of releases https://oldurl.com/?p=902";}}`
 * Here is another example of a meta_value field in wp_postmeta that should have
   been changed, but was not:
    `a:1:{s:7:"twitter";a:1:{i:262062959;s:135:"Psychology
   and Service Management: what can we learn in service mgmt from Kahneman's Thinking,
   Fast and Slow? https://oldurl.com/?p=853";}}`
 * 2) Unserialize()
    Example: Notice: unserialize(): Error at offset 4283 of 6738
   bytes in /blahblah/wp-content/plugins/velvet-blues-update-urls/velvet-blues-update-
   urls.php on line 91
 * There were about 25 errors of this type
 * The summary screen for the session did not show any information about errors.
   I would have expected there to be a line stating that ‘x updates failed’ or something
   of the sort.

The topic ‘Database error and serialize() errors during change session’ is closed
to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/velvet-blues-update-urls_727172.svg)
 * [Velvet Blues Update URLs](https://wordpress.org/plugins/velvet-blues-update-urls/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/velvet-blues-update-urls/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/velvet-blues-update-urls/)
 * [Active Topics](https://wordpress.org/support/plugin/velvet-blues-update-urls/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/velvet-blues-update-urls/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/velvet-blues-update-urls/reviews/)

## Tags

 * [Database Error](https://wordpress.org/support/topic-tag/database-error/)
 * [serialize](https://wordpress.org/support/topic-tag/serialize/)
 * [wp_postmeta](https://wordpress.org/support/topic-tag/wp_postmeta/)

 * 0 replies
 * 1 participant
 * Last reply from: [Ambyomoron](https://wordpress.org/support/users/josiah-s-carberry/)
 * Last activity: [6 years, 1 month ago](https://wordpress.org/support/topic/database-error-and-serialize-errors-during-change-session/)
 * Status: not resolved