Crazy Errors on Site - Resolved

Figured this would be a good place to save this, as apparently its been a common issue with Drupal. 

In the new Drupal Core, apparently if a module has a structure such as FOLDERNAME/FOLDERNAME/FOLDERNAME.PHP it causes the update protion of the site to reduplicate over and over the word FOLDERNAME...so here is error. Apparently its a mix of cache issues and registry issues.  

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:13:{s:4:"name";s:24:"
        Google Analytics Reports";s:7:"package";s:10:"Statistics";s:11:"description";s:61:"
         Provides interface to access Google Analytics API statistics.";s:4:"core";s:3:"7.x";s:12:"
      dependencies";a:2:{i:0;s:20:"google_analytics_api";i:1;s:5:"chart";}s:5:"files";a:6:{i:0;s:35:"
    google_analytics_reports.blocks.inc";i:1;s:28:"google_analytics_reports.css";i:2;s:
     32:"google_analytics_reports.install";i:3;s:31:"google_analytics_reports.module";i:4;s:34:"
     google_analytics_reports.pages.inc";i:5;s:34:

      "google_analytics_reports.theme.inc";}s:11:"stylesheets";a:1:{s:3:"all";a:1:{s:28:"google_analytics_reports.css";s:271:
       "sites/all/modules/google_analytics_reports
       /google_analytics_reports/google_analytics_reports/
        google_analytics_reports/google_analytics_reports/google_analytics_reports/
        google_analytics_reports/google_analytics_reports/google_analytics_reports/google_analytics_reports.css";}}
       s:7:"scripts";a:1:{s:27:"
        google_analytics_reports.js";s:270:"sites/all/modules/google_analytics_reports/google_analytics_reports/
        google_analytics_reports/google_analytics_reports
        /google_analytics_reports/google_analytics_reports/google_analytics_reports/google_analytics_reports
         google_analytics_reports/google_analytics_reports.js";}s:7:"version";s:7:"7.x-1.3";s:7:"project";s:24:"google_analytics_reports";s:9:"
       datestamp";s:10:"1347342186";s:3:"php";s:5:"5.2.4";s:9:"bootstrap";i:0;} [:db_update_placeholder_1] => sites/all/modules/
      google_analytics_reports/google_analytics_reports/google_analytics_reports/google_analytics_reports
     /google_analytics_reports/google_analytics_reports/google_analytics_reports/
      google_analytics_reports/google_analytics_reports/google_analytics_reports.module [:db_condition_placeholder_0] => sites/all/modules/google_analytics_reports/
       google_analytics_reports/google_analytics_reports/google_analytics_reports/google
      _analytics_reports/google_analytics_reports/google_analytics_reports
       /google_analytics_reports/google_analytics_reports.module ) in 
system_update_files_database() (line 2247 of/
      home1/circtech/public_html/evolveproject/modules/system/system.module
).

 

Solution:

 

Download: http://drupal.org/project/registry_rebuild   (this isn't a module) 
 
(IMPORTANT:Remove the module from the folder structure that is listed in the error. so For me, I deleted the Google Analytics Report Module.)
 
1. Download and extract registry rebuild.
 
2. Open your ftp client and log-in, then copy the extracted folder to sites/all/modules/. You will now have this directory sites/all/modules/registry_rebuild.
 
3. Now place this to your browser: example.com/sites/all/modules/registry_rebuild/registry_rebuild.php
 
and hit enter.
 
I saw this when complete:
DRUPAL_ROOT is /home1/circtech/public_html/evolveproject.
Bootstrapping to DRUPAL_BOOTSTRAP_SESSION
Doing registry_rebuild() in DRUPAL_BOOTSTRAP_SESSION
Bootstrapping to DRUPAL_BOOTSTRAP_FULL
Doing registry_rebuild() in DRUPAL_BOOTSTRAP_FULL
Deleted 10 stale files from registry manually.Flushing all caches
There were 509 files in the registry before and 499 files now.
If you don't see any crazy fatal errors, your registry has been rebuilt.
 
 
 
 
Hopes this saves someone elses day:)
 

Add new comment

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
3 + 4 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.
By submitting this form, you accept the Mollom privacy policy.