Got this at install:

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'description' at row 1: INSERT INTO {enabled_modules_system} (filename, name, description, package, version, core, project, datestamp, dependencies, dependents, php) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10); Array ( [:db_insert_placeholder_0] => sites/all/modules/service_links/services/general_services.module [:db_insert_placeholder_1] => General Services [:db_insert_placeholder_2] => Provide the Services: Blinklist, Box, del.icio.us, Digg, Diigo, Facebook, Furl, Google Bookmark, Google Buzz, Icerocket, Identi.ca, Linkedin, Mister Wong, Mixx, MySpace, Newsvine, Newskicks, Phing this, Reddit, StumbleUpon, Technorati, Technorati favorite, Twitter, Yahoo Bookmark [:db_insert_placeholder_3] => Service Links [:db_insert_placeholder_4] => 7.x-2.x-dev [:db_insert_placeholder_5] => 7.x [:db_insert_placeholder_6] => service_links [:db_insert_placeholder_7] => 1311122227 [:db_insert_placeholder_8] => a:1:{i:0;s:13:"service_links";} [:db_insert_placeholder_9] => N; [:db_insert_placeholder_10] => 5.2.4 ) in enabled_modules_system_info_alter() (line 232 of /home/hoslot5/public_html/sites/all/modules/enabled_modules/enabled_modules.module).

Comments

Starminder’s picture

Priority: Normal » Critical

Calling critical since it kind of kills the site.

juliangb’s picture

Is this definitely the latest version?

This was fixed in #1182362: description column not long enough.

Starminder’s picture

Just noticed beta2 is newer than the dev release, updated to that version but the problem persists:

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'description' at row 1: INSERT INTO {enabled_modules_system} (filename, name, description, package, version, core, project, datestamp, dependencies, dependents, php) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10); Array ( [:db_insert_placeholder_0] => sites/all/modules/service_links/services/general_services.module [:db_insert_placeholder_1] => General Services [:db_insert_placeholder_2] => Provide the Services: Blinklist, Box, del.icio.us, Digg, Diigo, Facebook, Furl, Google Bookmark, Google Buzz, Icerocket, Identi.ca, Linkedin, Mister Wong, Mixx, MySpace, Newsvine, Newskicks, Phing this, Reddit, StumbleUpon, Technorati, Technorati favorite, Twitter, Yahoo Bookmark [:db_insert_placeholder_3] => Service Links [:db_insert_placeholder_4] => 7.x-2.x-dev [:db_insert_placeholder_5] => 7.x [:db_insert_placeholder_6] => service_links [:db_insert_placeholder_7] => 1311122227 [:db_insert_placeholder_8] => a:1:{i:0;s:13:"service_links";} [:db_insert_placeholder_9] => N; [:db_insert_placeholder_10] => 5.2.4 ) in enabled_modules_system_info_alter() (line 232 of /home/hoslot5/public_html/sites/all/modules/enabled_modules/enabled_modules.module).

juliangb’s picture

Would you mind checking the length of the 'description' column in enabled_modules.install please?

It should be 1000, but older versions had 256.

Starminder’s picture

yep, 256 - will download again.

Starminder’s picture

Grabbed gz of dev version (Jun 12)

Is this the section?

'description' => array(
'description' => 'A description of the module',
'type' => 'varchar',
'size' => 'normal',
'default' => '',
'length' => '256',

Starminder’s picture

Sorry, found the right line and it is set to 1000, however, the problem remains.

),
'description' => array(
'description' => 'A description of the module',
'type' => 'text',
'size' => 'normal',
'length' => '1000',

juliangb’s picture

Sorry, I'm unclear on what the status is:

So you found that it was set to 256 in the version you were previously using, and then downloaded the later version and confirmed that was set to 1000?

Does the version that you have (same file) contain the function enabled_modules_update_7101()?

If so, run update.php and it should sort itself out. Another way is to disable and uninstall this module then re-enable. This will allow it to recreate the table in the larger size.

Starminder’s picture

unfortunately even trying to run update results in the same error. :/

juliangb’s picture

1) Recover the site from the error so that it is working again - if you can't do this via the site itself, update the row in the system table so that the status field = 0.

2) From the site, uninstall the module too so that we can start from a clean slate.

3) Ensure that the code that you have has the 1000 line in it.

4) Re-enable.

Starminder’s picture

1. Done.

2. Can't uninstall. The only way to "recover" the site is to delete the module. If the module is enabled OR if the folder is there, the errors occur. With the folder not there, it can't be uninstalled.

3. The current code I'm mucking with does in fact have 1000 in it.

4. Re-enabling results in the same error.

I can delete anything I need to from the database, will that work?

juliangb’s picture

It occurs to me, if you have the direct access to the database, you could just alter the table enabled_modules_system and increase the size to 1000.

Does that work?

I'm confused that you are still seeing an error after disabling the module.

Starminder’s picture

Great minds think alike, I had just done that in order to make the error go away so i could move on for now. In any case, yes - despite disabling the module the error persisted. It was only when i deleted the folder i could actually get anywhere.

Starminder’s picture

Status: Active » Closed (fixed)
nicodv’s picture

Don't know if Starminder is still here, but got the same problem, what was your solution again? delete the folder of the module in the cpanel?

hope you can help me

thanks

SamHilt’s picture

It's a bit old, but still ...

change 'version' column from table 'views_system' 32 chars to 256 chars direct in database/table. :)

Cheers,
Sam