I updated the module and now the site is dead in the backend, I can't access any function and only can see this:
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.1";s:7:"project";s:24:"google_analytics_reports";s:9:"datestamp";s:10:"1334612199";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 ) en system_update_files_database() (lÃnea 2247 de /home/arabatjo/public_html/modules/system/system.module)
I've been in the db, disabled the module from there, cleared system in cached_bootstrap table too...Last, I tried to increase the column lenght to 1000 but doesn't let me (i thought so) nothing seems to work.
Please help
Thanks
nico
Comments
Comment #1
grendzy CreditAttribution: grendzy commentedLooks like the same issue as #1558190: error when upgrading from 7.x-1.0 to 7.x-1.1.
Wish I knew what was going on, the error references files that don't exist.
Comment #2
nicodv CreditAttribution: nicodv commentedOuch (thanks for the fast answer)
Then if I do as you said in the other thread : "Make a full backup of the site's files and database
Delete the google_analytics_reports directory
run DELETE FROM system WHERE name = 'google_analytics_reports';
Download a fresh copy of the module and re-enable"
Things will go back to life again?
Comment #3
grendzy CreditAttribution: grendzy commentedThat's my advice, yes. The reporter in the other issue never followed up, so I'm not sure if they resolved it. Personally I've never seen this happen before and am rather puzzled.
Before you delete the module's directory, I would be interested to know if sites/all/modules/google_analytics_reports/google_analytics_reports/google_analytics_reports/google_analytics_reports....... actually exists in your filesystem. It might help narrow down the source of the problem. Instead of the same directory over and over, it should look like this:
Comment #4
nicodv CreditAttribution: nicodv commentedYes, the google_analytics_reports folder is repeated n times within each other.. weird
...well, not n times, but this public_html/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
many times
Next steps?
Comment #5
nicodv CreditAttribution: nicodv commentedWell, momentanously solved by removing the google_analytics_reports directory from cpanel.
Thanks for the support
Comment #6
grendzy CreditAttribution: grendzy commentedI was able to reproduce, and It looks like this is a core bug in the update manager. I'll be moving the earlier report #1558190: error when upgrading from 7.x-1.0 to 7.x-1.1 to the core queue shortly. Please follow that issue if you wish to follow the progress of this bug.
In the meantime, a workaround is to delete the module, and manually download the tar.gz file (or zip) from drupal.org.
Comment #7
nicodv CreditAttribution: nicodv commentedill follow it, thanks
Comment #8
PhobosK CreditAttribution: PhobosK commentedThis bug is still existing when upgrading to 7.x-1.2, rendering the site unusable.
Multiple entries in the "filename" exist (an sql export):
('admin/reports/google-analytics', '', '', 'user_access', 0xBLAHBLAHBLAH, 'google_analytics_reports_summary_page', 0xBLAHBLAHBLAH, '', 7, 3, 0, '', 'admin/reports/google-analytics', 'Google Analytics Summary', 't', '', '', 'a:0:{}', 6, 'View a traffic report for your site.', '', 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.pages.inc'),
('admin/reports/google-analytics/detail', '', '', 'user_access', 0xBLAHBLAHBLAH, 'google_analytics_reports_detail_page', 0xBLAHBLAHBLAH, '', 15, 4, 0, '', 'admin/reports/google-analytics/detail', 'Content Detail', 't', '', '', 'a:0:{}', 0, '', '', 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.pages.inc'),
Comment #9
grendzy CreditAttribution: grendzy commentedThis is a duplicate of #1558190: error when upgrading from 7.x-1.0 to 7.x-1.1.
It's a bug in Drupal's core update manager, the workaround for now is:
DELETE FROM system WHERE name = 'google_analytics_reports';
Comment #10
Solarisserv CreditAttribution: Solarisserv commentedThis error occurs on 7.15 also ..
As usual deleting the module definition from the database and removing module directory from the filesystem , Thank you Dylan for posting the exact steps to overcome this error.
Comment #11
inventlogic CreditAttribution: inventlogic commentedThis is happening in the upgrade from 7.x-1.2 to 7.x-1.3.
I did not even have the module enabled.
Deleted the module directory using SSH.
Downloaded the module again using drush and problem went away.