Skip to main content
edited tags
Link
Adrian Cid Almaguer
  • 18.5k
  • 14
  • 79
  • 133
added 43 characters in body; edited title
Source Link
Pierre.Vriens
  • 36k
  • 40
  • 50
  • 182

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

I'm using feedFeeds to import nodenodes from otheranother system. This system uses very long number for its node id, like: 17675272378. As you can countsee 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?

LookHere are my captures:

enter image description here

enter image description here

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.

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?

Look my captures:

enter image description here

enter image description here

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

added 30 characters in body; edited tags
Source Link
avpaderno
  • 97.9k
  • 15
  • 164
  • 284

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.

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?

Look my captures:

enter image description hereenter image description here

enter image description hereenter image description here

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.

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?

Look my captures:

enter image description here

enter image description here

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.

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?

Look my captures:

enter image description here

enter image description here

Source Link
chefnelone
  • 6.3k
  • 16
  • 96
  • 184
Loading