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
Comment #1
Starminder commentedCalling critical since it kind of kills the site.
Comment #2
juliangb commentedIs this definitely the latest version?
This was fixed in #1182362: description column not long enough.
Comment #3
Starminder commentedJust 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).
Comment #4
juliangb commentedWould you mind checking the length of the 'description' column in enabled_modules.install please?
It should be 1000, but older versions had 256.
Comment #5
Starminder commentedyep, 256 - will download again.
Comment #6
Starminder commentedGrabbed 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',
Comment #7
Starminder commentedSorry, 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',
Comment #8
juliangb commentedSorry, 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.
Comment #9
Starminder commentedunfortunately even trying to run update results in the same error. :/
Comment #10
juliangb commented1) 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.
Comment #11
Starminder commented1. 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?
Comment #12
juliangb commentedIt 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.
Comment #13
Starminder commentedGreat 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.
Comment #14
Starminder commentedComment #15
nicodv commentedDon'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
Comment #16
SamHilt commentedIt's a bit old, but still ...
change 'version' column from table 'views_system' 32 chars to 256 chars direct in database/table. :)
Cheers,
Sam