Latest update was applied along with an update to admin_menu module after both appeared as available updates. An error was generated but I did not copy that message, not expecting a major problem. However I now cannot access the majority of admin pages - modules, administrator, people, reports and more and get an error message 'The website encountered an unexpected error. Please try again later.'

This was true when using the admin menu but is also true if I try to getaround using URL www.aspergillus.org.uk/admin

Thus far I have not noticed any problem with the web pages themselves (including edit, display) - just admin pages

I have turned off the admin menu and it makes no noticeable difference - still get same errors when I try www.aspergillus.org.uk/admin

Next 2 suspects: AT update (applied 10/1/2015) and the update system itself

I can trigger the following message if I try to run update.php via the URL www.aspergillus.org.uk/update.php

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'filename' at row 1: UPDATE {system} SET info=:db_update_placeholder_0, filename=:db_update_placeholder_1 WHERE (filename = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => a:19:{s:4:"name";s:8:"AT Admin";s:11:"description";s:144:"A better admin theme for Drupal 7. Clean, calm, invisible. Includes left and right sidebars, Overlay support and all AT's theme setting goodies.";s:4:"core";s:3:"7.x";s:10:"base theme";s:13:"adaptivetheme";s:7:"release";s:7:"7.x-3.x";s:6:"engine";s:11:"phptemplate";s:10:"screenshot";s:250:"sites/all/themes/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/at_admin/screenshot.png";s:11:"stylesheets";a:1:{s:6:"screen";a:1:{s:16:"css/at_admin.css";s:252:"sites/all/themes/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/at_admin/css/at_admin.css";}}s:7:"regions";a:11:{s:7:"content";s:12:"Main content";s:13:"sidebar_first";s:13:"Sidebar first";s:14:"sidebar_second";s:14:"Sidebar second";s:11:"highlighted";s:11:"Highlighted";s:4:"help";s:4:"Help";s:6:"footer";s:6:"Footer";s:8:"page_top";s:8:"Page top";s:11:"page_bottom";s:11:"Page bottom";s:14:"dashboard_main";s:16:"Dashboard (main)";s:17:"dashboard_sidebar";s:19:"Dashboard (sidebar)";s:18:"dashboard_inactive";s:20:"Dashboard (inactive)";}s:8:"settings";a:210:{s:20:"shortcut_module_link";s:1:"1";s:16:"bigscreen_layout";s:15:"three_col_grail";s:19:"bigscreen_page_unit";s:1:"%";s:22:"bigscreen_sidebar_unit";s:2:"px";s:24:"bigscreen_max_width_unit";s:2:"px";s:20:"bigscreen_page_width";s:3:"100";s:23:"bigscreen_sidebar_first";s:3:"180";s:24:"bigscreen_sidebar_second";s:3:"180";s:23:"bigscreen_set_max_width";s:1:"1";s:19:"bigscreen_max_width";s:4:"1330";s:21:"bigscreen_media_query";s:34:"only screen and (min-width:1025px)";s:23:"tablet_landscape_layout";s:15:"three_col_grail";s:26:"tablet_landscape_page_unit";s:1:"%";s:29:"tablet_landscape_sidebar_unit";s:1:"%";s:27:"tablet_landscape_page_width";s:3:"100";s:30:"tablet_landscape_sidebar_first";s:2:"20";s:31:"tablet_landscape_sidebar_second";s:2:"20";s:28:"tablet_landscape_media_query";s:56:"only screen and (min-width:769px) and (max-width:1024px)";s:22:"tablet_portrait_layout";s:12:"one_col_vert";s:25:"tablet_portrait_page_unit";s:1:"%";s:28:"tablet_portrait_sidebar_unit";s:1:"%";s:26:"tablet_portrait_page_width";s:3:"100";s:29:"tablet_portrait_sidebar_first";s:2:"50";s:30:"tablet_portrait_sidebar_second";s:2:"50";s:27:"tablet_portrait_media_query";s:55:"only screen and (min-width:581px) and (max-width:768px)";s:27:"smalltouch_landscape_layout";s:12:"one_col_vert";s:30:"smalltouch_landscape_page_unit";s:1:"%";s:33:"smalltouch_landscape_sidebar_unit";s:1:"%";s:31:"smalltouch_landscape_page_width";s:3:"100";s:34:"smalltouch_landscape_sidebar_first";s:2:"50";s:35:"smalltouch_landscape_sidebar_second";s:2:"50";s:32:"smalltouch_landscape_media_query";s:55:"only screen and (min-width:321px) and (max-width:580px)";s:26:"smalltouch_portrait_layout";s:13:"one_col_stack";s:29:"smalltouch_portrait_page_unit";s:1:"%";s:32:"smalltouch_portrait_sidebar_unit";s:1:"%";s:30:"smalltouch_portrait_page_width";s:3:"100";s:33:"smalltouch_portrait_sidebar_first";s:3:"100";s:34:"smalltouch_portrait_sidebar_second";s:3:"100";s:31:"smalltouch_portrait_media_query";s:33:"only screen and (max-width:320px)";s:16:"bigscreen_two_50";s:6:"two-50";s:19:"bigscreen_two_33_66";s:9:"two-33-66";s:19:"bigscreen_two_66_33";s:9:"two-66-33";s:19:"bigscreen_two_brick";s:9:"two-brick";s:20:"bigscreen_three_3x33";s:10:"three-3x33";s:24:"bigscreen_three_25_50_25";s:14:"three-25-50-25";s:24:"bigscreen_three_25_25_50";s:14:"three-25-25-50";s:24:"bigscreen_three_50_25_25";s:14:"three-50-25-25";s:19:"bigscreen_four_4x25";s:9:"four-4x25";s:19:"bigscreen_five_5x20";s:9:"five-5x20";s:18:"bigscreen_six_6x16";s:8:"six-6x16";s:26:"bigscreen_three_inset_left";s:16:"three-inset-left";s:27:"bigscreen_three_inset_right";s:17:"three-inset-right";s:23:"tablet_landscape_two_50";s:6:"two-50";s:26:"tablet_landscape_two_33_66";s:9:"two-33-66";s:26:"tablet_landscape_two_66_33";s:9:"two-66-33";s:26:"tablet_landscape_two_brick";s:9:"two-brick";s:27:"tablet_landscape_three_3x33";s:10:"three-3x33";s:31:"tablet_landscape_three_25_50_25";s:14:"three-25-50-25";s:31:"tablet_landscape_three_25_25_50";s:14:"three-25-25-50";s:31:"tablet_landscape_three_50_25_25";s:14:"three-50-25-25";s:26:"tablet_landscape_four_4x25";s:9:"four-4x25";s:26:"tablet_landscape_five_5x20";s:18:"five-5x20-2x3-grid";s:25:"tablet_landscape_six_6x16";s:17:"six-6x16-3x2-grid";s:33:"tablet_landscape_three_inset_left";s:16:"three-inset-left";s:34:"tablet_landscape_three_inset_right";s:17:"three-inset-right";s:22:"tablet_portrait_two_50";s:6:"two-50";s:25:"tablet_portrait_two_33_66";s:9:"two-33-66";s:25:"tablet_portrait_two_66_33";s:9:"two-66-33";s:25:"tablet_portrait_two_brick";s:9:"two-brick";s:26:"tablet_portrait_three_3x33";s:20:"three-3x33-stack-top";s:30:"tablet_portrait_three_25_50_25";s:24:"three-25-50-25-stack-top";s:30:"tablet_portrait_three_25_25_50";s:24:"three-25-25-50-stack-top";s:30:"tablet_portrait_three_50_25_25";s:24:"three-50-25-25-stack-top";s:25:"tablet_portrait_four_4x25";s:18:"four-4x25-2x2-grid";s:25:"tablet_portrait_five_5x20";s:20:"five-5x20-1x2x2-grid";s:24:"tablet_portrait_six_6x16";s:17:"six-6x16-2x3-grid";s:32:"tablet_portrait_three_inset_left";s:21:"three-inset-left-wrap";s:33:"tablet_portrait_three_inset_right";s:22:"three-inset-right-wrap";s:27:"smalltouch_landscape_two_50";s:12:"two-50-stack";s:30:"smalltouch_landscape_two_33_66";s:15:"two-33-66-stack";s:30:"smalltouch_landscape_two_66_33";s:15:"two-66-33-stack";s:30:"smalltouch_landscape_two_brick";s:15:"two-brick-stack";s:31:"smalltouch_landscape_three_3x33";s:16:"three-3x33-stack";s:35:"smalltouch_landscape_three_25_50_25";s:20:"three-25-50-25-stack";s:35:"smalltouch_landscape_three_25_25_50";s:20:"three-25-25-50-stack";s:35:"smalltouch_landscape_three_50_25_25";s:20:"three-50-25-25-stack";s:30:"smalltouch_landscape_four_4x25";s:15:"four-4x25-stack";s:30:"smalltouch_landscape_five_5x20";s:15:"five-5x20-stack";s:29:"smalltouch_landscape_six_6x16";s:14:"six-6x16-stack";s:37:"smalltouch_landscape_three_inset_left";s:22:"three-inset-left-stack";s:38:"smalltouch_landscape_three_inset_right";s:23:"three-inset-right-stack";s:25:"disable_responsive_styles";s:1:"0";s:27:"enable_custom_media_queries";s:1:"0";s:21:"global_default_layout";s:19:"smalltouch-portrait";s:28:"global_default_layout_toggle";s:1:"0";s:17:"global_files_path";s:12:"public_files";s:12:"load_html5js";s:1:"1";s:19:"load_onmediaqueryjs";s:1:"0";s:14:"load_respondjs";s:1:"0";s:13:"load_ltie8css";s:1:"0";s:15:"load_scalefixjs";s:1:"0";s:14:"expose_regions";s:1:"0";s:15:"load_all_panels";s:1:"0";s:27:"load_all_panels_no_sidebars";s:1:"0";s:16:"show_window_size";s:1:"0";s:18:"rebuild_theme_data";s:1:"0";s:17:"enable_extensions";s:1:"1";s:20:"enable_font_settings";s:1:"0";s:23:"enable_heading_settings";s:1:"0";s:21:"enable_image_settings";s:1:"0";s:24:"enable_apple_touch_icons";s:1:"0";s:18:"enable_exclude_css";s:1:"0";s:17:"enable_custom_css";s:1:"0";s:22:"enable_context_regions";s:1:"0";s:26:"enable_float_region_blocks";s:1:"0";s:22:"enable_markup_overides";s:1:"1";s:14:"base_font_type";s:0:"";s:19:"site_name_font_type";s:0:"";s:21:"site_slogan_font_type";s:0:"";s:20:"page_title_font_type";s:0:"";s:20:"node_title_font_type";s:0:"";s:23:"comment_title_font_type";s:0:"";s:21:"block_title_font_type";s:0:"";s:9:"base_font";s:6:"bf-sss";s:14:"site_name_font";s:6:"snf-sl";s:16:"site_slogan_font";s:6:"ssf-sl";s:14:"main_menu_font";s:6:"mmf-sl";s:15:"page_title_font";s:6:"ptf-sl";s:15:"node_title_font";s:6:"ntf-sl";s:18:"comment_title_font";s:6:"ctf-sl";s:16:"block_title_font";s:6:"btf-sl";s:14:"base_font_size";s:3:"1em";s:19:"site_name_font_size";s:3:"2em";s:21:"site_slogan_font_size";s:5:"1.2em";s:20:"page_title_font_size";s:3:"2em";s:20:"node_title_font_size";s:5:"1.6em";s:23:"comment_title_font_size";s:5:"1.4em";s:21:"block_title_font_size";s:5:"1.4em";s:12:"h1_font_size";s:3:"2em";s:12:"h2_font_size";s:5:"1.6em";s:12:"h3_font_size";s:5:"1.4em";s:12:"h4_font_size";s:5:"1.2em";s:12:"h5_font_size";s:3:"1em";s:12:"h6_font_size";s:3:"1em";s:14:"site_name_case";s:5:"snc-n";s:16:"site_name_weight";s:5:"snw-b";s:19:"site_name_alignment";s:5:"sna-l";s:16:"site_name_shadow";s:5:"sns-n";s:16:"site_slogan_case";s:5:"ssc-n";s:18:"site_slogan_weight";s:5:"ssw-b";s:21:"site_slogan_alignment";s:5:"ssa-l";s:18:"site_slogan_shadow";s:5:"sss-n";s:15:"page_title_case";s:5:"ptc-n";s:17:"page_title_weight";s:5:"ptw-b";s:20:"page_title_alignment";s:5:"pta-l";s:17:"page_title_shadow";s:5:"pts-n";s:15:"node_title_case";s:5:"ntc-n";s:17:"node_title_weight";s:5:"ntw-b";s:20:"node_title_alignment";s:5:"nta-l";s:17:"node_title_shadow";s:5:"nts-n";s:18:"comment_title_case";s:5:"ctc-n";s:20:"comment_title_weight";s:5:"ctw-b";s:23:"comment_title_alignment";s:5:"cta-l";s:20:"comment_title_shadow";s:5:"cts-n";s:16:"block_title_case";s:6:"btc-uc";s:18:"block_title_weight";s:5:"btw-b";s:21:"block_title_alignment";s:5:"bta-l";s:18:"block_title_shadow";s:5:"bts-n";s:15:"image_alignment";s:4:"ia-l";s:22:"image_alignment_teaser";s:5:"iat-l";s:18:"image_caption_full";s:1:"0";s:20:"image_caption_teaser";s:1:"0";s:12:"image_teaser";s:1:"1";s:18:"breadcrumb_display";s:1:"1";s:15:"breadcrumb_home";s:1:"1";s:16:"breadcrumb_label";s:1:"0";s:16:"breadcrumb_title";s:1:"0";s:20:"breadcrumb_separator";s:8:" » ";s:29:"horizontal_login_block_enable";s:2:"on";s:22:"horizontal_login_block";s:1:"0";s:24:"login_block_remove_links";s:1:"0";s:25:"login_block_remove_openid";s:1:"0";s:19:"global_gutter_width";s:0:"";s:24:"page_full_width_wrappers";s:1:"0";s:29:"page_content_type_suggestions";s:1:"0";s:23:"menu_item_span_elements";s:1:"0";s:18:"extra_page_classes";s:1:"1";s:21:"extra_article_classes";s:1:"1";s:21:"extra_comment_classes";s:1:"1";s:19:"extra_block_classes";s:1:"1";s:18:"extra_menu_classes";s:1:"1";s:23:"extra_item_list_classes";s:1:"1";s:19:"comments_hide_title";s:1:"0";s:10:"feed_icons";s:1:"0";s:29:"unset_block_system_main_front";s:1:"0";s:16:"skip_link_target";s:13:"#main-content";s:26:"adv_search_extra_fieldsets";s:1:"0";s:10:"rel_author";s:1:"0";s:24:"mobile_friendly_metatags";s:1:"1";s:27:"adaptivetheme_meta_viewport";s:56:"width=device-width, initial-scale=1.0, user-scalable=yes";s:34:"adaptivetheme_meta_mobileoptimized";s:5:"width";s:35:"adaptivetheme_meta_handheldfriendly";s:4:"true";s:47:"adaptivetheme_meta_apple_mobile_web_app_capable";s:3:"yes";s:35:"adaptivetheme_meta_ie_document_mode";s:0:"";s:29:"adaptivetheme_meta_clear_type";s:1:"0";s:23:"apple_touch_icon_enable";s:1:"0";s:23:"apple_touch_icon_path_l";s:23:"images/touch-icon-l.png";s:23:"apple_touch_icon_path_m";s:23:"images/touch-icon-m.png";s:23:"apple_touch_icon_path_h";s:23:"images/touch-icon-h.png";s:10:"custom_css";s:0:"";}s:8:"features";a:5:{i:0;s:4:"logo";i:1;s:4:"name";i:2;s:7:"favicon";i:3;s:9:"main_menu";i:4;s:14:"secondary_menu";}s:7:"version";s:7:"7.x-3.2";s:7:"project";s:13:"adaptivetheme";s:9:"datestamp";s:10:"1395575059";s:3:"php";s:5:"5.2.4";s:7:"scripts";a:0:{}s:5:"mtime";i:1420919101;s:15:"overlay_regions";a:5:{i:0;s:14:"dashboard_main";i:1;s:17:"dashboard_sidebar";i:2;s:18:"dashboard_inactive";i:3;s:7:"content";i:4;s:4:"help";}s:14:"regions_hidden";a:2:{i:0;s:8:"page_top";i:1;s:11:"page_bottom";}} [:db_update_placeholder_1] => sites/all/themes/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/at_admin/adaptivetheme_admin.info [:db_condition_placeholder_0] => sites/all/themes/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/at_admin/adaptivetheme_admin.info ) in system_update_files_database() (line 2269 of /home2/asperweb/public_html/modules/system/system.module).
The website encountered an unexpected error. Please try again later.

I found a similar thread here: https://www.drupal.org/node/1602312 which suggests that the update system may be at fault but this is not the same situation so I want to ask for advice before trying the solution described there.

I can restore the website as it was on 9th using backups (and will have to shortly as we cannot wait long!) but would prefer a solution which would help if I see this again!

Thanks

Comments

GAtherton’s picture

I have got around this problem by rolling back but now very hesitant about applying this upgrade - any thoughts? I will do each upgrade separately this time and both have worked fine on another website I run

Thanks

Jeff Burnz’s picture

Category: Bug report » Support request
Priority: Major » Normal

I tried looking into this, its not really theme related, I found a lot of other issues in Drupal (other contrib modules) running into this exact problem. From what I can tell its an issue with the Drupal update system and MySQL, it might be worth trying some of the suggestions in the other treads.

You can google the error: String data, right truncated: 1406 Data too long for column

https://www.google.se/?gfe_rd=cr&ei=xQO1VLb4HO3nwAP3t4D4Ag&gws_rd=ssl#q=...

GAtherton’s picture

I have come back to this issue as I am currently unable to apply AT updates - this needs a fix!

I have read many of the comments on similar errors and ruled out some eg one increases the capacity of the offending database field but it is easy to see that being a short term solution

I have an image that shows the rather odd 15 fold reiterated files structure for adaptivetheme on my website - is this usual? Referring to the file structure in the SQL above I can confirm that sites/all/themes/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/at_admin/screenshot.png exists

Very odd directory structure though - or is it? Please advise. Other installs of AT I am running on other websites only have 2 levels of this directory structure, this one has 15 so far. A new level seems to be added every time updates is run for AT module! I would suspect that this repeating file structure is what is triggering the error as the URL overloads the database field.

Any suggestions or guidance? As it stands I am going to have to remove AT ultimately as I cannot update - is there a way I could remove & reinstall manually perhaps? I have tried renaming all adaptivetheme directories one at a time and each time it completely disables the website so all levels are being used!

http://www.aspergillus.org.uk/ATissue.jpg

GAtherton’s picture

I have come back to this issue after a few months in an attempt to solve it as back in January I simply got around the issue by rolling back the install of the AT update. Incidentally I use the same theme in several other sites that are not giving me this problem.

This has prevented my applying the several upgrades AT theme releases, which eventually will need to be done so I need a fix.

I get that this is a problem with update.php - but knowing that is not really a fix.

Looking at the SQL several others with a similar problem seem to have adjusted the capacity of the offending field (1406 Data too long for column 'filename' at row 1) but in my case this is already set to varchar(255) so there is no room for expansion there.

In another case (https://www.drupal.org/node/1602312) they removed the offending google_analytics_reports directory from 'system' table, but my case is different and I would have to delete AT Admin which would cause many problems on a highly active website

This directory structure exists in this website - a new level added every time I have attempted an AT module upgrade! sites/all/themes/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/adaptivetheme/at_admin/

I suspect that if a new level is added each time I update then that would explain the error - sooner or layer the URL will be too big for the field in the database.

I have other websites that run AT theme but these generate no more than 2 levels. Why is update generating new levels each time with this website?

See image of directory structure here http://www.aspergillus.org.uk/ATissue.jpg

Jeff Burnz’s picture

Run a test offline:

  • first delete everything under sites/all/themes/adaptivetheme
  • download a fresh version of Adaptivetheme, unzip it and add it to sites/all/themes
  • next manually truncate all "cache" database tables, you might have to bang away clearing caches etc until every thing comes back and works correctly etc

Like I say, run this as a test, it should work just fine, and do not use the automated update system inside Drupal to update a theme.

GAtherton’s picture

Thanks Jeff

Manually truncate all cache tables? I assume that this means emptying any table that begins [SITE-PREFIX_]cache* ? I use phpMyAdmin to access these tables so could empty them via that interface - I see that there are about 20 of them.

and/or just run 'clear caches' from admin?

It is useful to know that AT should not be updated via update.php!

Thanks