Hey there everyone, I tried searching around and I did not find this, so I apologize if this has already been posted, but basically after merging from phpbb3 to mybb I noticed that all of my users are defaulted to be hidden/ invisible. Is there code I can use or is there some way to fix this? Maybe there is a way to disable allowing users to go invisible to fix this or something? Any help is appreciated.
I also posted a few other issues in this other thread here:
http://community.mybb.com/thread-117056.html
Thank you.
Run this SQL query:
UPDATE mybb_users SET invisible='0' WHERE invisible='1'
Thanks Paul, but I am a bit of a novice in this area. How do I run the SQL query? Is there something in the ACP? Do I just make a php file and stick it in the main directory of mybb and target my browser to the the file? I am a bit confused.
edit:
I think I found it. I need to go into my db and edit it?
http://community.mybb.com/thread-44380.html
You have to run it in a third party software such as phpmyadmin. This is usually provided by your webhost. You should be able to find it in your host's control panel.
Thanks Nathan, I'm looking at phpmyadmin and I am not too sure where to submit it.
http://i188.photobucket.com/albums/z265/...sehelp.jpg
Is that right in the pic above? I hit submit, but it still shows some of the users as invisible. Do, I need to run anything else in the acp or something? Thank you.
edit:
It says this after I hit submit in the text box:
Quote:You have to choose at least one column to display
edit:
Ah, I figured it out and the code worked! Thank you. Basically, I had to go to the SQL tab not the Query tab. As a new person to SQL that was confusing hehe.
The Query tab is a query builder, you want to use the SQL tab.
As soon as that's done, all users should now be visible.
(2012-04-30, 03:31 PM)Nathan Malcolm Wrote: [ -> ]The Query tab is a query builder, you want to use the SQL tab. As soon as that's done, all users should now be visible.
Yeah, sorry about that, I am new at this hehe. The code provided worked very well. Thanks again!
