Hello.

How can I reset the NID's counter (using phpMyAdmin)? Drupal 6.
Please!

Comments

ayesh’s picture

By default, when you create a new content, NID is last NID+1. This is to avoid conflicts.

You have to delete all nodes after the NID that you want to start over.
If you want to increase the NID manually, simply modify the NID field of node raw in NODE table.

stolzenhain’s picture

Hello! As added information: This technique didn't work for me on Drupal 6 (removing the content and then adapting the databse on the first node that was added did, though).

ayesh’s picture

Try to run this query in phpmyadmin:
ALTER TABLE node AUTO_ INCREMENT = 1;