When using Devel to generate dummy content, i get this error. The field the error is reffering to is a text field as URL.

I have googled the error, seems a to big string is being set in the field.

#0 /var/www/vhosts/##.nl/httpdocs/tel/includes/database/database.inc(2135): PDOStatement->execute(Array)
#1 /var/www/vhosts/##.nl/httpdocs/tel/includes/database/database.inc(664): DatabaseStatementBase->execute(Array, Array)
#2 /var/www/vhosts/##.nl/httpdocs/tel/includes/database/mysql/query.inc(36): DatabaseConnection->query('INSERT INTO {fi...', Array, Array)
#3 /var/www/vhosts/##.nl/httpdocs/tel/modules/field/modules/field_sql_storage/field_sql_storage.module(448): InsertQuery_mysql->execute()
#4 [internal function]: field_sql_storage_field_storage_write('node', Object(stdClass), 'insert', Array)
#5 /var/www/vhosts/###.nl/httpdocs/tel/includes/module.inc(794): call_user_func_array('field_sql_stora...', Array)
#6 /var/www/vhosts/###.nl/httpdocs/tel/modules/field/field.attach.inc(928): module_invoke('field_sql_stora...', 'field_storage_w...', 'node', Object(stdClass), 'insert', Array)
#7 /var/www/vhosts/###.nl/httpdocs/tel/modules/node/node.module(1132): field_attach_insert('node', Object(stdClass))
#8 /var/www/vhosts/###.nl/httpdocs/tel/sites/all/modules/devel/devel_generate/devel_generate.inc(696): node_save(Object(stdClass))
#9 /var/www/vhosts/###.nl/httpdocs/tel/sites/all/modules/devel/devel_generate/devel_generate.inc(132): devel_generate_content_add_node(Array)
#10 /var/www/vhosts/###.nl/httpdocs/tel/sites/all/modules/devel/devel_generate/devel_generate.module(229): devel_generate_content(Array)
#11 /var/www/vhosts/###.nl/httpdocs/tel/includes/form.inc(1430): devel_generate_content_form_submit(Array, Array)
#12 /var/www/vhosts/###.nl/httpdocs/tel/includes/form.inc(844): form_execute_handlers('submit', Array, Array)
#13 /var/www/vhosts/###.nl/httpdocs/tel/includes/form.inc(364): drupal_process_form('devel_generate_...', Array, Array)
#14 /var/www/vhosts/###.nl/httpdocs/tel/includes/form.inc(123): drupal_build_form('devel_generate_...', Array)
#15 [internal function]: drupal_get_form('devel_generate_...')
#16 /var/www/vhosts/###.nl/httpdocs/tel/includes/menu.inc(503): call_user_func_array('drupal_get_form', Array)
#17 /var/www/vhosts/###.nl/httpdocs/tel/index.php(21): menu_execute_active_handler()
#18 {main}

$_REQUEST:
Array
(
    [node_types] => Array
        (
            [telefoon] => telefoon
        )

    [kill_content] => 1
    [num_nodes] => 10
    [time_range] => 604800
    [max_comments] => 0
    [title_length] => 4
    [add_alias] => 1
    [op] => Generate
    [form_build_id] => form--yNkCbNlIItD4p8uvWqn1b7UNJW5Vm9Jw8_5RqYWcCg
    [form_token] => HOmJQ0bhdQvS9RClOMBxOU5EU0bnwyOcfsldVv98SHE
    [form_id] => devel_generate_content_form
    [Drupal_toolbar_collapsed] => 1
    [Drupal_tableDrag_showWeight] => 0
    [locale] => en-US
    [SESS93db93c9d372086bb1b9d2f643d5480f] => 3d75DlXGGWIgl098xgvPrmlhg0DCdXyBp_7i1SczkoE
    [has_js] => 1
)


REQUEST_URI:
/tel/admin/config/development/generate/content

Comments

Michsk’s picture

Erorr starts with:

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'field_tel_website_value' at row 1. 
Michsk’s picture

I have the fields maximum length set to 255

ericduran’s picture

Interesting. I'll be looking into this. I'm curious if this is an html5_tools bug.

ericduran’s picture

Status: Active » Closed (cannot reproduce)

If no one else is able to replicate this I'm going to mark it close.