All My Members Are Admins - Help!!

Hi

I have just converted my phpnuke site to smf and everything has gone perfectly using the converter except all my members are now admins, and i am NOT!!

Is there some kind of quick fix i could use by going into the mysql databases.

I have asked on the smf forum but not had a reply in 3 days so posting here now.

Also if anyone knows any other way of fixing this any help is much appreciated.

Ben Jones

 

That sounds pretty bad, usually if you post in general support their replies are quite fast.

 

You better act quick before the others latch on and boot you out.

 

first, put your forum in maitanence mode

then, go to phpMyAdmin and go to smf_members

everyone is probably set as ID_GROUP=1, so run a SQL statement to make everyone a 2 and change yours back to 1

 

Thank you for all your replies.

Its actualy only on a test forum and not on my main site yet, still trying to figure it out.

Il take a look at that now ibalance.

 

I'm sorry for not adding anything constructive ... maybe it's the beer ... but this thread gave me a good chuckle.

Hope you fix the issue!

 

lol.. dang!!

 

LOL,good you didnt make this mess on main board ..

Good Luck

 

Could anyone please tell me how to do this?

 

Use mysql update.... example:
UPDATE Table SET ID_GROUP = 1 WHERE ID_GROUP = 2;

 

Ok il try it.

Thank you.

 

Still cant do it.

Tried everything i ca think of.

Can somebody please explain to me in detail how i can get it sorted.

Thank you.
Ben Jones

 

if you have cPanel, go to phpMyAdmin.
when it loads, go to the SMF forum database.
click on SQL.

then paste this into the textbox:
UPDATE smf_members SET ID_GROUP = 2 WHERE ID_GROUP = 1;

 

that changes everyone back to a regular member. the OP still has to regain admin control. go to smf_members and click browse, find yourself and change your member group to 1, then click go.

 

i mentioned that in my first post

 

Thank you everyone for your help.

Finaly got it sorted and i didnt have to mess with the db at all.