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

You're probably right about me trying not to be so critical...I guess the steps are not quite specific enough for me to understand.

As far as doing step 1, I THOUGHT I did...but it never said which admin->settings to modify. Is it talking about making these changes to the LIVE admin of the site, or an admin file that came with this module's download?

As far as the "Zen Cart Install SQL Patch facility" I'm not sure I know what you're referring to. Zen Cart and osCommerce are two of the shopping cart options available inside of my hosts' cPanel. I just choose which one I want and click an install button and voila...I go to the url to log in to admin. Not sure what a SQL Patch facility is and I've never written tables or anything that makes up DB's.

Is this something I have to get a programmer to do? Cause if I'm oblivious to the very first step...there's a high chance I'm gonna fail this horribly!!! lol :shocking:

Quote:

---

Originally Posted by tagon

As far as doing step 1, I THOUGHT I did...but it never said which admin->settings to modify. Is it talking about making these changes to the LIVE admin of the site, or an admin file that came with this module's download?

As far as the "Zen Cart Install SQL Patch facility" I'm not sure I know what you're referring to. Zen Cart and osCommerce are two of the shopping cart options available inside of my hosts' cPanel. I just choose which one I want and click an install button and voila...I go to the url to log in to admin. Not sure what a SQL Patch facility is and I've never written tables or anything that makes up DB's.

---

Take a deep breath. This sound like a confidence issue more than anything else. You're in an unfamiliar place dealing with unfamiliar vocabulary.

If you've just installed Zen Cart then you probably only have one admin user, and their ID is probably 1. Step starts by asking you to to verify this to avoid the risk of awkwardness later.

You do so by logging into the Admin area and then finding the Admin Settings option on the Tools menu.

Provided that you are doing this as user one, you then find the Install SQL Patch facility on the same Tools menu in the Admin. From there you can browse to and run the SQL installation file.

This method is recommended as it's the easiest for new users. It avoids problems with database prefixes for example. But if you are unable to get into your Admin because of steps taken ealier, then we'll need to get into that - but even so, it's really not too difficult, and you'll learn at every step of the way.

Hello guys!
Nice work with this mod, but I have a problem.
I've installed correctly the mod in my website.
Now when I enter in the admin area, with my user and also with another, the configuration drop-down menu is visible, but when I go over with the mouse no option are listened, so I can't access any of the configuration functionality.
All the other menù like catalog or tools are correctly visible and works.

I've readed this thread and I've checked the category menù and also all is content in the admin profiles, but nothing changed.

Please,m can you help me?

Thank you


Alessandro

Solved it, it was a problem with extra modules and second lenguage I think, anyway now it is ok!
thank you

Alessandro

I was installing the Admin_Profiles to 3 carts (1.3.8) with no other admin add-ons.
The first store went well and works fine. However, I got interrupted and confused with the 2nd and 3rd stores and overwrote the files with one without first applying the patch.

When I tried to log-in, it gave me messages that it couldn't find the proper tables.

Using PHPMyAdmin, I was able to run the patch to create the proper tables. Now, when I try to log-in, I get this error:

1054 Unknown column 'admin_id' in 'field list'
in:
[select admin_id from zen_admin_visible_headers where header_id = '1']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Now that I have 'stepped in it', how can I fix it?

Prompt help is greatly appreciated!

OK... I think I have muddled my way through...

It seems that the "zen_" prefix is added to tables when created via the Admin's SQL Patch module. So I got the table names corrected using MyPHPAdmin.

However, the same prefix does NOT apply to field names.

By correcting this, I was able to log-in, but the profile functions did not work. Admin #1 was able to access everything but could not make the permissions work. All other logins only saw the home page - unable to navigate - no menu headers are visible...

However since Admin #1 was functioning, I patched the system via the admin tools - (as I should have originally).

NOW IT WORKS!

Hopefully, if any other knuckleheads repeat my folly, they can find this thread and save themselves a lot of grief!

Okey doke, our webhost is probably going to be switching to php 5.3 shortlyish, (hopefully after the 1.3.9 release), is anyone on here running this on a php 5.3 server?
I did check the download page for this mod for php 5.3 compatibility, but it is listed as "unknown or n/a"

My website got hacked last night. I had to restore my html files back to a version before I installed admin profiles. I also restored by database file back to a recent date after admin profiles was installed. I couldn't log on to the admin section so I used the script in the tutorials section to reset the account to username Admin password admin. I can now get into the admin area but none of the tabs are available including tools>admin setup. So I can't change usernames or passwords. I tried to install admin profiles again but of course I can't run the mysql script because I don't have access to that tab.
I noticed that the hacker had gained access to the database and had changed the username and password to the main administrator account. I tried to manually change the username and password using PhpMyAdmin in the admin table.
Is there a way to "uninstall" admin profiles or some other way to gain access to the admin features?

OK,
I figured it out. I was able to rerun the sql patch using cPanel, then PhpMyAdmin. I pasted the sql code from the patch file into the query box and ran it. After that I had to resend a password using that feature on the login screen but once I used the new password it emailed me I was in with full privileges. All the other users were reset with no privileges so I had to reset them all.

thanks, i had same problem. For some reason Firezilla didn't upload the extra_datafile folder. Go figure!