+- UserSpice (https://userspice.com/forums)
+-- Forum: Support Center (https://userspice.com/forums/forumdisplay.php?fid=23)
+--- Forum: UserSpice 4.3 and Below (https://userspice.com/forums/forumdisplay.php?fid=26)
+--- Thread: ID value in database (/showthread.php?tid=337)
ID value in database - pedrorgmarques - 11-04-2016
Hello,
First, amazing work done by UserSpice, it's a very good system and it really help me to go faster on my project.
My question is when i create a new user, should not the ID go from 1 to 2? https://snag.gy/32mah0.jpg
Hope u can help me, thanks!
Pedro Marques.
ID value in database - dan - 11-04-2016
It SHOULD but during testing, we create temporary users and sometimes the autoincrement accounts for that. I have to go back through and clean up the SQL every once in a while if we accidentally break that.
They will autoincrement from 22 to 23 and so on now. Sorry for the inconvenience. If it REALLY bothers you, could go in the database and fix it manually. I'll add it to the list to clean up for UserSpice 4.1.8c
ID value in database - pedrorgmarques - 11-04-2016
No problem, in this amazing work is just a detail
Manually u mean replace the number or change some setting?
ID value in database - dan - 11-04-2016
Well I know if you were to open the sql files that were in the install directory, there is a line on each of those things that tells where to start auto incrementing from. I THINK what you would have to do is go into phpmyadmin and change that user's id to 2. Then you click on the sql tab and type
ALTER TABLE
Code:
usersI think that will do it.
ID value in database - pedrorgmarques - 11-04-2016
Working now!!
Thanks for fast reply and for the help!
Keep the amazing work u have done!
ID value in database - dan - 11-04-2016
Awesome. Glad it's working and that you're enjoying the software. Let me know if you need any help.