Technopolis theme: Random, weird, unserialize error on DbSettingsHelper.php

ThemeBurn SupportForumsOpenCart ThemesBurnEngineTechnopolis theme: Random, weird, unserialize error on DbSettingsHelper.php

This topic has been marked as not resolved.

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:”";}}}}

June 14, 2018 at 12:06 am #64655

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

June 15, 2018 at 3:34 pm #64674
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.