- last update
10 months ago 2,184 pass - 🇭🇺Hungary danyg Budapest
Here is the updated patch which is compatible with the latest, 7.101 Drupal version.
There is some a problem when exporting a complex components using Features (e.g. long Entity form with fields which results in 1000 lines) which causing PDOException that the data is too long in system table.
The workaround is to do:
ALTER TABLE `system` CHANGE `info` `info` LONGBLOB /* or MEDIUMBLOB */ NULL DEFAULT NULL
as shown in here:
-
#2056263: Branch 2.x results in large info files that exceed the 'info' column limit in the 'system' table →
,
-
#1911022: Exception: PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'info' at row 1 →
.
Is there any consideration to increase the size of `info` in Drupal core to MEDIUMBLOB?
--
Example PDOException when there is module present with a large .info file, so this happens on system_rebuild_module_data():
Starting Drupal installation. This takes a while. Consider using the [ok]
--notify global option.
exception 'PDOException' with message 'SQLSTATE[22001]: String data, [error]
right truncated: 1406 Data too long for column 'info' at row 167' in
/vagrant/build/docroot/includes/database/database.inc:2171
Stack trace:
#0 /vagrant/build/docroot/includes/database/database.inc(2171):
PDOStatement->execute(Array)
#1 /vagrant/build/docroot/includes/database/database.inc(683):
DatabaseStatementBase->execute(Array, Array)
#2 /vagrant/build/docroot/includes/database/mysql/query.inc(36):
DatabaseConnection->query('INSERT INTO {sy...', Array, Array)
#3 /vagrant/build/docroot/modules/system/system.module(2314):
InsertQuery_mysql->execute()
#4 /vagrant/build/docroot/modules/system/system.module(2467):
system_update_files_database(Array, 'module')
#5 /vagrant/build/docroot/includes/install.inc(747):
system_rebuild_module_data()
#6 /vagrant/build/docroot/includes/install.core.inc(787):
drupal_install_system()
#7 /vagrant/build/docroot/includes/install.core.inc(471):
install_system_module(Array)
#8 /vagrant/build/docroot/includes/install.core.inc(339):
install_run_task(Array, Array)
#9 /vagrant/build/docroot/includes/install.core.inc(77):
install_run_tasks(Array)
#10 /usr/local/share/drush/includes/drush.inc(725):
install_drupal(Array)
#11 /usr/local/share/drush/includes/drush.inc(711):
drush_call_user_func_array('install_drupal', Array)
#12
/usr/local/share/drush/commands/core/drupal/site_install_7.inc(82):
drush_op('install_drupal', Array)
#13 /usr/local/share/drush/commands/core/site_install.drush.inc(247):
drush_core_site_install_version('foo_profile', Array)
#14 [internal function]: drush_core_site_install('foo_profile',
'install_configu...')
#15 /usr/local/share/drush/includes/command.inc(366):
call_user_func_array('drush_core_site...', Array)
#16 /usr/local/share/drush/includes/command.inc(217):
_drush_invoke_hooks(Array, Array)
#17 [internal function]: drush_command('foo_profile',
'install_configu...')
#18 /usr/local/share/drush/includes/command.inc(185):
call_user_func_array('drush_command', Array)
#19 /usr/local/share/drush/lib/Drush/Boot/BaseBoot.php(67):
drush_dispatch(Array)
#20 /usr/local/share/drush/includes/preflight.inc(66):
Drush\Boot\BaseBoot->bootstrap_and_dispatch()
#21 /usr/local/share/drush/drush.php(12): drush_main()
#22 {main}
Command dispatch complete [notice]
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Here is the updated patch which is compatible with the latest, 7.101 Drupal version.