Skip to main content
6 of 6
edited tags
Adrian Cid Almaguer
  • 18.5k
  • 14
  • 79
  • 133

How to increase the value of the field nid in the node table in database?

I'm using Feeds to import nodes from another system. This system uses very long number for its node id, like: 17675272378. As you can see this number has 11 digits. The problem is that Drupal only allows a nid value up to 10 digits, then the import just fails.

I thought of changing the length value for nid for the node table directly in the database. But it is not that simple there are a lot of other tables which has this field like: the entity_id field for the field_data_body table.

Maybe I can get to change the values in the database if I export the table and then find and replace the value '10' for '15' and then after I replace the database which the new one. But my question is: will I get other problems if I do this?

How can I sort this out?

Here are my captures:

enter image description here

enter image description here

chefnelone
  • 6.3k
  • 16
  • 96
  • 184