Skip to main content
1 of 6
chefnelone
  • 6.3k
  • 16
  • 96
  • 184

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

I'm using feed to import node from other system. This system uses very long number for its node id, like: 17675272378. As you can count this number has 11 digits. The problem is that Drupal allows 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.

Mayby 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?

Look my captures:

enter image description here

enter image description here

chefnelone
  • 6.3k
  • 16
  • 96
  • 184