Title: NUL characters inserted in SQL script Last modified: August 30, 2016 --- # NUL characters inserted in SQL script * Resolved [ralph1996](https://wordpress.org/support/users/ralph1996/) * (@ralph1996) * [10 years, 9 months ago](https://wordpress.org/support/topic/nul-characters-inserted-in-sql-script/) * The SQL script for the database backup of a wooCommerce site is inserting NUL() characters in the script – thus making it impossible to run the script as it gets truncated in MySQL Workbench. * It appears that the problem may be limited to variable products in woocommerce. The following is an excerpt from the script where the issue occurs. I have replaced the NUL characters with the string in the code below in order to paste it here. It occurs in multiple places but appears to be localized around the shipping data of variable items. * Any help is appreciated as we cannot backup our database with this issue. * INSERT INTO `wp_options` VALUES (1602, ‘_wc_session_f7408f9bf1dc227d16352c48a78d617f’,‘ a:24:{s:4:”cart”;s:307:”a:1:{s:32:”149e9677a5989fd342ae44213df68868″;a:9:{s:10:” product_id”;i:170;s:12:”variation_id”;s:0:””;s:9:”variation”;a:0:{}s:8:”quantity”; i:1;s:10:”line_total”;i:65;s:8:”line_tax”;i:0;s:13:”line_subtotal”;i:65;s:17:” line_subtotal_tax”;i:0;s:13:”line_tax_data”;a:2:{s:5:”total”;a:0:{}s:8:”subtotal”; a:0:{}}}}”;s:15:”applied_coupons”;s:6:”a:0:{}”;s:23:”coupon_discount_amounts”; s:6:”a:0:{}”;s:27:”coupon_discount_tax_amounts”;s:6:”a:0:{}”;s:21:”removed_cart_contents”; s:6950:”a:3:{s:32:”0a09c8844ba8f0936c20bd791130d6b6″;a:10:{s:10:”product_id”; i:144;s:12:”variation_id”;s:0:””;s:9:”variation”;a:0:{}s:8:”quantity”;i:2;s:10:” line_total”;i:450;s:8:”line_tax”;d:33.75;s:13:”line_subtotal”;i:450;s:17:”line_subtotal_tax”; d:33.75;s:13:”line_tax_data”;a:2:{s:5:”total”;a:1:{i:1;d:33.75;}s:8:”subtotal”; a:1:{i:1;d:33.75;}}s:4:”data”;O:17:”WC_Product_Simple”:7:{s:2:”id”;i:144;s:4:” post”;O:7:”WP_Post”:24:{s:2:”ID”;i:144;s:11:”post_author”;s:1:”1″;s:9:”post_date”; s:19:”2015-02-24 11:14:24″;s:13:”post_date_gmt”;s:19:”2015-02-24 19:14:24″;s: 12:”post_content”;s:542:”There\’s no need to drag all those room essentials with you.  Save yourself the hassle and send this collection of bedding and bath necessities directly to your student just in time for move-in weekend! * Package Contents * Twin XL Sheet set – 400 ct flat, fitted and pillowcase * Twin XL zippered mattress protector – waterproof, vinyl, hypoallergenic dorm room bed cover * Twin XL Mattress Pad * 100% cotton Bath Towel * 100% cotton Hand Towel * 100% cotton Wash cloth * Yardley Soap * mesh wash cloth * bag of quarters ($5 value)”;s:10:”post_title”;s:15:”Dorm Bath & Bed”;s:12:”post_excerpt”; s:202:”There\’s no need to drag all those room essentials with you.  Save yourself the hassle and send this collection of bedding and bath necessities directly to your student just in time for move-in weekend!”;s:11:”post_status”;s:7:”publish”; s:14:”comment_status”;s:4:”open”;s:11:”ping_status”;s:6:”closed”;s:13:”post_password”; s:0:””;s:9:”post_name”;s:13:”dorm-bath-bed”;s:7:”to_ping”;s:0:””;s:6:”pinged”; s:0:””;s:13:”post_modified”;s:19:”2015-02-24 11:14:24″;s:17:”post_modified_gmt”; s:19:”2015-02-24 19:14:24″;s:21:”post_content_filtered”;s:0:””;s:11:”post_parent”; i:0;s:4:”guid”;s:68:”[http://parcelwp-uat.decisiondesign.com/?post_type=product&p=144″](http://parcelwp-uat.decisiondesign.com/?post_type=product&p=144″);; s:10:”menu_order”;i:0;s:9:”post_type”;s:7:”product”;s:14:”post_mime_type”;s:0:””; s:13:”comment_count”;s:1:”0″;s:6:”filter”;s:3:”raw”;}s:12:”product_type”;s:6:” simple”;s:13:”*dimensions”;s:0:””;s:17:”*shipping_class”; s:0:””;s:20:”*shipping_class_id”;i:0;s:5:”price”;s:3:”225″;}}s:32:” 8f53295a73878494e9bc8dd6c3c7104f”;a:10:{s:10:”product_id”;i:179;s:12:”variation_id”; s:0:””;s:9:”variation”;a:0:{}s:8:”quantity”;i:1;s:10:”line_total”;d:54.950000000000003; s:8:”line_tax”;d:4.1212999999999997;s:13:”line_subtotal”;d:54.950000000000003; s:17:”line_subtotal_tax”;d:4.1212999999999997;s:13:”line_tax_data”;a:2:{s:5:” total”;a:1:{i:1;d:4.1212999999999997;}s:8:”subtotal”;a:1:{i:1;d:4.1212999999999997;}} s:4:”data”;O:17:”WC_Product_Simple”:7:{s:2:”id”;i:179;s:4:”post”;O:7:”WP_Post”: 24:{s:2:”ID”;i:179;s:11:”post_author”;s:1:”1″;s:9:”post_date”;s:19:”2015-02-24 11:45:40″;s:13:”post_date_gmt”;s:19:”2015-02-24 19:45:40″;s:12:”post_content”; s:767:”This gift parcel is filled with provisions and encouragement for the first round of midterms.  Not quiet enough? Grab those earplugs! Not enough time to eat well? Pack a protein bar! Loose papers? Staple them! * **Package Contents** * ear plugs * protein bars * highlighters * index cards * white board markers & eraser * tea bags * UCLA coffee shop mug – only ones that are allowed in Powell * chocolate * Emergency + * DD Cookies * Starbucks ™ Via Italian roast Coffee 3 pack * Starbucks ™ card * TIP: Any campus coffee shop will provide you with free hot water for your mug * TIP: Starbucks is open 24 hours in Westwood * TIP: Powell and YRL are open 24 hours during 10th week and finals weeks.  Don\’ t forget your Bruin card.”;s:10:”post_title”;s:54:”Midterms Already! a.k.a. Chocolate, snacks + caffeine!”;s:12:”post_excerpt”;s:210:”This gift parcel is filled with provisions and encouragement for the first round of midterms.  Not quiet enough? Grab those earplugs! Not enough time to eat well? Pack a protein bar! Loose papers? Staple them!”;s:11:”post_status”;s:7:”publish”;s:14:”comment_status”;s:4:”open”; s:11:”ping_status”;s:6:”closed”;s:13:”post_password”;s:0:””;s:9:”post_name”;s: 48:”midterms-already-a-k-a-chocolate-snacks-caffeine”;s:7:”to_ping”;s:0:””;s: 6:”pinged”;s:0:””;s:13:”post_modified”;s:19:”2015-02-24 11:45:40″;s:17:”post_modified_gmt”; s:19:”2015-02-24 19:45:40″;s:21:”post_content_filtered”;s:0:””;s:11:”post_parent”; i:0;s:4:”guid”;s:68:”[http://parcelwp-uat.decisiondesign.com/?post_type=product&p=179″](http://parcelwp-uat.decisiondesign.com/?post_type=product&p=179″);; s:10:”menu_order”;i:0;s:9:”post_type”;s:7:”product”;s:14:”post_mime_type”;s:0:””; s:13:”comment_count”;s:1:”0″;s:6:”filter”;s:3:”raw”;}s:12:”product_type”;s:6:” simple”;s:13:”*dimensions”;s:0:””;s:17:”*shipping_class”; s:0:””;s:20:”*shipping_class_id”;i:0;s:5:”price”;s:5:”54.95″;}}s: 32:”a8f15eda80c50adb0e71943adc8015cf”;a:10:{s:10:”product_id”;i:151;s:12:”variation_id”; s:0:””;s:9:”variation”;a:0:{}s:8:”quantity”;i:1;s:10:”line_total”;i:79;s:8:”line_tax”; d:5.9249999999999998;s:13:”line_subtotal”;i:79;s:17:”line_subtotal_tax”;d:5.9249999999999998; s:13:”line_tax_data”;a:2:{s:5:”total”;a:1:{i:1;d:5.9249999999999998;}s:8:”subtotal”; a:1:{i:1;d:5.9249999999999998;}}s:4:”data”;O:17:”WC_Product_Simple”:7:{s:2:”id”; i:151;s:4:”post”;O:7:”WP_Post”:24:{s:2:”ID”;i:151;s:11:”post_author”;s:1:”1″; s:9:”post_date”;s:19:”2015-02-24 11:17:16″;s:13:”post_date_gmt”;s:19:”2015-02- 24 19:17:16″;s:12:”post_content”;s:630:”No need to worry about picking up all the supplies your student needs to start of the academic year.  Skip the long lines at the retail stores and let Parcel U deliver everything directly to your student! * Package Contents * Waste bin * Paper clips * magnetic dry erase board with marker and eraser * highlighters * tape * index cards * binder clips * stapler * staples * post-it ™ notes * desk drawer bin organizers (set of 3) * Fresh Scent pouch * scissors * eraser 3 pack, pencils, pens * convenient pencil storage pouch with ID and gift card holder * screwdriver set * ruler * bag of quarters ($5 value)”;s:10:”post_title”;s:30:”Dorm Room Move-in and Stock Up”;s:12:”post_excerpt”;s:205:”No need to worry about picking up all the supplies your student needs to start of the academic year.  Skip the long lines at the retail stores and let Parcel U deliver everything directly to your student!”; s:11:”post_status”;s:7:”publish”;s:14:”comment_status”;s:4:”open”;s:11:”ping_status”; s:6:”closed”;s:13:”post_password”;s:0:””;s:9:”post_name”;s:30:”dorm-room-move- in-and-stock-up”;s:7:”to_ping”;s:0:””;s:6:”pinged”;s:0:””;s:13:”post_modified”; s:19:”2015-02-24 11:17:16″;s:17:”post_modified_gmt”;s:19:”2015-02-24 19:17:16″; s:21:”post_content_filtered”;s:0:””;s:11:”post_parent”;i:0;s:4:”guid”;s:68:”http:// parcelwp-uat.decisiondesign.com/?post_type=product&p=151″;s:10:”menu_order”;i: 0;s:9:”post_type”;s:7:”product”;s:14:”post_mime_type”;s:0:””;s:13:”comment_count”; s:1:”0″;s:6:”filter”;s:3:”raw”;}s:12:”product_type”;s:6:”simple”;s:13:”* dimensions”;s:0:””;s:17:”*shipping_class”;s:0:””;s:20:”*shipping_class_id”;i:0;s:5:”price”;s:2:”79″;}}}”;s:19:”cart_contents_total”; i:65;s:20:”cart_contents_weight”;i:0;s:19:”cart_contents_count”;i:1;s:5:”total”; d:74.950000000000003;s:8:”subtotal”;i:65;s:15:”subtotal_ex_tax”;i:65;s:9:”tax_total”; i:0;s:5:”taxes”;s:6:”a:0:{}”;s:14:”shipping_taxes”;s:6:”a:0:{}”;s:13:”discount_cart”; i:0;s:14:”shipping_total”;d:9.9499999999999993;s:18:”shipping_tax_total”;i:0; s:9:”fee_total”;i:0;s:4:”fees”;s:6:”a:0:{}”;s:10:”wc_notices”;N;s:23:”chosen_shipping_methods”; s:26:”a:1:{i:0;s:9:”flat_rate”;}”;s:22:”shipping_method_counts”;s:14:”a:1:{i: 0;i:1;}”;s:21:”chosen_payment_method”;s:12:”authorizeaim”;s:8:”customer”;s:385:” a:14:{s:8:”postcode”;s:5:”91301″;s:4:”city”;s:0:””;s:7:”address”;s:0:””;s:9:” address_2″;s:0:””;s:5:”state”;s:0:””;s:7:”country”;s:2:”US”;s:17:”shipping_postcode”; s:5:”91301″;s:13:”shipping_city”;s:0:””;s:16:”shipping_address”;s:0:””;s:18:” shipping_address_2″;s:0:””;s:14:”shipping_state”;s:0:””;s:16:”shipping_country”; s:2:”US”;s:13:”is_vat_exempt”;b:0;s:19:”calculated_shipping”;b:0;}”;}’, ‘no’); * [https://wordpress.org/plugins/backupwordpress/](https://wordpress.org/plugins/backupwordpress/) Viewing 1 replies (of 1 total) * Plugin Author [cuvelier](https://wordpress.org/support/users/cuvelier/) * (@cuvelier) * [10 years, 9 months ago](https://wordpress.org/support/topic/nul-characters-inserted-in-sql-script/#post-6461469) * Hi there, * Would it be possible for you to reach out to us through our dedicated BackUpWordPress Support channel by enabling support? * You can follow this guide on how to do so: [https://bwp.hmn.md/support-center/enable-support](https://bwp.hmn.md/support-center/enable-support) * Cheers! Owain Viewing 1 replies (of 1 total) The topic ‘NUL characters inserted in SQL script’ is closed to new replies. * ![](https://ps.w.org/backupwordpress/assets/icon-256x256.jpg?rev=1105225) * [BackUpWordPress](https://wordpress.org/plugins/backupwordpress/) * [Frequently Asked Questions](https://wordpress.org/plugins/backupwordpress/#faq) * [Support Threads](https://wordpress.org/support/plugin/backupwordpress/) * [Active Topics](https://wordpress.org/support/plugin/backupwordpress/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/backupwordpress/unresolved/) * [Reviews](https://wordpress.org/support/plugin/backupwordpress/reviews/) * 1 reply * 2 participants * Last reply from: [cuvelier](https://wordpress.org/support/users/cuvelier/) * Last activity: [10 years, 9 months ago](https://wordpress.org/support/topic/nul-characters-inserted-in-sql-script/#post-6461469) * Status: resolved