How to reset the serial field (serial) counter?

It appears that a table is generated for each node type and field. Mine is serial_readingevent_field_eventno. At a glance, it appears that the sid is the next one in line. Oddly, an entry appears to be made only when this module is invoked: It seems that serial id only increases if I don't set the title manually (wherein I have a token referring to this serial field, using the autotitle module).

Anyhow, I'd like to hear how to set or reset the Serial Token counter too. If I learn something, I'll post back here.

I haven't tried this yet, but I suspect that if you truncate the table for a given serial field (which would also likely set each node's serial id field to empty and set it up to be a new serial id on next edit of this node! (I would think)) and reset its sid field autoincrement value to 0, that your next New Node would be sid 1, or your next edit and save of an existing node with the same serial id would be 1.

It's a theory, and I didn't review the code-- just what it looks like might happen based on the table data.

-Bronius

A couple findings:
Deleting all records in the serial table for this field and resetting auto_increment did not affect existing nodes (which kept the original serial id field values but gave me serial id value of 1 on new node creation.

So, armed with this knowledge, I manually adjusted the sid in the table (with only the new node in it now) to the desired value considering all other nodes of this content type already in the system and ran
alter table serial_readingevent_field_eventno auto_increment = 1
to set the next sid to be created back to last sid + 1.

I don't know what will happen when I hit an sid == one of the already existing "incorrect" sid values in their serial id field. Maybe I'm in for a world of hurt. Good luck -- please report back if you learn a better way to reset or set or tamper with serial id.

Subscribe.

subscribe

SOLUTION

I just remove the serial field in my contenttype -> save the contenttype -> added the serial field again -> save the contenttype -> just wait, so that the module can execute -> done

Increase the PHP Execution time

Add to the .htacces file :

php_value max_execution_time 200

200 is the time in seconds

check some example: www.geografica.be

I'm migrating data from a MySQL database with an autoincrement field. Can I simply import the numbers already in the db into a Serial field in Drupal and have autoincrement start from the largest number?

emk

Please open a new issue instead of hijacking an existing, documented, and resolved one.