Title: Extra Characters added when inserting value
Last modified: August 24, 2016

---

# Extra Characters added when inserting value

 *  [hardprod67](https://wordpress.org/support/users/hardprod67/)
 * (@hardprod67)
 * [11 years ago](https://wordpress.org/support/topic/extra-characters-added-when-inserting-value/)
 * I have a huge problem and I am not sure how to fix it. I have found your tool
   very useful but I have an issue that doesn’t want to cooperate.
 * I am trying to use your bulk edit tool to change the cmsms_custom_breadcrumbs
   field. Its a breadcrumb issue.
    I use the tool to sort by category, let’s say
   MK Patterns.
 * I put in the custom feild name: cmsms_custom_breadcrumbs
 * Then I put the value, which I did by hand for this category.
 * a:3:{i:1;a:2:{i:0;s:21:”Knitters Edge Members”;i:1;s:42:”[http://knittersedge.jsullivan.net/members/&#8221](http://knittersedge.jsullivan.net/members/&#8221);;}
   i:2;a:2:{i:0;s:21:”Machine Knitting Room”;i:1;s:64:”[http://knittersedge.jsullivan.net/members/machine-knitting-room/&#8221](http://knittersedge.jsullivan.net/members/machine-knitting-room/&#8221);;}
   i:3;a:2:{i:0;s:25:”Machine Knitting Patterns”;i:1;s:90:”[http://knittersedge.jsullivan.net/members/machine-knitting-room/machine-knitting-patterns/&#8221](http://knittersedge.jsullivan.net/members/machine-knitting-room/machine-knitting-patterns/&#8221);;}}
 * But the bulk tool inserts the following:
    s:371:”a:3:{i:1;a:2:{i:0;s:21:”Knitters
   Edge Members”;i:1;s:42:”[http://knittersedge.jsullivan.net/members/&#8221](http://knittersedge.jsullivan.net/members/&#8221);;}
   i:2;a:2:{i:0;s:21:”Machine Knitting Room”;i:1;s:64:”[http://knittersedge.jsullivan.net/members/machine-knitting-room/&#8221](http://knittersedge.jsullivan.net/members/machine-knitting-room/&#8221);;}
   i:3;a:2:{i:0;s:25:”Machine Knitting Patterns”;i:1;s:90:”[http://knittersedge.jsullivan.net/members/machine-knitting-room/machine-knitting-patterns/&#8221](http://knittersedge.jsullivan.net/members/machine-knitting-room/machine-knitting-patterns/&#8221);;}}”;
 * At the beginning of the string it adds this: s:371:”
    At the end it adds this:“;
 * If I go in via phpmyadmin and edit it manually to the correct string it works.
 * I notice when I look at the db structure via phpmyadmin I see the queries are
   converting it to utf8 for my view.
    Could it have something to do with that?
 * If I knew how to write the correct sql query to define the category (like the
   bulk edit tool) and how to pull the cmsms_custom_breadcrumbs I might be able 
   to do it in mysql instead of the tool.
 * I have a ton of pages to do this on and manually isnt’ really an option.
 * I hope you can help me figure out why it’s adding the extra text.
 * [https://wordpress.org/plugins/custom-field-bulk-editor/](https://wordpress.org/plugins/custom-field-bulk-editor/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [sparkweb](https://wordpress.org/support/users/sparkweb/)
 * (@sparkweb)
 * [11 years ago](https://wordpress.org/support/topic/extra-characters-added-when-inserting-value/#post-6124118)
 * We are using `update_post_meta()` to save the details to the database and I think
   that WordPress must be catching the serialized data and converting it to a string
   because it knows that what you are trying to set is serialized data. The solution
   is to set this content using a regular database query and not using WordPress’s
   methods. So I think you are going to be stuck updating through phpMyAdmin.

Viewing 1 replies (of 1 total)

The topic ‘Extra Characters added when inserting value’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/custom-field-bulk-editor_fefefe.svg)
 * [Custom Field Bulk Editor](https://wordpress.org/plugins/custom-field-bulk-editor/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/custom-field-bulk-editor/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/custom-field-bulk-editor/)
 * [Active Topics](https://wordpress.org/support/plugin/custom-field-bulk-editor/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/custom-field-bulk-editor/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/custom-field-bulk-editor/reviews/)

## Tags

 * [extra characters](https://wordpress.org/support/topic-tag/extra-characters/)
 * [utf8](https://wordpress.org/support/topic-tag/utf8/)

 * 1 reply
 * 2 participants
 * Last reply from: [sparkweb](https://wordpress.org/support/users/sparkweb/)
 * Last activity: [11 years ago](https://wordpress.org/support/topic/extra-characters-added-when-inserting-value/#post-6124118)
 * Status: not resolved