Juice Compent for Joonla CMS - problem

Discussion in 'Content Management' started by cdx, May 14, 2006.

0
  1. #1
    Hello all...

    I imported 4000 users to joomla DB. I have now 4000 users that I need to enable them! The only way I see that I can enable them is by going one-by-one and pressing the ENABLE buttom!

    Is there any other way to enable ALL the users after I have imported them into Joomla ?

    Thanks in advance!

    Guy.
     
    cdx, May 14, 2006 IP
  2. tyrithe

    tyrithe Member

    Messages:
    97
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    43
    #2
    Maybe you can look into doing an SQL update command to change the status, but I'm not sure about that one. Having to manually do it sounds like a lot of work.
     
    tyrithe, May 14, 2006 IP
  3. cdx

    cdx Peon

    Messages:
    364
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I found something ...

    There is an option for disabeling the need for approval from admins.

    Now the problem is that it doesn't approve everytime I am importing users... It did just in the first import.....

    Strange, don't you think so?
     
    cdx, May 14, 2006 IP
  4. natsirtm

    natsirtm Active Member

    Messages:
    114
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    55
    #4
    definitely just do a sql update.

    UPDATE #__users
    SET block = 0;

    replace #__ with your prefix (eg. jos_)
     
    natsirtm, May 14, 2006 IP