Reset the ID assigned to a registrant for an event to 1

  • Al Khamsa, Inc.
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
2 years 7 months ago #153668 by Al Khamsa, Inc.
Currently I have 1 Category and 1 Event within that category.  I did testing, deleted the registrant records and now I want to open live registration.  The problem is the ID assigned the first registrant's record is 15.  I would like to be able to restart the ID field assigned a registrant for an event back to 1.

How can I make that happen?

Please Log in or Create an account to join the conversation.

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
2 years 7 months ago #153669 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Reset the ID assigned to a registrant for an event to 1
Hello

Need to run an SQL command via PHPMYADMIN to your database have it works like that. The command is:

TRUNCATE TABLE #__eb_registrants ;

(Replace #__eb_registrants with the right table name - depends on the table prefix use on your site)

If you don't know how to do that, submit a support ticket sending us super admin account of your site and we will be happy to help

Tuan

Replace

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc