System:

$ php --version
PHP 5.5.13-pl0-gentoo (cli) (built: Jun  5 2014 17:38:25) 
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend Technologies
    with Zend OPcache v7.0.4-dev, Copyright (c) 1999-2014, by Zend Technologies
    with Xdebug v2.2.3, Copyright (c) 2002-2013, by Derick Rethans
$ mysql --version
mysql  Ver 15.1 Distrib 5.5.37-MariaDB, for Linux (x86_64) using readline 6.3

Error message:
PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'text_format' at row 1: INSERT INTO {phpbb2drupal_instances} (machine_name, name, db, text_format, files_domain, files_directory, settings) 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); Array ( [:db_insert_placeholder_0] => phpbb_example_forum [:db_insert_placeholder_1] => phpbb example forum [:db_insert_placeholder_2] => a:6:{s:6:"prefix";s:8:"phpbbzm_";s:5:"local";i:1;s:6:"driver";s:5:"mysql";s:4:"host";s:9:"localhost";s:8:"database";s:8:"example_dev";s:8:"username";s:8:"example_dev";} [:db_insert_placeholder_3] => bbcode_eve_igb_links [:db_insert_placeholder_4] => http://example.dev/forum/ [:db_insert_placeholder_5] => old-images [:db_insert_placeholder_6] => a:5:{s:22:"email_collision_option";s:1:"1";s:25:"username_collision_option";s:1:"1";s:19:"deleted_user_option";s:1:"3";s:20:"admin_migrate_option";s:1:"1";s:18:"admin_role_migrate";i:0;} ) в функции drupal_write_record() (строка 7207 в файле /home/www/drupal/example.dev/public_html/includes/common.inc).

Why the size of the column "text_format" is equal 16?

See modules/filter/filter.install:

function filter_schema() {
  $schema['filter'] = array(
   ...
      'name' => array(
        'type' => 'varchar',
        'length' => 32,
        'not null' => TRUE,
        'default' => '',
        'description' => 'Name of the filter being referenced.',
      ),

   ...
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

6RUN0’s picture

Issue summary: View changes
6RUN0’s picture

Status: Active » Reviewed & tested by the community
FileSize
1.88 KB