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.',
),
...
Comment | File | Size | Author |
---|---|---|---|
#2 | Data-too-long-for-column-'text_format'-2284775-2.patch | 1.88 KB | 6RUN0 |
Comments
Comment #1
6RUN0 CreditAttribution: 6RUN0 commentedComment #2
6RUN0 CreditAttribution: 6RUN0 commented