HI,
I migrated a forum from other drupal installation. I appended the following tables using SQL Scripts

forum
node
node access
node revisions
term date
term hierarchy
term node
node comment statistics

When I try to create new posts the node number is created in such a way that it overwrites the forum topics with the same number.

Is there a way to change the base number for auto increment so the new nodes created do not overwrite the previous ones (the ones appended to the database)

Comments

modul’s picture

modul commented

In your MySQL database, there is a table called (prefix_)Sequences, which contains the id numbers which will be given to new items (nodes, menu items, forms etc.). Most likely, you added your forum texts without telling this table that new content had been added. I would think that changing the node number (and term number?) in this table would take care of your problem.

But DO make a safety copy of that table before meddling with it. It is quite essential in Drupal's inner workings...

nedjo’s picture

nedjo
he/him/his
Primary language English
commented
Status: Active » Closed (fixed)

Not relevant to this project, and answered, so closing.

charlespaul’s picture

charlespaul commented

I have the same problem. I restored the database but if I add a new node, it is over riding some primary key. I think the code is cacheing the node ID auto increment some where in the code. Can any one help.