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
Comment #1
GAtherton CreditAttribution: GAtherton commentedI 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
Comment #2
Jeff Burnz CreditAttribution: Jeff Burnz commentedI 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=...
Comment #3
GAtherton CreditAttribution: GAtherton commentedI 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
Comment #4
GAtherton CreditAttribution: GAtherton commentedI 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
Comment #5
Jeff Burnz CreditAttribution: Jeff Burnz commentedRun a test offline:
sites/all/themes/adaptivetheme
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.
Comment #6
GAtherton CreditAttribution: GAtherton commentedThanks 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