kyller Posted December 15, 2007 Share Posted December 15, 2007 Hi all, I accidentally removed all root admins and changed all to normal admins. Now nobody (admin) can edit any admin. Please, i want to restore my profile to root admin! thanks! Link to comment https://www.neowin.net/forum/topic/607077-ipbno-root-admin-in-forum/ Share on other sites More sharing options...
0 ßéár Posted December 15, 2007 Share Posted December 15, 2007 do u have access to phpmyadmin Link to comment https://www.neowin.net/forum/topic/607077-ipbno-root-admin-in-forum/#findComment-589062279 Share on other sites More sharing options...
0 kyller Posted December 15, 2007 Author Share Posted December 15, 2007 yes i have Link to comment https://www.neowin.net/forum/topic/607077-ipbno-root-admin-in-forum/#findComment-589062284 Share on other sites More sharing options...
0 ßéár Posted December 15, 2007 Share Posted December 15, 2007 Go into Phpmyadmin then chose your IPB database the go to Ipf_members and change go to user user ID and change the group to 4 Link to comment https://www.neowin.net/forum/topic/607077-ipbno-root-admin-in-forum/#findComment-589062305 Share on other sites More sharing options...
0 kyller Posted December 15, 2007 Author Share Posted December 15, 2007 THANK YOU !!! Solved my problem flawlessly :wub: just for curiosity, is there a way to solve this problem in the IPB's Admin CP? Link to comment https://www.neowin.net/forum/topic/607077-ipbno-root-admin-in-forum/#findComment-589062312 Share on other sites More sharing options...
0 ßéár Posted December 15, 2007 Share Posted December 15, 2007 Not that I know of, There are tools you can get that allows you to do this but I like this way Link to comment https://www.neowin.net/forum/topic/607077-ipbno-root-admin-in-forum/#findComment-589062315 Share on other sites More sharing options...
0 kyller Posted December 15, 2007 Author Share Posted December 15, 2007 ahh :) understood ty again, +xDayan Link to comment https://www.neowin.net/forum/topic/607077-ipbno-root-admin-in-forum/#findComment-589062316 Share on other sites More sharing options...
0 sonrah Posted December 15, 2007 Share Posted December 15, 2007 THANK YOU !!! Solved my problem flawlessly :wub: just for curiosity, is there a way to solve this problem in the IPB's Admin CP? In order to do that, you'd need access to the SQL Toolbox in IPB's Admin CP. But in order to access the SQL Toolbox, you need to be root admin. Kind of a catch-22 there. Link to comment https://www.neowin.net/forum/topic/607077-ipbno-root-admin-in-forum/#findComment-589062319 Share on other sites More sharing options...
0 ßéár Posted December 15, 2007 Share Posted December 15, 2007 In order to do that, you'd need access to the SQL Toolbox in IPB's Admin CP. But in order to access the SQL Toolbox, you need to be root admin. Kind of a catch-22 there. :laugh: I forgot about the SQL toolbox but I never use it :| Link to comment https://www.neowin.net/forum/topic/607077-ipbno-root-admin-in-forum/#findComment-589062324 Share on other sites More sharing options...
0 kyller Posted January 3, 2008 Author Share Posted January 3, 2008 Interesting!!! Can we edit the database from it? What query, for example, i have to run (what i have to type) to change an user with id = 1000 from group 5 to group 6? Link to comment https://www.neowin.net/forum/topic/607077-ipbno-root-admin-in-forum/#findComment-589107901 Share on other sites More sharing options...
Question
kyller
Hi all,
I accidentally removed all root admins and changed all to normal admins. Now nobody (admin) can edit any admin.
Please, i want to restore my profile to root admin!
thanks!
Link to comment
https://www.neowin.net/forum/topic/607077-ipbno-root-admin-in-forum/Share on other sites
9 answers to this question
Recommended Posts