Wordpress Themes - WP Forum at BFA

Wordpress Themes - WP Forum at BFA (http://forum.bytesforall.com/index.php)
-   New Versions, & Updating (http://forum.bytesforall.com/forumdisplay.php?f=12)
-   -   Database restored = all settings gone (http://forum.bytesforall.com/showthread.php?t=14641)

Garwen Jun 15, 2011 01:35 AM

Database restored = all settings gone
 
Hello

Today I had to restore my wordpress database from an sql dump.

everything seems fine, but all Atahualpa settings are gone.

In the database I see that the field bfa_ata4 is filled with data, but they don't seem to be my own settings.

I'm somewhat lost, where my settings are. Anyone an idea ? :)

I'm using version 3.6.4.

juggledad Jun 15, 2011 03:46 AM

How old was the dump
What is the URL
What happens if you switch to twenty ten then back

Garwen Jun 15, 2011 05:19 AM

The dump is from last monday. I'm running daily backups.

Unfortunatly I can't provide you the URL. The server is in our intranet.

Sorry, I don't understand "switch to twenty ten then back". Give me more details what to do please.

juggledad Jun 15, 2011 05:47 AM

switch to another theme and then back to Atahualpa

If Atahualpa was running at the time of the dump and you successfully dumped the entire database, then it should run now.

Garwen Jun 15, 2011 06:18 AM

ah...tried that already. Didn't help.

this is what I have in the row "bfa_afa4" (on one line, divided it for readability):
Code:

INSERT INTO `wp_options` VALUES ('225','0','bfa_ata4','a:266:{s:11:\"use_bfa_seo\";

s:2:\"No\";

s:25:\"homepage_meta_description\";

s:0:\"\";
s:22:\"homepage_meta_keywords\";
s:0:\"\";
s:13:\"add_blogtitle\";
s:23:\"Page Title - Blog Title\";
s:20:\"title_separator_code\";
s:1:\"1\";
s:15:\"archive_noindex\";
s:2:\"No\";
s:11:\"cat_noindex\";
s:2:\"No\";
s:11:\"tag_noindex\";
s:2:\"No\";
s:18:\"h1_on_single_pages\";
s:3:\"Yes\";
s:8:\"nofollow\";
s:2:\"No\";
s:10:\"body_style\";
s:158:\"font-family: verdana, arial, sans-serif;
\r\nfont-size: 13px;
\r\nline-height: 1.4;
\r\ncolor: #000000;
\r\nbackground: #A5CAF7;
\r\npadding-top: 20px;
 padding-bottom: 20px;
\";
s:10:\"link_color\";
s:6:\"003399\";
s:16:\"link_hover_color\";
s:6:\"000000\";
s:23:\"link_default_decoration\";
s:4:\"none\";
s:21:\"link_hover_decoration\";
s:9:\"underline\";
s:11:\"link_weight\";
s:6:\"normal\";
s:12:\"layout_width\";
s:3:\"92%\";
s:16:\"layout_min_width\";
s:0:\"\";
s:16:\"layout_max_width\";
s:0:\"\";
s:12:\"layout_style\";
s:310:\"padding: 20px;
 /*This effectively only affects top/bottom padding */\r\nbackground: #fff;
\r\n\r\nbox-shadow: 0 0 15px #333;
\r\n-moz-box-shadow: 0 0 15px #333;
\r\n/* uncomment next block for round corners */\r\n/*\r\n-moz-border-radius:10px;
\r\n-khtml-border-radius: 10px;
\r\n-webkit-border-radius:10px;
\r\nborder-radius: 10px;
\r\n*/\";
s:30:\"layout_style_leftright_padding\";
s:2:\"20\";
s:12:\"favicon_file\";
s:14:\"27-favicon.ico\";
s:16:\"configure_header\";
s:12:\"%logo %pages\";
s:14:\"logoarea_style\";
s:0:\"\";
s:4:\"logo\";
s:0:\"\";
s:10:\"logo_style\";
s:19:\"margin: 0 10px 0 0;
\";
s:15:\"blog_title_show\";
s:3:\"Yes\";
s:16:\"blog_title_style\";
s:113:\"margin: 0;
\r\npadding: 0;
\r\nletter-spacing: -1px;
\r\nline-height: 1.0em;
\r\nfont-size: 200%;
\r\ntext-transform: uppercase;
\";
s:17:\"blog_title_weight\";
s:6:\"normal\";
s:16:\"blog_title_color\";
s:6:\"000000\";
s:22:\"blog_title_color_hover\";
s:6:\"AC161B\";
s:17:\"blog_tagline_show\";
s:2:\"No\";
s:18:\"blog_tagline_style\";
s:78:\"margin: 0;
\r\npadding: 0;
\r\nfont-size: 1.2em;
\r\nfont-weight: normal;
\r\ncolor: #444;
\";
s:15:\"show_search_box\";
s:2:\"No\";
s:15:\"searchbox_style\";
s:57:\"border-bottom: 0;
\r\nwidth: 200px;
\r\nmargin: 0;
\r\npadding: 0;
\";
s:14:\"searchbox_text\";
s:15:\"Fulltext Search\";
s:7:\"horbar1\";
s:67:\"height: 5px;
\r\nbackground: #ffffff;
\r\nborder-top: dashed 1px #cccccc;
\";
s:7:\"horbar2\";
s:70:\"height: 5px;
\r\nbackground: #ffffff;
\r\nborder-bottom: dashed 1px #cccccc;
\";
s:23:\"header_image_javascript\";
s:1:\"0\";
s:31:\"header_image_javascript_preload\";
s:3:\"Yes\";
s:22:\"header_image_clickable\";
s:2:\"No\";
s:18:\"headerimage_height\";
s:3:\"150\";
s:21:\"headerimage_alignment\";
s:10:\"top center\";
s:19:\"header_opacity_left\";
s:1:\"0\";
s:25:\"header_opacity_left_width\";
s:3:\"200\";
s:25:\"header_opacity_left_color\";
s:6:\"FFFFFF\";
s:20:\"header_opacity_right\";
s:1:\"0\";
s:26:\"header_opacity_right_width\";
s:3:\"200\";
s:26:\"header_opacity_right_color\";
s:6:\"FFFFFF\";
s:18:\"overlay_blog_title\";
s:2:\"No\";
s:20:\"overlay_blog_tagline\";
s:2:\"No\";
s:17:\"overlay_box_style\";
s:37:\"margin-top: 30px;
\r\nmargin-left: 30px;
\";
s:13:\"rss_box_width\";
s:3:\"280\";
s:15:\"show_posts_icon\";
s:2:\"No\";
s:14:\"post_feed_link\";
s:5:\"Posts\";
s:20:\"post_feed_link_title\";
s:27:\"Subscribe to the POSTS feed\";
s:18:\"show_comments_icon\";
s:2:\"No\";
s:17:\"comment_feed_link\";
s:8:\"Comments\";
s:23:\"comment_feed_link_title\";
s:30:\"Subscribe to the COMMENTS feed\";
s:15:\"show_email_icon\";
s:2:\"No\";
s:20:\"email_subscribe_link\";
s:8:\"By Email\";
s:26:\"email_subscribe_link_title\";
s:18:\"Subscribe by EMAIL\";
s:19:\"feedburner_email_id\";
s:0:\"\";
s:18:\"feedburner_old_new\";
s:30:\"New - at feedburner.google.com\";
s:18:\"home_page_menu_bar\";
s:0:\"\";
s:21:\"exclude_page_menu_bar\";
s:10:\"2013, 2021\";
s:20:\"levels_page_menu_bar\";
s:1:\"0\";
s:21:\"sorting_page_menu_bar\";
s:10:\"menu_order\";
s:20:\"titles_page_menu_bar\";
s:2:\"No\";
s:30:\"page_menu_1st_level_not_linked\";
s:2:\"No\";
s:27:\"anchor_border_page_menu_bar\";
s:1:\"0\";
s:30:\"page_menu_bar_background_color\";
s:6:\"EEEEEE\";
s:36:\"page_menu_bar_background_color_hover\";
s:6:\"DDDDDD\";
s:37:\"page_menu_bar_background_color_parent\";
s:6:\"CCCCCC\";
s:14:\"page_menu_font\";
s:24:\"12px Verdana, sans-serif\";
s:24:\"page_menu_bar_link_color\";
s:6:\"777777\";
s:30:\"page_menu_bar_link_color_hover\";
s:6:\"000000\";
s:19:\"page_menu_transform\";
s:9:\"uppercase\";
s:16:\"page_menu_arrows\";
s:5:\"black\";
s:23:\"page_menu_submenu_width\";
s:2:\"11\";
s:17:\"home_cat_menu_bar\";
s:0:\"\";
s:20:\"exclude_cat_menu_bar\";
s:0:\"\";
s:19:\"levels_cat_menu_bar\";
s:1:\"0\";
s:20:\"sorting_cat_menu_bar\";
s:2:\"ID\";
s:18:\"order_cat_menu_bar\";
s:3:\"ASC\";
s:19:\"titles_cat_menu_bar\";
s:2:\"No\";
s:24:\"add_descr_cat_menu_links\";
s:2:\"No\";
s:22:\"default_cat_descr_text\";
s:42:\"View all posts filed under<br />%category%\";
s:26:\"anchor_border_cat_menu_bar\";
s:1:\"0\";
s:29:\"cat_menu_bar_background_color\";
s:6:\"5A85C1\";
s:35:\"cat_menu_bar_background_color_hover\";
s:6:\"2968C1\";
s:36:\"cat_menu_bar_background_color_parent\";
s:6:\"000000\";
s:13:\"cat_menu_font\";
s:24:\"12px Verdana, sans-serif\";
s:23:\"cat_menu_bar_link_color\";
s:6:\"FFFFFF\";
s:29:\"cat_menu_bar_link_color_hover\";
s:6:\"FFFFFF\";
s:18:\"cat_menu_transform\";
s:9:\"uppercase\";
s:15:\"cat_menu_arrows\";
s:5:\"white\";
s:22:\"cat_menu_submenu_width\";
s:2:\"11\";
s:19:\"center_column_style\";
s:19:\"padding: 10px 15px;
\";
s:18:\"content_above_loop\";
s:296:\"<?php /* For MULTI post pages if activated at ATO -> Next/Previous Navigation: */\r\nbfa_next_previous_page_links(\'Top\');
 ?>\r\n\r\n<?php /* For the plugin Page2Cat http://wordpress.org/extend/plugins/page2cat/ */\r\nif( is_category() AND function_exists(\'page2cat_output\')) { page2cat_output($cat);
 } ?>\";
s:19:\"content_inside_loop\";
s:960:\"<?php /* For SINGLE post pages if activated at ATO -> Next/Previous Navigation: */\r\nbfa_next_previous_post_links(\'Top\');
 ?>\r\n\r\n<?php /* Post Container starts here */\r\nif ( function_exists(\'post_class\') ) { ?>\r\n<div <?php if ( is_page() ) { post_class(\'post\');
 } else { post_class(\"$odd_or_even\");
 } ?> id=\"post-<?php the_ID();
 ?>\">\r\n<?php } else { ?>\r\n<div class=\"<?php echo ( is_page() ? \'page \' : \'\' ) . $odd_or_even . \' post\" id=\"post-\';
 the_ID();
 ?>\">\r\n<?php } ?>\r\n\r\n<?php bfa_post_kicker(\'<div class=\"post-kicker\">\',\'</div>\');
 ?>\r\n\r\n<?php bfa_post_headline(\'<div class=\"post-headline\">\',\'</div>\');
 ?>\r\n\r\n<?php bfa_post_byline(\'<div class=\"post-byline\">\',\'</div>\');
 ?>\r\n\r\n<?php bfa_post_bodycopy(\'<div class=\"post-bodycopy clearfix\">\',\'</div>\');
 ?>\r\n\r\n<?php bfa_post_pagination(\'<p class=\"post-pagination\"><strong>\'.__(\'Pages:\',\'atahualpa\').\'</strong>\',\'</p>\');
 ?>\r\n\r\n<?php bfa_post_footer(\'<div class=\"post-footer\">\',\'</div>\');
 ?>\r\n\r\n</div><!-- / Post -->\";
s:18:\"content_below_loop\";


Garwen Jun 15, 2011 06:19 AM

Code:

s:717:\"<?php /* Displayed on SINGLE post pages if activated at ATO -> Next/Previous Navigation: */\r\nbfa_next_previous_post_links(\'Middle\');
 ?>\r\n\r\n<?php /* Load Comments template (on single post pages, and static pages, if set on options page):\r\nbfa_get_comments();
  */ ?>\r\n\r\n<?php /* Displayed on SINGLE post pages if activated at ATO -> Next/Previous Navigation: */\r\nbfa_next_previous_post_links(\'Bottom\');
 ?>\r\n                \r\n<?php /* Archives Pages. Displayed on a specific static page, if configured at ATO -> Archives Pages: */\r\nbfa_archives_page(\'<div class=\"archives-page\">\',\'</div>\');
 ?>\r\n                        \r\n<?php /* Displayed on MULTI post pages if activated at ATO -> Next/Previous Navigation: */\r\nbfa_next_previous_page_links(\'Bottom\');
 ?>\";
s:17:\"content_not_found\";
s:140:\"<h2><?php _e(\'Not Found\',\'atahualpa\');
 ?></h2>\r\n<p><?php _e(\"Sorry, but you are looking for something that isn\'t here.\",\"atahualpa\");
 ?></p>\";
s:21:\"next_prev_orientation\";
s:23:\"Newer Left, Older Right\";
s:20:\"home_multi_next_prev\";
s:8:\"Overview\";
s:21:\"home_single_next_prev\";
s:0:\"\";
s:21:\"multi_next_prev_newer\";
s:21:\"&laquo;
 Newer Entries\";
s:21:\"multi_next_prev_older\";
s:21:\"Older Entries &raquo;
\";
s:22:\"single_next_prev_newer\";
s:13:\"&laquo;
 %link\";
s:22:\"single_next_prev_older\";
s:13:\"%link &raquo;
\";
s:25:\"single_next_prev_same_cat\";
s:3:\"Yes\";
s:24:\"comments_next_prev_newer\";
s:22:\"Newer Comments &raquo;
\";
s:24:\"comments_next_prev_older\";
s:22:\"&laquo;
 Older Comments\";
s:27:\"location_comments_next_prev\";
s:24:\"Above and Below Comments\";
s:30:\"next_prev_style_comments_above\";
s:42:\"margin: 0 0 10px 0;
\r\npadding: 5px 0 5px 0;
\";
s:30:\"next_prev_style_comments_below\";
s:42:\"margin: 0 0 10px 0;
\r\npadding: 5px 0 5px 0;
\";
s:29:\"next_prev_comments_pagination\";
s:3:\"Yes\";
s:24:\"location_multi_next_prev\";
s:14:\"Top and Bottom\";
s:25:\"location_single_next_prev\";
s:22:\"Top, Middle and Bottom\";
s:19:\"next_prev_style_top\";
s:76:\"border-top: solid 6px #eee;
\r\nborder-bottom: solid 2px #eee;
\r\npadding: 8px 0;
\";
s:22:\"next_prev_style_middle\";
s:100:\"margin: 10px 0 20px 0;
\r\npadding: 8px 0;
\r\nborder-top: solid 6px #eee;
\r\nborder-bottom: solid 6px #eee;
\";
s:22:\"next_prev_style_bottom\";
s:70:\"margin: 20px 0 0 0;
\r\npadding: 10px 0 0 0;
\r\nborder-top: solid 6px #eee;
\";
s:10:\"leftcol_on\";
a:1:{s:19:\"check-if-saved-once\";
s:5:\"saved\";
}s:22:\"left_col_pages_exclude\";
s:0:\"\";
s:21:\"left_col_cats_exclude\";
s:0:\"\";
s:11:\"leftcol2_on\";
a:1:{s:19:\"check-if-saved-once\";
s:5:\"saved\";
}s:23:\"left_col2_pages_exclude\";
s:0:\"\";
s:22:\"left_col2_cats_exclude\";
s:0:\"\";
s:11:\"rightcol_on\";
a:13:{s:8:\"homepage\";
s:2:\"on\";
s:9:\"frontpage\";
s:2:\"on\";
s:6:\"single\";
s:2:\"on\";
s:4:\"page\";
s:2:\"on\";
s:8:\"category\";
s:2:\"on\";
s:4:\"date\";
s:2:\"on\";
s:3:\"tag\";
s:2:\"on\";
s:8:\"taxonomy\";
s:2:\"on\";
s:6:\"search\";
s:2:\"on\";
s:6:\"author\";
s:2:\"on\";
i:404;
s:2:\"on\";
s:10:\"attachment\";
s:2:\"on\";
s:19:\"check-if-saved-once\";
s:5:\"saved\";
}s:23:\"right_col_pages_exclude\";
s:0:\"\";
s:22:\"right_col_cats_exclude\";
s:0:\"\";
s:12:\"rightcol2_on\";
a:1:{s:19:\"check-if-saved-once\";
s:5:\"saved\";
}s:24:\"right_col2_pages_exclude\";
s:0:\"\";
s:23:\"right_col2_cats_exclude\";
s:0:\"\";
s:18:\"left_sidebar_width\";
s:3:\"200\";
s:19:\"left_sidebar2_width\";
s:3:\"200\";
s:19:\"right_sidebar_width\";
s:3:\"250\";
s:20:\"right_sidebar2_width\";
s:3:\"200\";
s:18:\"left_sidebar_style\";
s:20:\"padding-right: 10px;
\";
s:19:\"left_sidebar2_style\";
s:20:\"padding-right: 10px;
\";
s:19:\"right_sidebar_style\";
s:19:\"padding-left: 10px;
\";
s:20:\"right_sidebar2_style\";
s:19:\"padding-left: 10px;
\";
s:16:\"widget_container\";
s:234:\"font-size: 12px;
\r\nmargin: 0 0 10px 0;
\r\npadding: 10px;
\r\nborder: solid 4px #eee;
\r\n/* uncomment next block for round corners */\r\n/*\r\n-moz-border-radius:5px;
\r\n-khtml-border-radius: 5px;
\r\n-webkit-border-radius:5px;
\r\nborder-radius: 5px;
\r\n*/\";
s:16:\"widget_title_box\";
s:0:\"\";
s:12:\"widget_title\";
s:182:\"font-size: 0.8em;
\r\nfont-weight: normal;
\r\ntext-transform: uppercase;
\r\nletter-spacing: 1px;
\r\ncolor: #333;
\r\nborder-bottom: solid 1px #eee;
\r\npadding-bottom: 10px;
\r\nmargin-bottom: 10px;
\r\n\";
s:14:\"widget_content\";
s:0:\"\";
s:12:\"widget_lists\";
a:8:{s:14:\"li-margin-left\";
s:1:\"0\";
s:22:\"link-border-left-width\";
s:1:\"0\";
s:22:\"link-border-left-color\";
s:6:\"CCCCCC\";
s:28:\"link-border-left-hover-color\";
s:6:\"000000\";
s:17:\"link-padding-left\";
s:1:\"0\";
s:11:\"link-weight\";
s:6:\"normal\";
s:10:\"link-color\";
s:6:\"365DA0\";
s:16:\"link-hover-color\";
s:6:\"365DA0\";
}s:13:\"widget_lists2\";
a:8:{s:14:\"li-margin-left\";
s:1:\"5\";
s:22:\"link-border-left-width\";
s:1:\"0\";
s:22:\"link-border-left-color\";
s:6:\"CCCCCC\";
s:28:\"link-border-left-hover-color\";
s:6:\"000000\";
s:17:\"link-padding-left\";
s:1:\"0\";
s:11:\"link-weight\";
s:6:\"normal\";
s:10:\"link-color\";
s:6:\"365DA0\";
s:16:\"link-hover-color\";
s:6:\"365DA0\";
}s:13:\"widget_lists3\";
a:8:{s:14:\"li-margin-left\";
s:1:\"5\";
s:22:\"link-border-left-width\";
s:1:\"0\";
s:22:\"link-border-left-color\";
s:6:\"CCCCCC\";
s:28:\"link-border-left-hover-color\";
s:6:\"000000\";
s:17:\"link-padding-left\";
s:1:\"0\";
s:11:\"link-weight\";
s:6:\"normal\";
s:10:\"link-color\";
s:6:\"365DA0\";
s:16:\"link-hover-color\";
s:6:\"365DA0\";
}s:28:\"category_widget_display_type\";
s:6:\"inline\";
s:16:\"select_font_size\";
s:7:\"Default\";
s:16:\"post_kicker_home\";
s:0:\"\";
s:17:\"post_kicker_multi\";
s:0:\"\";
s:18:\"post_kicker_single\";
s:0:\"\";
s:16:\"post_kicker_page\";
s:0:\"\";
s:16:\"post_byline_home\";
s:29:\"%date(\'j. F Y\')%, By %author%\";
s:17:\"post_byline_multi\";
s:29:\"%date(\'j. F Y\')%, By %author%\";
s:18:\"post_byline_single\";
s:29:\"%date(\'j. F Y\')%, By %author%\";
s:16:\"post_byline_page\";
s:0:\"\";
s:16:\"post_footer_home\";
s:141:\"<image(folder-gray.gif)> %categories-linked(\', \')% %tags-linked(\'&nbsp;
 <image(tag-gray.gif)> \', \', \', \' &nbsp;
 \')% %edit(\' | \', \'Edit\', \'\')%\";
s:17:\"post_footer_multi\";
s:141:\"<image(folder-gray.gif)> %categories-linked(\', \')% %tags-linked(\'&nbsp;
 <image(tag-gray.gif)> \', \', \', \' &nbsp;
 \')% %edit(\' | \', \'Edit\', \'\')%\";
s:18:\"post_footer_single\";
s:141:\"<image(folder-gray.gif)> %categories-linked(\', \')% %tags-linked(\'&nbsp;
 <image(tag-gray.gif)> \', \', \', \' &nbsp;
 \')% %edit(\' | \', \'Edit\', \'\')%\";
s:16:\"post_footer_page\";
s:0:\"\";
s:20:\"post_container_style\";
s:68:\"margin: 0 0 30px 0;
\r\nborder-top: solid 4px #eee;
\r\npadding-top: 20px;
\";
s:27:\"post_container_sticky_style\";
s:145:\"background: #eee url(\'<?php bloginfo(\'template_directory\');
 ?>/images/sticky.gif\') 99% 5% no-repeat;
\r\nborder: dashed 1px #cccccc;
\r\npadding: 10px;
\";
s:17:\"post_kicker_style\";
s:18:\"margin: 0 0 5px 0;
\";
s:23:\"post_kicker_style_links\";
s:86:\"color: #999;
\r\ntext-decoration: none;
\r\ntext-transform: uppercase;
\r\nletter-spacing: 1px;
\";
s:29:\"post_kicker_style_links_hover\";
s:15:\"color: #cc0000;
\";
s:19:\"post_headline_style\";
s:0:\"\";
s:24:\"post_headline_style_text\";
s:42:\"padding: 0;
\r\nmargin: 0;
\r\nfont-size: 1.7em;
\";
s:25:\"post_headline_style_links\";
s:0:\"\";
s:31:\"post_headline_style_links_hover\";
s:0:\"\";
s:17:\"post_byline_style\";
s:103:\"margin: 5px 0 10px 0;
\r\ncolor: #999;
\r\ntext-transform: uppercase;
\r\nletter-spacing: 1px;
\r\nfont-size: 11px;
\";


Garwen Jun 15, 2011 06:20 AM

Code:

s:23:\"post_byline_style_links\";
s:0:\"\";
s:29:\"post_byline_style_links_hover\";
s:0:\"\";
s:19:\"post_bodycopy_style\";
s:0:\"\";
s:17:\"post_footer_style\";
s:80:\"color: #999;
\r\ntext-transform: uppercase;
\r\nletter-spacing: 1px;
\r\nfont-size: 11px;
\";
s:23:\"post_footer_style_links\";
s:58:\"color: #999;
\r\nfont-weight: normal;
\r\ntext-decoration: none;
\";
s:29:\"post_footer_style_links_hover\";
s:63:\"color: #333;
\r\nfont-weight: normal;
\r\ntext-decoration: underline;
\";
s:14:\"excerpt_length\";
s:2:\"55\";
s:19:\"dont_strip_excerpts\";
s:3:\"<p>\";
s:16:\"custom_read_more\";
s:90:\"<span style=\"color:#777\"> . . . &rarr;
 Read More: <a href=\"%permalink%\">%title%</a></span>\";
s:13:\"excerpts_home\";
s:13:\"Only Excerpts\";
s:19:\"full_posts_homepage\";
s:1:\"0\";
s:17:\"excerpts_category\";
s:13:\"Only Excerpts\";
s:16:\"excerpts_archive\";
s:13:\"Only Excerpts\";
s:12:\"excerpts_tag\";
s:13:\"Only Excerpts\";
s:15:\"excerpts_search\";
s:13:\"Only Excerpts\";
s:15:\"excerpts_author\";
s:13:\"Only Excerpts\";
s:20:\"post_thumbnail_width\";
i:150;
s:21:\"post_thumbnail_height\";
i:150;
s:19:\"post_thumbnail_crop\";
s:2:\"No\";
s:18:\"post_thumbnail_css\";
s:76:\"float: left;
\r\nborder: 0;
\r\npadding: 0;
\r\nbackground: none;
\r\nmargin: 0 10px 5px 0;
\r\n\";
s:8:\"more_tag\";
s:17:\"mehr %post-title%\";
s:16:\"author_highlight\";
s:3:\"Yes\";
s:22:\"author_highlight_color\";
s:6:\"FFECEC\";
s:29:\"author_highlight_border_color\";
s:6:\"FFBFBF\";
s:24:\"comment_background_color\";
s:6:\"FFFFFF\";
s:28:\"comment_alt_background_color\";
s:6:\"EEEEEE\";
s:14:\"comment_border\";
s:18:\"dotted 1px #cccccc\";
s:19:\"comment_author_size\";
s:4:\"110%\";
s:23:\"comment_reply_link_text\";
s:15:\" &middot;
 Reply\";
s:22:\"comment_edit_link_text\";
s:14:\" &middot;
 Edit\";
s:23:\"comment_moderation_text\";
s:36:\"Your comment is awaiting moderation.\";
s:24:\"comments_are_closed_text\";
s:27:\"<p>Comments are closed.</p>\";
s:17:\"comments_on_pages\";
s:2:\"No\";
s:19:\"separate_trackbacks\";
s:2:\"No\";
s:11:\"avatar_size\";
s:2:\"65\";
s:12:\"avatar_style\";
s:192:\"margin: 0 8px 1px 0;
\r\npadding: 3px;
\r\nborder: solid 1px #ddd;
\r\nbackground-color: #f3f3f3;
\r\n-moz-border-radius: 3px;
\r\n-khtml-border-radius: 3px;
\r\n-webkit-border-radius: 3px;
\r\nborder-radius: 3px;
\";
s:15:\"show_xhtml_tags\";
s:3:\"Yes\";
s:18:\"comment_form_style\";
s:154:\"margin: 25px 0;
\r\npadding: 25px;
\r\nbackground: #eee;
\r\n-moz-border-radius: 8px;
\r\n-khtml-border-radius: 8px;
\r\n-webkit-border-radius: 8px;
\r\nborder-radius: 8px;
\";
s:19:\"submit_button_style\";
s:82:\"padding: 4px 10px 4px 10px;
\r\nfont-size: 1.2em;
\r\nline-height: 1.5em;
\r\nheight: 36px;
\";
s:21:\"comment_display_order\";
s:13:\"Oldest on top\";
s:12:\"footer_style\";
s:124:\"background-color: #f7f7f7;
\r\nborder-top: solid 4px #eee;
\r\npadding: 10px;
\r\ntext-align: center;
\r\ncolor: #888;
\r\nfont-size: 11px;
\";
s:18:\"footer_style_links\";
s:61:\"text-decoration: none;
\r\ncolor: #777777;
\r\nfont-weight: normal;
\";
s:24:\"footer_style_links_hover\";
s:61:\"text-decoration: none;
\r\ncolor: #777777;
\r\nfont-weight: normal;
\";
s:20:\"footer_style_content\";
s:60:\"Copyright &copy;
 %current-year% %home% - All Rights Reserved\";
s:20:\"sticky_layout_footer\";
s:2:\"No\";
s:19:\"footer_show_queries\";
s:2:\"No\";
s:5:\"table\";
s:43:\"border-collapse: collapse;
\r\nmargin: 10px 0;
\";
s:13:\"table_caption\";
s:74:\"background: #eeeeee;
\r\nborder: #999999;
\r\npadding: 4px 8px;
\r\ncolor: #666666;
\";
s:8:\"table_th\";
s:140:\"background: #888888;
\r\ncolor: #ffffff;
\r\nfont-weight: bold;
\r\nfont-size: 90%;
\r\npadding: 4px 8px;
\r\nborder: solid 1px #ffffff;
\r\ntext-align: left;
\";
s:8:\"table_td\";
s:99:\"padding: 4px 8px;
\r\nbackground-color: #ffffff;
\r\nborder-bottom: 1px solid #dddddd;
\r\ntext-align: left;
\";
s:14:\"table_tfoot_td\";
s:0:\"\";
s:19:\"table_zebra_stripes\";
s:3:\"Yes\";
s:14:\"table_zebra_td\";
s:20:\"background: #f4f4f4;
\";
s:16:\"table_hover_rows\";
s:3:\"Yes\";
s:14:\"table_hover_td\";
s:20:\"background: #e2e2e2;
\";
s:22:\"form_input_field_style\";
s:145:\"color: #000000;
\r\nborder-top: solid 1px #333333;
\r\nborder-left: solid 1px #333333;
\r\nborder-right: solid 1px #999999;
\r\nborder-bottom: solid 1px #cccccc;
\";
s:27:\"form_input_field_background\";
s:15:\"inputbackgr.gif\";
s:15:\"highlight_forms\";
s:3:\"Yes\";
s:21:\"highlight_forms_style\";
s:43:\"background: #e8eff7;
\r\nborder-color: #37699f;
\";
s:12:\"button_style\";
s:88:\"background-color: #777777;
\r\ncolor: #ffffff;
\r\nborder: solid 2px #555555;
\r\nfont-weight: bold;
\";
s:18:\"button_style_hover\";
s:69:\"background-color: #6b9c6b;
\r\ncolor: #ffffff;
\r\nborder: solid 2px #496d49;
\";
s:16:\"blockquote_style\";
s:81:\"color: #555555;
\r\npadding: 1em 1em;
\r\nbackground: #f4f4f4;
\r\nborder: solid 1px #e1e1e1;
\";
s:26:\"blockquote_style_2nd_level\";
s:81:\"color: #444444;
\r\npadding: 1em 1em;
\r\nbackground: #e1e1e1;
\r\nborder: solid 1px #d3d3d3;
\";
s:16:\"post_image_style\";
s:167:\"padding: 5px;
\r\nborder: solid 1px #dddddd;
\r\nbackground-color: #f3f3f3;
\r\n-moz-border-radius: 3px;
\r\n-khtml-border-radius: 3px;
\r\n-webkit-border-radius: 3px;
\r\nborder-radius: 3px;
\";
s:24:\"post_image_caption_style\";
s:211:\"border: 1px solid #dddddd;
\r\ntext-align: center;
\r\nbackground-color: #f3f3f3;
\r\npadding-top: 4px;
\r\nmargin: 10px 0 0 0;
\r\n-moz-border-radius: 3px;
\r\n-khtml-border-radius: 3px;
\r\n-webkit-border-radius: 3px;
\r\nborder-radius: 3px;
\";
s:18:\"image_caption_text\";
s:85:\"font-size: 0.8em;
\r\nline-height: 13px;
\r\npadding: 2px 4px 5px;
\r\nmargin: 0;
\r\ncolor: #666666;
\";
s:19:\"html_inserts_header\";
s:0:\"\";
s:21:\"html_inserts_body_tag\";
s:0:\"\";
s:21:\"html_inserts_body_top\";
s:0:\"\";
s:24:\"html_inserts_body_bottom\";
s:0:\"\";
s:16:\"html_inserts_css\";
s:1809:\"td#header { \r\npadding-bottom: 15px;
 \r\n}\r\n/* removing the padding here and putting them on the sidebars instead. That way the middle column aligns nicely with the header when there are no sidebars */\r\ntd#middle {\r\npadding: 0;
\r\n}\r\ndiv.searchbox-form {\r\nmargin: 5px 0 15px 5px;
\r\n}\r\ndiv#menu1 ul.rMenu {\r\nbackground: transparent;
\r\nborder: none;
\r\n}\r\ndiv#imagecontainer { \r\nborder-top: solid 5px #333;
 \r\nborder-bottom: solid 5px #333;
 \r\n}\r\ndiv.widget ul li {\r\npadding: 1px 5px 1px 12px !important;
\r\nbackground: url(\'<?php bloginfo(\'template_directory\');
 ?>/images/bullets/round-gray.gif\') no-repeat 0 7px;
\r\n}\r\n/* Adjustments for the menu bars, which in their default \r\nstate have 1px borders plus -1px margins to avoid 1+1=2px \r\nborders between neighbor items. */\r\nul.rMenu-hor ul, ul.rMenu-hRight ul { margin-top: 0px;
/n }\r\nul.rMenu-hor li { margin-bottom: 0px;
 margin-top: 0px;
 margin-left: 0px;
 }\r\nul.rMenu-hor { padding-left: 0px;
 }\r\nul.rMenu-ver li { margin-top: 0xp;
 }\r\n\r\ndiv#menu1 ul.rMenu li a, div#menu2 ul.rMenu li a {\r\npadding: 6px 10px;
        \r\n}\r\n/* Space between items of page menu bar */\r\ndiv#menu1 ul.rMenu li {\r\nmargin-right: 5px;
\r\n}\r\n/* Reset margin for 2nd+ level items */\r\ndiv#menu1 ul.rMenu li li {\r\nmargin-right: 0;
\r\n}\r\n/* round corners for page menu bar items */\r\ndiv#menu1 ul.rMenu li, div#menu1 ul.rMenu li a {\r\n-webkit-border-top-left-radius: 5px;
\r\n-webkit-border-top-right-radius: 5px;
\r\n-moz-border-radius-topleft: 5px;
\r\n-moz-border-radius-topright: 5px;
\r\nborder-top-left-radius: 5px;
\r\nborder-top-right-radius: 5px;
\r\n}\r\n/* reset 2nd+ level */\r\ndiv#menu1 ul.rMenu li li, div#menu1 ul.rMenu li li a {\r\n-webkit-border-top-left-radius: 0;
\r\n-webkit-border-top-right-radius: 0;
\r\n-moz-border-radius-topleft: 0;
\r\n-moz-border-radius-topright: 0;
\r\nborder-top-left-radius: 0;
\r\nborder-top-right-radius: 0;
\r\n}\";
s:16:\"archives_page_id\";
s:0:\"\";
s:18:\"archives_date_show\";
s:3:\"Yes\";
s:19:\"archives_date_title\";
s:17:\"Archives by Month\";
s:18:\"archives_date_type\";
s:7:\"monthly\";
s:19:\"archives_date_limit\";
s:0:\"\";
s:19:\"archives_date_count\";
s:3:\"Yes\";
s:22:\"archives_category_show\";
s:3:\"Yes\";
s:23:\"archives_category_title\";
s:20:\"Archives by Category\";
s:23:\"archives_category_count\";
s:3:\"Yes\";
s:23:\"archives_category_depth\";
s:1:\"0\";
s:25:\"archives_category_orderby\";
s:4:\"name\";
s:23:\"archives_category_order\";
s:3:\"ASC\";
s:22:\"archives_category_feed\";
s:2:\"No\";
s:12:\"css_external\";
s:6:\"Inline\";
s:19:\"javascript_external\";
s:6:\"Inline\";
s:16:\"pngfix_selectors\";
s:53:\"a.posts-icon, a.comments-icon, a.email-icon, img.logo\";
s:12:\"css_compress\";
s:3:\"Yes\";
s:11:\"allow_debug\";
s:3:\"Yes\";
s:16:\"bfa_widget_areas\";
b:0;
s:11:\"h_blogtitle\";
i:1;
s:11:\"h_posttitle\";
i:2;
s:21:\"animate_page_menu_bar\";
s:2:\"No\";
}','yes');


Garwen Jun 15, 2011 06:22 AM

This seems to be correct, the style should be light blue background with blue text and 2 columns, widgets on the right side.

juggledad Jun 15, 2011 07:09 AM

what do you get if you go to ato->export/import settings and do an export?
attach the file to a reply

Garwen Jun 15, 2011 07:21 AM

2 Attachment(s)
looks like I get what the page shows, but not the same as in the database :)

Garwen Jun 16, 2011 07:33 AM

Ok, had the time to do some more testing today.

Did the following Steps:
  1. activate Twenty Ten
  2. delete the row "bfa_ata4" in "wp_options"
  3. Execute the SQL string from the dump "insert into "wp_options...etc"
  4. check the row "bfa_ata4": it's there with the correct data
  5. activate the theme Atahualpa
  6. check the row "bfa_ata4" again = row has been changed, default settings are in there now
Apparently the theme code does not accept the data inserted from the sql dump and instead just loads the theme default settings.

Is there any way to force the data from the sql dump ?
Or do you have a script to convert the data from the field "bfa_ata4" into an export file ?

juggledad Jun 16, 2011 07:40 AM

How did you do the dump? As you know, the settings are stored in the 'bfa_ata4' row in the wp_option table. Now if you did the sql dump of the entire database, then a restore should be transparent to any application running, because, since everything is gotten from the database, it should be back at it's state when the dump was made.

Garwen Jun 16, 2011 08:12 AM

I'm doing the backup with the plugin "XCloner".
Basically it's running a "mysqldump --quote-names", storing it into {wp-root}/administrator and then building a .tgz from the entire {wp-root} including subdirectoires.

Last tuesday I restored this .tgz from monday, including all wordpress files.

I also tried to erase the entire database and restore it from the dump, with the same effect.
I just don't get, why this should not work.

juggledad Jun 16, 2011 11:36 AM

Well I would venture to guess that there is an issue with xcloner.

I would do some serious checking on what it dumps and what a mysql export gives you.


All times are GMT -6. The time now is 03:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.