1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

All My Members Are Admins - Help!!

Discussion in 'Forum Management' started by delrivo, Sep 27, 2007.

0
  1. #1
    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
     
    delrivo, Sep 27, 2007 IP
  2. terminator69

    terminator69 Notable Member

    Messages:
    4,872
    Likes Received:
    260
    Best Answers:
    0
    Trophy Points:
    230
    #2
    That sounds pretty bad, usually if you post in general support their replies are quite fast.
     
    terminator69, Sep 27, 2007 IP
  3. Cheap SEO Services

    Cheap SEO Services <------DoFollow Backlinks

    Messages:
    16,664
    Likes Received:
    1,318
    Best Answers:
    0
    Trophy Points:
    0
    #3
    You better act quick before the others latch on and boot you out.
     
    Cheap SEO Services, Sep 27, 2007 IP
  4. lbalance

    lbalance Peon

    Messages:
    381
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    0
    #4
    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
     
    lbalance, Sep 27, 2007 IP
  5. delrivo

    delrivo Guest

    Messages:
    663
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #5
    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.
     
    delrivo, Sep 28, 2007 IP
  6. GoodOmens

    GoodOmens Peon

    Messages:
    73
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #6
    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!
     
    GoodOmens, Sep 28, 2007 IP
  7. Floridaballa01

    Floridaballa01 Banned

    Messages:
    107
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    lol.. dang!!
     
    Floridaballa01, Sep 29, 2007 IP
  8. lezi_guy

    lezi_guy Well-Known Member

    Messages:
    1,255
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    150
    #8
    LOL,good you didnt make this mess on main board ..

    Good Luck
     
    lezi_guy, Sep 29, 2007 IP
  9. delrivo

    delrivo Guest

    Messages:
    663
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Could anyone please tell me how to do this?
     
    delrivo, Oct 1, 2007 IP
  10. ShiftChip

    ShiftChip Well-Known Member

    Messages:
    365
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    110
    #10
    Use mysql update.... example:
    UPDATE Table SET ID_GROUP = 1 WHERE ID_GROUP = 2;
     
    ShiftChip, Oct 1, 2007 IP
  11. delrivo

    delrivo Guest

    Messages:
    663
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #11
    Ok il try it.

    Thank you.
     
    delrivo, Oct 1, 2007 IP
  12. delrivo

    delrivo Guest

    Messages:
    663
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #12
    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
     
    delrivo, Oct 1, 2007 IP
  13. lbalance

    lbalance Peon

    Messages:
    381
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    0
    #13
    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;
     
    lbalance, Oct 1, 2007 IP
  14. sawz

    sawz Prominent Member

    Messages:
    8,225
    Likes Received:
    808
    Best Answers:
    0
    Trophy Points:
    360
    #14
    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.
     
    sawz, Oct 2, 2007 IP
    delrivo likes this.
  15. lbalance

    lbalance Peon

    Messages:
    381
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    0
    #15
    i mentioned that in my first post
     
    lbalance, Oct 2, 2007 IP
    sawz likes this.
  16. delrivo

    delrivo Guest

    Messages:
    663
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #16
    Thank you everyone for your help.

    Finaly got it sorted and i didnt have to mess with the db at all.
     
    delrivo, Oct 2, 2007 IP
    sawz likes this.