System0
Active member
I tried out the xensso single login premium add on. It's a fantastic add on and the support was fantastic. Unfortunately, it doesn't currently work exactly as I would like. As such, I had to delete the 300+ members that were imported to my new forum.
The downside to this is that the user ids of some users are too high, even though my new forum only has about 20 members or so (t the latest member has an id in the hundreds). I realise that the user id is used in a lot of tables so you can't simply change it. Also, auto increment means that new users will be set in the hundreds so all future members will be affected by this.
Perhaps this is irrelevant but I'd like to correct it. What's the quickest way to resolve this?
At the moment the user ids are:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
20
21
22
23
24
26
27
28
31
361
372
Is it possible to change the database directly and reorganise the ids in order so that they go from 1 to 29?
Would exporting the users and content and importing them back in resolve this?
Kevin
The downside to this is that the user ids of some users are too high, even though my new forum only has about 20 members or so (t the latest member has an id in the hundreds). I realise that the user id is used in a lot of tables so you can't simply change it. Also, auto increment means that new users will be set in the hundreds so all future members will be affected by this.
Perhaps this is irrelevant but I'd like to correct it. What's the quickest way to resolve this?
At the moment the user ids are:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
20
21
22
23
24
26
27
28
31
361
372
Is it possible to change the database directly and reorganise the ids in order so that they go from 1 to 29?
Would exporting the users and content and importing them back in resolve this?
Kevin