Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
using Drupal 7.8, "update automatic nodetitles" action (on the admin/content page) gives error:
PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'entity_id' for column 'delta' at row 2: INSERT INTO {field_data_field_relations} (entity_type, entity_id, revision_id, bundle, delta, language) 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, :db_insert_placeholder_11); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 143 [:db_insert_placeholder_2] => 143 [:db_insert_placeholder_3] => note [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => node [:db_insert_placeholder_7] => 143 [:db_insert_placeholder_8] => 143 [:db_insert_placeholder_9] => note [:db_insert_placeholder_10] => entity_id [:db_insert_placeholder_11] => und ) in field_sql_storage_field_storage_write() (line 424 of /home/myoffice/public_html/modules/field/modules/field_sql_storage/field_sql_storage.module)
Comments
Comment #1
chertzogIm experiencing the same thing using drupal 7.13 dev.
I then tried auto entity titles, and that had the same problem.
Edit: After trying it on a webserver, i have no problem. But locally on MAMP pro, it breaks..... who knows
Comment #2
amitgoyal CreditAttribution: amitgoyal commentedI have tested this in Drupal 7.8 with both the versions (7.x-1.0 and 7.x-1.x-dev) of Automatic Nodetitles module. It looks like this problem is not with Automatic Nodetitles.
Can you please provide more information to reproduce this issue?
Comment #3
chertzogI found that it wasnt this module that was causing the problems, it was token. My set up had quite a few reference fields which caused HUGE token trees due to some of the recursions aspects of token.
I fixed this by using the Token Tweaks module. It allows you to limit the number of levels in token trees. This prevents the recursion issues.