XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. XOOPS general usage questions 
  4.  / database help - user uid
Register
1
noo-b
database help - user uid

  • 2007/12/26 12:19

  • noo-b

  • Just can't stay away

  • Posts: 456

  • Since: 2007/10/23


i have a site that i test at localhost and not yet uploaded to a server

in the localhost site i've registered a couple of new user to test my groups settings

before i want to upload this site to a server i deleted all other user account (3 accounts) uid=2-uid=3-uid=4
and i left 1 account that is my account admin (uid=1)


my problem is that i want the next user that register to have uid=2 then 3,4,5,6 and so on

right now when i registered the uid of a newsuser is uid=5

how can i reset the database ?

thank you
I Love Xoops
2
wizanda
Re: database help - user uid

  • 2007/12/26 12:32

  • wizanda

  • Home away from home

  • Posts: 1585

  • Since: 2004/3/21


Change the Auto-increment value in MySql.....
Normally i just export the current table....change the auto-increment value at the top and then import it back into the database...
Yet if you are on the home server, when you install XOOPS on the live site it will do the same anyway....
3
noo-b
Re: database help - user uid

  • 2007/12/26 12:53

  • noo-b

  • Just can't stay away

  • Posts: 456

  • Since: 2007/10/23


Quote:
Change the Auto-increment value in MySql....[]


i'm a noo-b how do i do this in phpmyadmin..which table ?
I Love Xoops
4
wizanda
Re: database help - user uid

  • 2007/12/26 14:19

  • wizanda

  • Home away from home

  • Posts: 1585

  • Since: 2004/3/21


users
5
noo-b
Re: database help - user uid

  • 2007/12/26 14:49

  • noo-b

  • Just can't stay away

  • Posts: 456

  • Since: 2007/10/23


thank you wizanda

After i did the change, i tried to register a user, after clicking the finish button i received the message
"cannot register new user"


i'm using 2.0171
I Love Xoops
6
iHackCode
Re: database help - user uid

in phpmyadmin. do a

ALTER TABLE `prefix_users` AUTO_INCREMENT = 2

to set the auto_increment to start at 2
CBB / LatestNews / Publisher / XM-Spotlight

(ﾉ◕ヮ◕)ﾉ*:･ﾟ✧
7
noo-b
Re: database help - user uid

  • 2007/12/27 3:19

  • noo-b

  • Just can't stay away

  • Posts: 456

  • Since: 2007/10/23


thank you bandit ..that does the trick


i 've another question though

it is ok if i change the uid of a user in phpmyadmin

as example from 3 to 5

will it cause problem ?
I Love Xoops
8
iHackCode
Re: database help - user uid

i haven't changed the id's around before so I'm not sure what would happen .
CBB / LatestNews / Publisher / XM-Spotlight

(ﾉ◕ヮ◕)ﾉ*:･ﾟ✧

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

117 user(s) are online (74 user(s) are browsing Support Forums)

Members: 0

Guests: 117

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits