Can't view my users or settings!?!?!?????!!!

oojacoboo · 29.05.2004, 11:27

I am trying to view my users from the admin backend of my mambo site. However, I am only able to view the users that I registed from the user menu from the backend admin. You can see what I am talking about on the site..

http://www.macmod.com

Users is the menu tag. I don't know what to do, it recognises them as users just doesn't display their settings and I need to edit some of the peoples status from registered to author. I tried to do this from the sql tables but I don't think that it worked. Is there an intermediate file that is created for the mambo admin backend to read?

When I create my own users in the panel from the admin page everything works great, I can set the user type and everything. But its like mambo is having a hard time reading the information that is provided in the SQL tables or something. It isn't picking up anything there except for the number of users registered. Consequently, I can not allow users to upload news and images, which is the basis of my site. Please someone help me out here, I am thinking that I might have to reinstall the whole damn thing!! Not what I want to do!! My site is scheduled for its grand opening on june 5th. I have got to get this fixed asap.

Please let me know if you have any ideas. Thank you for taking your time to read this and any suggestions are very much appreciated

Regards,
Jacob

bollexe · 29.05.2004, 22:12

Hi there, I have exactly the same problem and as of yet have not worked out how to sort it out. Have you always had the problem on it from the first install or have you since then had to make a backup of the mambo tables and install it again? As that's what has made mine go wrong I think.

The only way I've been able to get around it so far is by loading up phpMyAdmin and manually editing the users there. Obviously I don't know how many users you have to edit but at least it will allow you to do something.

Load up php my admin and select the database you've used for MOS
Right at the bottom of the list of tables are the entries mos_users and mos_usertypes
Load up mos_usertypes first and click browse somewhere near the top
You will then be presented with the list of all the usertypes that your installation currently uses
Once you've noted down the names of the ones you want to use go to the mos_users table
Again click browse and you will see all the users currently registered to your site
Click the little pencil on paper icon next to each entry to load up the edit page.
Simply type in the desired usertype in the entry bos similarly titled
Once you've changed it to whichever one you want select go and you're done!

Hope that helps. If you need any help drop me a mail.

Benjy (Bollexe.com)

bollexe · 30.05.2004, 20:10

Hi there, I'm back to save you again. I have worked out how to get it to display the user details in the admin section for editing but it does take a little while. Good luck!

In pphmyadmin on the mos database go to the com_users table. Click browse. Note down the id (first collumn) of all the users currently on your system. Also write down the name they use (making note of caps).

Once you've done that go to the table "mos core acl aro". Click browse. Here is where to need to start inserting. Click the insert link towards the bottom of the page (insert new row).

You must input the following: aro id: 10 (usually starts at ten so if 10 is already displayed go up consecutively - 10,11,12 etc), section value: users, value - here is where you type in the id from the users table of each user, name: this is obviously the name of the user which the id pertains to.
Leave any other field as it is.

Once you've done all that select the radio button next to insert another field and click go.

You need to do this for every user on the system.
Once you've done the above for every user go to the table "mos core acl groups aro map". Click browse. Again you have some inserting to do.
This time you need to know the id's for user levels. By default they are:

registered - 18
author - 19
editor - 20
publisher - 21
manager - 22
administrator - 24
super admin - 25

Click insert new row again.

In the aro id field you need to type the same aro id's from mos core acl aro as i described above "10,11,12 etc". In the group id field you must put the user level id's i have listed for you above depending on what you want that user to be. Repeat this for all the users you have. You can set them all to the same user level then change it is the admin section of MOS (which will by then work!).

That's about it! You're user edit section in admin should now work. How do I know all this? As I have just had to do it myself!

oojacoboo · 31.05.2004, 09:34

Well I took another step just yesterday and installed a fresh install on another domain under the same host. Then I copied over all of the tables that were necessary and some of the edit php files in the folders. Everything worked flawlessly!!! So then I was glad, I backed up the entire SQL database at this point, then I dropped the tables from the main site and put the good ones in. I even took an additional step and moved a copy of the public_html folder over from the other site. Just to ensure. Well same ****ing ****! And at this point I am about to throw the computer out the window. Its not that big of a deal that I can't edit my users from the webfront backend except for the fact that I have to have each user that registers to be in the user group author instead of registered, and it doesn't fix this without doing what you say, and I can't do that for every newly registered user. There are already over 60 users and will be near god knows how many in a couple of days! I have got to have some sort of fix for this. I don't even see how this is possible for this to happen if I coppied the exact same things over from another site hosted on the same server, and it not work!!! Its really bothing me!!! Please if anyone knows the fix for this I really need to know!! Thanks for the info BTW.

-Jacob

oojacoboo · 31.05.2004, 13:31

Ok, disregard the need for further help, I just reinstalled the Mambo files and the code from the dummy site again. It all works now. The reason that it didn't work from the get go, is because the guy that I am working with on the site is a ignoramus. He backed up the wrong site's files, the one that is messed up now, then uploaded them back. Moron!!! I figured it out though this afternoon when I saw something there that I thought should be, so I backed up the dummy site and then uploaded that public_html folder to the site and perfect!!! All the users upon registration now appear in my add/edit users menu on the webfront backend. They are also now registered as authors so they can post news and pics with the nifty help that wikiwaka or whatever its called. Great to allow users to post stuff like computer mods for my site. They have to be approved by admin before publishing as well so A+. Thanks for the help!

poeniprinter · 23.06.2004, 17:00

Backup all your files and database first!!

I'm assuming that you have installed the latest patch. Then open the file: components - com_registration - registration.php

At line 215, add this piece of code:

PHP Code:

  // addon

    

mysql_connect("localhost", "dbuser", "dbpass");

mysql_select_db("database") or die(mysql_error());    

        

    $insert_acl_aro = "INSERT into mos_core_acl_aro (aro_id, section_value, order_value, name, hidden) VALUES ('','users','0','$name','0')";

    $query_acl_aro = mysql_query($insert_acl_aro);

 
    $select_uid = "SELECT id FROM mos_users WHERE name = '$name'";

    $query_uid = mysql_query($select_uid);

    $rowid = mysql_fetch_object($query_uid);

    $uid = $rowid->id;

    

    $update2_acl_aro = "UPDATE mos_core_acl_aro SET value = '$uid' WHERE name = '$name'";

    $query2_acl_aro = mysql_query($update2_acl_aro);    

    

    $select_aid = "SELECT aro_id FROM mos_core_acl_aro WHERE name = '$name'";

    $query_aid = mysql_query($select_aid);

    $rowaid = mysql_fetch_object($query_aid);

    $aid = $rowaid->aro_id;

    

    $insert_acl_groups_aro_map = "INSERT into mos_core_acl_groups_aro_map (group_id, aro_id) VALUES ('18','$aid')";

    $query_acl_groups_aro_map = mysql_query($insert_acl_groups_aro_map);    

    

    $delete_empty_entries = "DELETE FROM mos_core_acl_aro WHERE value = '0'";

    $query_delete_empty_entries = mysql_query($delete_empty_entries);

    

// addon

Now you are able to manage the users in the backend again, at least I am.

rickyvt · 30.07.2004, 16:00

I had the same problem with the users that logged in in my custom made online shop. They were added as registered users of my mambo site, but I couldn't edit or view them as administrator. Then I added your code into the shop registration and now every new shop registration is added to mos_core_acl_aro and is showing in the edit/delete users section. Thanks a lot!!!

ehsabbi · 14.06.2005, 05:22

Hi poeniprinter,

I´m running Mambo 4.5.2 and the line 215 doen´s seem to be a ggod place to paste your code:

212 if ($result) {
213 $database->setQuery( "UPDATE #__users SET block='0', activation='' 214WHERE activation='$activation' AND block='1'" );
215 if (!$database->query()) {
216 echo "SQL error" . $database->stderr(true);
217 }
218 echo _REG_ACTIVATE_COMPLETE;
219 } else {
220 echo _REG_ACTIVATE_NOT_FOUND;
221 }
222}

Should I paste it here anyway?
Txs.

bnjmilner · 27.10.2005, 18:48

I'm having the same problem. All my users that have registered on their own do NOT show up in the user manager. I've searched other sites some of which just say to search the forum as this is a frequent question. However, I STILL can't find the solution anywhere! The piece of code here indeed does not seem to be in the correct position at line 215. Where does it go? Can you display what should come before and after it?

I'm scared that this will be an ongoing problem that will require manual database correction to fix.