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

grendzy’s picture

Status:Active» Closed (duplicate)

Looks 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.

nicodv’s picture

Ouch (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?

grendzy’s picture

That'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:

modules/
└── google_analytics_reports
    ├── GAFeed.lib.inc
    ├── README.txt
    ├── google_analytics_api.info
    ├── google_analytics_api.install
    ├── google_analytics_api.module
    ├── google_analytics_api.pages.inc
    └── google_analytics_reports
        ├── google_analytics_reports.blocks.inc
        ├── google_analytics_reports.css
        ├── google_analytics_reports.info
        ├── google_analytics_reports.install
        ├── google_analytics_reports.js
        ├── google_analytics_reports.module
        ├── google_analytics_reports.pages.inc
        ├── google_analytics_reports.theme.inc
        ├── google_analytics_reports_detail.tpl.php
        └── google_analytics_reports_summary.tpl.php
nicodv’s picture

Yes, 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?

nicodv’s picture

Well, momentanously solved by removing the google_analytics_reports directory from cpanel.

Thanks for the support

grendzy’s picture

I 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.

nicodv’s picture

ill follow it, thanks

PhobosK’s picture

Version:7.x-1.1» 7.x-1.2
Component:Code» Reports module
Status:Closed (duplicate)» Active

This 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'),

grendzy’s picture

Status:Active» Closed (duplicate)

This 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:

  • 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
sakaem’s picture

This 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.

inventlogic’s picture

Version:7.x-1.2» 7.x-1.3

This 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.