I am using:
Opencart 2.2.0.0.
Technopolis theme ( BurnEngine v1.2.7 ):
I have had this error in two different forms:
1) migrating a site to another hosting company.
2) creating two products through an external api interaction.
The first time I had that error (case 1) I just exported the configuration using
the export tool of the theme, Imported the exported string into the new site and the error dissapeared, I assume that it wasnt the more elegant way of solving. my question is: HOW in the heavens are you serializing data that breaks the php function…?
regarding the case 2) you can watch it here http://bfdev.dreamhosters.com/index.php?route=product/product&product_id=186 I obtained the error Notice: unserialize(): Error at offset 2820 of 11623 bytes in /home/ishvara/gitscratch/opencart/upload/system/vendor/BurnEngine/library/DbSettingsHelper.php on line 183 .
digging a bit into the code and db I have found that the error has its origin in the processing of the db field key of table oc_burnengine_setting . key is column_right_system_product/product__default.
do you have any clue?
Value is:
a:1:{s:4:”rows”;a:1:{i:0;a:4:{s:2:”id”;s:5:”CcW9p”;s:7:”columns”;a:1:{i:0;a:4:{s:2:”id”;s:5:”3cIYf”;s:7:”widgets”;a:3:{i:0;a:2:{s:2:”id”;s:35:”Theme_LatestProductsWidget_R64e1SF7″;s:8:”settings”;a:19:{s:4:”lang”;a:1:{s:5:”en-gb”;a:5:{s:9:”is_active”;s:1:”1″;s:5:”title”;s:15:”Latest Products”;s:10:”title_icon”;s:0:”";s:15:”title_icon_size”;s:3:”100″;s:11:”title_align”;s:4:”left”;}}s:9:”view_mode”;s:7:”compact”;s:13:”grid_max_rows”;s:1:”0″;s:15:”filter_category”;s:2:”-1″;s:24:”filter_category_children”;s:1:”1″;s:12:”filter_limit”;s:1:”4″;s:6:”slider”;s:1:”0″;s:11:”slider_step”;s:1:”1″;s:12:”slider_speed”;s:3:”500″;s:17:”slider_pagination”;s:1:”0″;s:19:”slider_nav_position”;s:3:”top”;s:11:”slider_loop”;s:1:”0″;s:15:”slider_autoplay”;s:1:”0″;s:16:”inherit_products”;s:1:”1″;s:10:”box_styles”;a:6:{s:6:”layout”;a:12:{s:11:”extra_class”;s:0:”";s:7:”display”;s:5:”block”;s:10:”margin_top”;s:1:”0″;s:13:”margin_bottom”;s:1:”0″;s:11:”margin_left”;s:1:”0″;s:12:”margin_right”;s:1:”0″;s:15:”margin_rtl_mode”;i:1;s:11:”padding_top”;s:1:”0″;s:12:”padding_left”;s:1:”0″;s:13:”padding_right”;s:1:”0″;s:14:”padding_bottom”;s:1:”0″;s:16:”padding_rtl_mode”;i:1;}s:10:”background”;a:3:{s:11:”solid_color”;s:0:”";s:19:”solid_color_opacity”;s:3:”100″;s:4:”rows”;a:0:{}}s:6:”border”;a:1:{s:8:”rtl_mode”;i:1;}s:13:”border_radius”;a:1:{s:8:”rtl_mode”;i:1;}s:4:”font”;a:1:{s:5:”en-gb”;a:3:{s:13:”product_title”;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:13:”product_price”;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:15:”product_buttons”;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”0″;}}}s:7:”cleaned”;b:1;}s:12:”title_styles”;a:6:{s:6:”layout”;a:10:{s:10:”margin_top”;s:1:”0″;s:13:”margin_bottom”;s:2:”20″;s:11:”margin_left”;s:1:”0″;s:12:”margin_right”;s:1:”0″;s:15:”margin_rtl_mode”;i:1;s:11:”padding_top”;s:1:”0″;s:12:”padding_left”;s:1:”0″;s:13:”padding_right”;s:1:”0″;s:14:”padding_bottom”;s:1:”0″;s:16:”padding_rtl_mode”;i:1;}s:10:”background”;a:3:{s:11:”solid_color”;s:0:”";s:19:”solid_color_opacity”;s:3:”100″;s:4:”rows”;a:0:{}}s:6:”border”;a:1:{s:8:”rtl_mode”;i:1;}s:13:”border_radius”;a:1:{s:8:”rtl_mode”;i:1;}s:4:”font”;a:1:{s:5:”en-gb”;a:1:{s:5:”title”;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}}}s:7:”cleaned”;b:1;}s:9:”preset_id”;s:0:”";s:15:”special_counter”;i:0;s:11:”widget_name”;s:15:”Latest Products”;}}i:1;a:2:{s:2:”id”;s:25:”Theme_TextWidget_R4qpaI8E”;s:8:”settings”;a:5:{s:4:”lang”;a:1:{s:5:”en-gb”;a:6:{s:9:”is_active”;s:1:”1″;s:5:”title”;s:0:”";s:10:”title_icon”;s:0:”";s:15:”title_icon_size”;s:3:”100″;s:11:”title_align”;s:4:”left”;s:4:”text”;s:177:”
“;}}s:10:”box_styles”;a:7:{s:6:”layout”;a:12:{s:11:”extra_class”;s:0:”";s:7:”display”;s:5:”block”;s:10:”margin_top”;s:2:”40″;s:13:”margin_bottom”;s:2:”20″;s:11:”margin_left”;s:3:”-30″;s:12:”margin_right”;s:3:”-30″;s:15:”margin_rtl_mode”;i:1;s:11:”padding_top”;s:1:”0″;s:12:”padding_left”;s:1:”0″;s:13:”padding_right”;s:1:”0″;s:14:”padding_bottom”;s:1:”0″;s:16:”padding_rtl_mode”;i:1;}s:10:”background”;a:3:{s:11:”solid_color”;s:0:”";s:19:”solid_color_opacity”;s:3:”100″;s:4:”rows”;a:0:{}}s:6:”border”;a:1:{s:8:”rtl_mode”;i:1;}s:13:”border_radius”;a:1:{s:8:”rtl_mode”;i:1;}s:6:”colors”;a:1:{s:4:”body”;a:2:{s:9:”accent_bg”;a:5:{s:8:”elements”;s:121:”
.tb_main_color_bg,
.tb_hover_main_color_bg:hover
“;s:8:”property”;s:16:”background-color”;s:5:”color”;s:7:”#005e99″;s:9:”important”;i:1;s:7:”inherit”;s:1:”1″;}s:15:”accent_bg_hover”;a:5:{s:8:”elements”;s:128:”
a.tb_main_color_bg:hover,
.tb_main_color_bg_hover:hover
“;s:8:”property”;s:16:”background-color”;s:5:”color”;s:7:”#000000″;s:9:”important”;i:1;s:7:”inherit”;s:1:”1″;}}}s:4:”font”;a:1:{s:5:”en-gb”;a:5:{s:4:”body”;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:2:”h1″;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:2:”h2″;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:2:”h3″;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:2:”h4″;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}}}s:7:”cleaned”;b:1;}s:12:”title_styles”;a:6:{s:6:”layout”;a:10:{s:10:”margin_top”;s:1:”0″;s:13:”margin_bottom”;s:2:”30″;s:11:”margin_left”;s:1:”0″;s:12:”margin_right”;s:1:”0″;s:15:”margin_rtl_mode”;i:1;s:11:”padding_top”;s:1:”0″;s:12:”padding_left”;s:1:”0″;s:13:”padding_right”;s:1:”0″;s:14:”padding_bottom”;s:1:”0″;s:16:”padding_rtl_mode”;i:1;}s:10:”background”;a:3:{s:11:”solid_color”;s:0:”";s:19:”solid_color_opacity”;s:3:”100″;s:4:”rows”;a:0:{}}s:6:”border”;a:1:{s:8:”rtl_mode”;i:1;}s:13:”border_radius”;a:1:{s:8:”rtl_mode”;i:1;}s:4:”font”;a:1:{s:5:”en-gb”;a:1:{s:5:”title”;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}}}s:7:”cleaned”;b:1;}s:9:”preset_id”;s:0:”";s:11:”widget_name”;s:4:”Text”;}}i:2;a:2:{s:2:”id”;s:25:”Theme_TextWidget_YEHqLnDa”;s:8:”settings”;a:5:{s:4:”lang”;a:1:{s:5:”en-gb”;a:6:{s:9:”is_active”;s:1:”1″;s:5:”title”;s:0:”";s:10:”title_icon”;s:0:”";s:15:”title_icon_size”;s:3:”100″;s:11:”title_align”;s:4:”left”;s:4:”text”;s:138:”
Last minute gifting is now a few clicks away!
Get Now!
“;}}s:10:”box_styles”;a:7:{s:6:”layout”;a:12:{s:11:”extra_class”;s:0:”";s:7:”display”;s:5:”block”;s:10:”margin_top”;s:1:”0″;s:13:”margin_bottom”;s:1:”0″;s:11:”margin_left”;s:1:”0″;s:12:”margin_right”;s:1:”0″;s:15:”margin_rtl_mode”;i:1;s:11:”padding_top”;s:1:”0″;s:12:”padding_left”;s:1:”0″;s:13:”padding_right”;s:1:”0″;s:14:”padding_bottom”;s:1:”0″;s:16:”padding_rtl_mode”;i:1;}s:10:”background”;a:3:{s:11:”solid_color”;s:0:”";s:19:”solid_color_opacity”;s:3:”100″;s:4:”rows”;a:0:{}}s:6:”border”;a:1:{s:8:”rtl_mode”;i:1;}s:13:”border_radius”;a:1:{s:8:”rtl_mode”;i:1;}s:6:”colors”;a:1:{s:4:”body”;a:2:{s:9:”accent_bg”;a:5:{s:8:”elements”;s:121:”
.tb_main_color_bg,
.tb_hover_main_color_bg:hover
“;s:8:”property”;s:16:”background-color”;s:5:”color”;s:7:”#005e99″;s:9:”important”;i:1;s:7:”inherit”;s:1:”1″;}s:15:”accent_bg_hover”;a:5:{s:8:”elements”;s:128:”
a.tb_main_color_bg:hover,
.tb_main_color_bg_hover:hover
“;s:8:”property”;s:16:”background-color”;s:5:”color”;s:7:”#000000″;s:9:”important”;i:1;s:7:”inherit”;s:1:”1″;}}}s:4:”font”;a:1:{s:5:”en-gb”;a:5:{s:4:”body”;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:2:”h1″;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:2:”h2″;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:2:”h3″;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:2:”h4″;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}}}s:7:”cleaned”;b:1;}s:9:”preset_id”;s:0:”";s:11:”widget_name”;s:4:”Text”;s:12:”title_styles”;a:6:{s:6:”layout”;a:10:{s:10:”margin_top”;i:0;s:13:”margin_bottom”;i:30;s:11:”margin_left”;i:0;s:12:”margin_right”;i:0;s:15:”margin_rtl_mode”;i:1;s:11:”padding_top”;i:0;s:12:”padding_left”;i:0;s:13:”padding_right”;i:0;s:14:”padding_bottom”;i:0;s:16:”padding_rtl_mode”;i:1;}s:10:”background”;a:3:{s:11:”solid_color”;s:0:”";s:19:”solid_color_opacity”;i:100;s:4:”rows”;a:0:{}}s:6:”border”;a:1:{s:8:”rtl_mode”;i:1;}s:13:”border_radius”;a:1:{s:8:”rtl_mode”;i:1;}s:4:”font”;a:1:{s:5:”en-gb”;a:1:{s:5:”title”;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;b:1;}}}s:7:”cleaned”;b:1;}}}}s:15:”grid_proportion”;s:3:”1_1″;s:8:”settings”;a:7:{s:6:”layout”;a:12:{s:11:”padding_top”;s:1:”0″;s:14:”padding_bottom”;s:1:”0″;s:13:”padding_right”;s:1:”0″;s:12:”padding_left”;s:1:”0″;s:16:”padding_rtl_mode”;i:1;s:13:”inner_padding”;i:30;s:5:”align”;s:5:”start”;s:6:”valign”;s:3:”top”;s:15:”inherit_padding”;s:1:”0″;s:9:”is_sticky”;s:1:”0″;s:13:”sticky_offset”;s:1:”0″;s:11:”extra_class”;s:0:”";}s:10:”background”;a:3:{s:11:”solid_color”;s:0:”";s:19:”solid_color_opacity”;s:3:”100″;s:4:”rows”;a:0:{}}s:6:”border”;a:1:{s:8:”rtl_mode”;i:1;}s:13:”border_radius”;a:1:{s:8:”rtl_mode”;i:1;}s:6:”colors”;a:1:{s:4:”body”;a:2:{s:9:”accent_bg”;a:6:{s:8:”elements”;s:121:”
.tb_main_color_bg,
.tb_hover_main_color_bg:hover
“;s:8:”property”;s:16:”background-color”;s:5:”color”;s:7:”#005e99″;s:9:”important”;i:1;s:7:”inherit”;s:1:”1″;s:14:”parent_context”;s:6:”column”;}s:15:”accent_bg_hover”;a:6:{s:8:”elements”;s:128:”
a.tb_main_color_bg:hover,
.tb_main_color_bg_hover:hover
“;s:8:”property”;s:16:”background-color”;s:5:”color”;s:7:”#000000″;s:9:”important”;i:1;s:7:”inherit”;s:1:”1″;s:14:”parent_context”;s:6:”column”;}}}s:4:”font”;a:1:{s:5:”en-gb”;a:5:{s:4:”body”;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:2:”h1″;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:2:”h2″;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:2:”h3″;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:2:”h4″;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}}}s:8:”viewport”;a:3:{s:2:”xs”;a:1:{s:6:”layout”;a:2:{s:15:”grid_proportion”;s:3:”1_1″;s:12:”column_order”;s:7:”default”;}}s:2:”sm”;a:1:{s:6:”layout”;a:2:{s:15:”grid_proportion”;s:3:”1_1″;s:12:”column_order”;s:7:”default”;}}s:2:”md”;a:1:{s:6:”layout”;a:2:{s:15:”grid_proportion”;s:3:”1_1″;s:12:”column_order”;s:7:”default”;}}}}}}s:14:”columns_number”;s:1:”1″;s:8:”settings”;a:7:{s:6:”layout”;a:19:{s:4:”type”;s:10:”full_fixed”;s:10:”margin_top”;s:1:”0″;s:13:”margin_bottom”;s:1:”0″;s:12:”margin_right”;s:1:”0″;s:11:”margin_left”;s:1:”0″;s:15:”margin_rtl_mode”;i:1;s:11:”padding_top”;s:1:”0″;s:14:”padding_bottom”;s:1:”0″;s:13:”padding_right”;s:1:”0″;s:12:”padding_left”;s:1:”0″;s:16:”padding_rtl_mode”;i:1;s:13:”inner_padding”;s:2:”30″;s:14:”columns_gutter”;s:2:”30″;s:16:”columns_rtl_mode”;i:1;s:13:”merge_columns”;s:1:”1″;s:16:”separate_columns”;s:1:”0″;s:11:”extra_class”;s:0:”";s:14:”sticky_columns”;s:4:”none”;s:13:”sticky_offset”;s:1:”0″;}s:10:”background”;a:3:{s:11:”solid_color”;s:0:”";s:19:”solid_color_opacity”;s:3:”100″;s:4:”rows”;a:0:{}}s:6:”border”;a:1:{s:8:”rtl_mode”;i:1;}s:13:”border_radius”;a:1:{s:8:”rtl_mode”;i:1;}s:6:”colors”;a:1:{s:4:”body”;a:2:{s:9:”accent_bg”;a:6:{s:8:”elements”;s:121:”
.tb_main_color_bg,
.tb_hover_main_color_bg:hover
“;s:8:”property”;s:16:”background-color”;s:5:”color”;s:7:”#005e99″;s:9:”important”;i:1;s:7:”inherit”;s:1:”1″;s:14:”parent_context”;s:3:”row”;}s:15:”accent_bg_hover”;a:6:{s:8:”elements”;s:128:”
a.tb_main_color_bg:hover,
.tb_main_color_bg_hover:hover
“;s:8:”property”;s:16:”background-color”;s:5:”color”;s:7:”#000000″;s:9:”important”;i:1;s:7:”inherit”;s:1:”1″;s:14:”parent_context”;s:3:”row”;}}}s:4:”font”;a:1:{s:5:”en-gb”;a:5:{s:4:”body”;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:2:”h1″;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:2:”h2″;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:2:”h3″;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}s:2:”h4″;a:2:{s:6:”family”;s:7:”inherit”;s:15:”has_line_height”;s:1:”1″;}}}s:9:”preset_id”;s:0:”";}}}}
|
|
Hi,
if you pass data to the serialize function and it does not return an error, there is 100% guarantee that you can unserialize the result without problems. The only issue that can arise is when you modify the serialized data string before passing it to unserialize().
There are generally two common ways when this happens:
- encoding break with database export/import
- trying to write serialized data to a database field that is too short and the data gets trimmed
Apart from this, can’t really help by only looking at the string you have provided. Does this make sense?
Regards,
ThemeBurn team
|
|