Restrict admins to certain areas?

kuroi:

In that case, I suspect that you have run the SQL without allowing for your database prefix. If you access your database directly using a tool such as phpMyAdmin, I suspect that you will see about four entries at the top of the table list with no prefix. If you edit their names to add "zen_" at the beginning, this will hopefully clear your problem.

I ran the SQL through the TOOLS area of ZC Admin. Is there a way to fix it without phpMyAdmin? I will check into getting phpMyAdmin as I see a lot of people recommend it.

eta: I see phpMyAdmin in my CPanel!! I will look through here and see if I can find the database. :)

DodgeGirl:

I ran the SQL through the TOOLS area of ZC Admin. Is there a way to fix it without phpMyAdmin? I will check into getting phpMyAdmin as I see a lot of people recommend it.That puzzles me a little, as Zen Cart's Install SQL Patch is usually quite good at sorting out database prefixes.

phpMyAdmin is normally available through your hosting account control panel. It doesn't have to be, but I have not yet come across a web host offering MySQL without it. So I'd start by looking there.

kuroi:

That puzzles me a little, as Zen Cart's Install SQL Patch is usually quite good at sorting out database prefixes.

phpMyAdmin is normally available through your hosting account control panel. It doesn't have to be, but I have not yet come across a web host offering MySQL without it. So I'd start by looking there.

Thank you very much Kuroi. I was able to get this working and let me tell you, I am so very thankful to you for developing this.

One more question, and I apologize in advance if this has already been answered.. but.. is there a way to restrict users from making changes to categories yet allowing them up set up their products? And is there a way to restrict them from only being able to access their products (ie: restrict to products by manufacturer). Hope that makes sense.

Thank you again!

Question.. Why wasn't admin profiles mod included in version 1.3.8 release?

Seems like a no brainer to me to include it.

Also , does admin profiles mod have issues with the 1.3.8 release?.. Ive already installed this release. Im just wondering if I have to do a full re install just to add this mod.