Admin Profiles (for v1.3.x only!) Support Thread

Ok - I have had to move a cart with admin profiles to another server location for the second time in a week...don't ask.

The first time I moved it I had to reset my Admin as it would not let me into my admin with my old password. Then I couldn't see the menu nav bar and found out via this thread that I had to rerun the sql with the user id number. That worked.

Now I have move it again making clear note of my two user ids
2 - had limited access
3 - had full access
(1 had been lost when I reset the Admin in the first move)

So I ran the sql via the MyPhpAdmin and changed the admin_id = 1 to 3.

I can sign in and see menu bars
It doesn't allow me into the admin settings or anything else.

Ok so I decide to try 2 cuz I can always change it.

I can sign in and see menu bars
It doesn't allow me into the admin settings or the limited areas where it was allowed before.

So I deleted all the files added when I added admin profiles and loaded back the original zen cart files. Then I acted as though I was loading admin profiles for the first time. Still no luck!

I am using Admin Profiles v1.0.7 Zen Cart 1.3.8a
Fual Slimbox
IH2
Edit Orders
Categories Dressing
Cherry_Zen
EZ Populate

Can anyone help me with this. I am fairly good at following instructions and had access to MyPhpAdmin and can change any coding if given file path and coding information.

Lesson learned - do NOT add Admin Profiles until the site is at it's final destination!!!

TIA
Mona

btw - I love this mod and use it on two other sites.....that I have never had to move LOL

stxmona:

Lesson learned - do NOT add Admin Profiles until the site is at it's final destination!!!Quite the opposite. I've moved many sites with Admin Profiles in place. Provided the files and database tables are moved intact as part of the overall site, they're independent of where they're located and this is much the safest way to make the move.

I suspect that there's a clue in your inability to log in to the Admin after the first move. That suggests that there was something not quote right back there, but it's not possible from your description to work out what.

I would though recommend upgrading to version 1.0.7.1. There are no database changes needed, just one changed file. Again I can't tell form your description whether it will help, but it certainly won't do any harm.

I would though recommend upgrading to version 1.0.7.1. There are no database changes needed, just one changed file. Again I can't tell form your description whether it will help, but it certainly won't do any harm.

Ok - will try that very willingly. If it doesn't work.....I will post again and maybe you could help me from there.

Thanks
Mona

Hi All,

ZC- 1.3.8a (patched)
AProfiles - 1.0.7.1

My Admin Profiles has been working great. I suspect what i'm seeing is simply "normal" behaviour but i want to ask to see if there's a better solution than what i'm guessing is the answer:

3rd party mods show up in Admin Settings and their visibility and access is enabled or disabled via check boxes. However, when removing no-longer-used 3rd party mods, their associative option checkboxes boxes remain within Admin Settings / Permissions, even though all files and database tables created for that mod have been removed.

Is there (or should there be) a proper way to remove these Admin Profiles Permissions settings when a mod no longer exists ...other than having to use phpMyAdmin or similar tool to manually remove the entries that Admin Profiles uses?

Thanks.

@stride-r

Your assessment is absolutely correct. This is a bit tricky for the current version of Zen Cart where mods add code to the file system but Admin Profiles operates from database tables.

It would be possible to perform some reconciliation between the file set and the database to find mods that had been removed, though even then, there's no guarantee that any configuration key groups have been removed.

This will hopefully be much easier to deal with in Zen Cart 2.0 for which a formal plugin system has been announced. I anticipate that this will give Admin Profiles more robust information and a formal installation process into which it may be able to hook.

Is there anywhere I can see a demo of this contribution? I want to make sure it's right for my site.

high2K:

Is there anywhere I can see a demo of this contribution? I want to make sure it's right for my site.None that I know of. I recommend evaluating it on a test installation. Indeed, I recommend that for all mods before installing on a live site. :wink:

I am having a problem logging in to my admin side. I added this add-on a while ago and it was working. I dont think I have added anything to the site since this add-on. I went to go log in to process an order and it wouldnt let me log in with any passwords and would not let me email my password to me either.

I did this:
DELETE FROM admin WHERE admin_name = 'Admin'; INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level) VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

and I can now log in but it says
"Sorry, your security clearance does not allow you to access this resource.
Please contact your site administrator if you believe this to be incorrect.
Sorry for any inconvenience."

So I changed the admin user ID to 1 and it still says that security clearance error whenever I try to access anything on the admin menu. I checked to see if upgrading my admin profiles version would help but after reading the upgrade instructions I think that I already have the newest version (I have since changed computers and dont know which version I initially installed).

If anyone could help me out with this I would really appreciate it!

Can we add admin user later. I mean if we install admin profiles and later we added a new user and want give privilege, can we do it ?

Forget the above message. I was not fully understand. Sorry guys

Hi,

I haven't been able to find the answer to this so hopefully someone can help. I am running Zencart 1.3.8a and have admin profiles up and running. Everything is working so far apart from when I click on the restrictions tab of the Coupon Admin function. I then get access denied. I don't have super orders installed, the only mods I have done are the Zone files for ebay, image handler. If I create a new coupon, I can add restrictions then no problem, just can't change them afterwards.

What do I need to do?

Thanks in advance,

Keith

Not sure I can explain the why part ...but in my experience, whenever I run into this sort of issue with this Mod, it can usually be fixed by revisitiing the Admin Settings.

Since you used the "update restrictions form" and got an error message, now go to Admin > Admin Settings > Permissions . You will likely now see an entry for the "coupon restrict" form in the list of available Third Party Mods. It probably wasn't visible there earlier when you initially set your perms ...but attempting to access seems to trigger it to be added to the list. You should now be able to give yourself permissions to use it.

stride-r:

Not sure I can explain the why part ...but in my experience, whenever I run into this sort of issue with this Mod, it can usually be fixed by revisitiing the Admin Settings.

Since you used the "update restrictions form" and got an error message, now go to Admin > Admin Settings > Permissions . You will likely now see an entry for the "coupon restrict" form in the list of available Third Party Mods. It probably wasn't visible there earlier when you initially set your perms ...but attempting to access seems to trigger it to be added to the list. You should now be able to give yourself permissions to use it.

Thanks for the info, you are right and this now works.

Hi im a new to the zen cart Ive got the admin profiles module wokring however one thing I just cant find the answer to? How does the second admin user chnage their password? I can give them the admin privaleges but this second user is then able to also chnage the primary admin's password as well? any solutions?

johnny_99:

How does the second admin user chnage their password? I can give them the admin privaleges but this second user is then able to also chnage the primary admin's password as well? any solutions?

The Primary Admin (you?) assigns a password and privaleges for each user ...why would you want the users to then be able to change their own privaleges? Do not give them access to the Admin settings. If they need to have their password changed, that is a job for the Primary Admin (you?).

If they forget their password, then they can retrieve it at the regular Admin login screen.

I'm using Zen Cart 1.3.8a
I'm using admin profiles v1.0.7.1

I just installed the addon. I've installed install sql patch, uploaded the admin files. First I got errors that zen_admin_files did not exist. I found that I had to rename admin_files, admin_menu_header, admin_visible_headers, and admin_allowed_pages by adding the zen_ prefix to the names.

I can now operate the admin pages OK but I don't get the permissions icon on the admin listing. They just show up as they did before I installed the add on.

I've successfully done this on other installs that I have but I can't seem to get it to work on this one.

Thanks in advance.
Steve

Any help would be appreciated please.
Steve

Hello, I just installed admin profiles v1.071 but have a problem.
During install you have to make table with this code:
CREATE TABLE admin_visible_headers (
header_id int(11) NOT NULL default '0',
admin_id int(11) NOT NULL default '0'
) TYPE=MyISAM;

This code execute OK. But later you use this code:

INSERT INTO admin_visible_headers VALUES (1, @superuser);

This code inserts value in previously created table, but I get this error:

**#1048 - Column 'admin_id' cannot be null **

I think it's error cause we create table with "int" variables but we try to put in characters (@superuser)
How do I fix this, cause installation now isn't working?

fision:

I think it's error cause we create table with "int" variables but we try to put in characters (@superuser)
How do I fix this, cause installation now isn't working?Only put "int" values into the "int" column.

Actually "int" is type of varible in column "admin_id". Value to put in is @superuser.
When I execute sqlquery INSERT INTO admin_visible_headers VALUES (1, @superuser); I get error (*#1048 - Column 'admin_id' cannot be null *)

If I go and insert manually in db column value @superuser it wont do it cause it wants integer and @superuser isn't integer. I guess?
So what is proper syntax to INSERT this variable.