Restarting Memberships from #1

Discussion in 'Troubleshooting' started by starlightcountry, Nov 8, 2007.

  1. starlightcountry

    starlightcountry New Member

    Joined:
    Oct 28, 2007
    Messages:
    2
    Hi.

    After extensive testing we have reached #46 in memberships, how do we reset the number to "1"?

    We have deleted all memberships raised during testing, do not want to create another membership to check the member number so your help / advice would be appreciated.

    Thanks

    Mike.
    starlightcountry, Nov 8, 2007
    #1
  2. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    You can use this query in phpMyAdmin on aMember's database:
    ALTER TABLE `amember_products` AUTO_INCREMENT =1
    alexander, Nov 9, 2007
    #2

Share This Page