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

I am having problems installing admin_profiles.

In admin-tools-install sql patch : First I browse to the correct file and upload it. then I attempt to run it.

What I get is :

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'install_admin_profiles.sql' at line 1
in:
[install_admin_profiles.sql;]
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.

This is the first time I have used asql patch. So, this may be a obvious error on my part.

I am using Zen Cart 1.3.8a and it is admin profiles 1.0.7.

Any advice would be hugely appreciated!

Thanks

Nick

Please I need urgent help as I just installed the admin profile to my zencart and I can't access my admin menus, the thing is when I log in to my Admin page I get to my admin home page but whenever I click on any of the links on my admin menu I get this message " 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." and the other strange thing is for some reasen the e icon/button didn't show up on the admin page ! although I'm sure that I uploaded to the right loaction, my zencart version is 1.3.8a, I have only one admin for now but I'm planning to assign two more admins to have access, can anybody tell me what I did wrong and how to fix that problem !:no:

I'm still waiting for help !! :wacko:

This is a print-screen of the error message

Quote:

---

Originally Posted by alhakeem2001

Please I need urgent help as I just installed the admin profile to my zencart and I can't access my admin menus, the thing is when I log in to my Admin page I get to my admin home page but whenever I click on any of the links on my admin menu I get this message " 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." and the other strange thing is for some reasen the e icon/button didn't show up on the admin page ! although I'm sure that I uploaded to the right loaction, my zencart version is 1.3.8a, I have only one admin for now but I'm planning to assign two more admins to have access, can anybody tell me what I did wrong and how to fix that problem !:no:

---

Hello alhakeem2001, maybe this extract from the Wiki will help:

http://www.zen-cart.com/wiki/index.p...ve_disappeared

Good Luck

Quote:

---

Originally Posted by esavino

Ok but also with Admin_profiles 1.0.7 the configuration menu is not shown. I've installed the admin_profiles 1.0.7 as follow:

1) Install Patches SQL "install_admin_profile.sql"
2) Install Patches SQL "upgrade_admin_profiles.sql"
3) Replace folder admin with "admin_profiles_v1_0_7/admin"
4) Replace folder admin with "admin_profiles_v1_0_7extras - patched files for ZC1.3.8a/admin"

The file that doesn't function seems to be "configuration_dhtml.php".
If I replace this file with the original "configuration_dhtml.php" the configuration menù is shown but when I click on the sections (for example: info negozio, sessioni, regolamenti) I've the follow error: "Sorry, your security clearance does not allow you to access this resource.
Please contact your site administrator if you believe this to be incorrect.

---

You've not done anything wrong here (although it wasn't necessary to install the upgrade SQL). Rather the problem is most likely a restriction in the way that Admin Profiles currently works, which makes it difficult to change language. If you have English installed as a language for your Admin, then if you switch into that the Configuration Menu should work. Alternatively you would need to change the values in the admin-files database table to match exactly the text for each entry in the Configuration drop down menu.

I have a Pro version (paid for and includes installation) which completely reworks the structure with a view to extending it to be multilingual, and adding language will be high on my list of features to trickle down to the community version.

Quote:

---

Originally Posted by niccol

I am having problems installing admin_profiles.

In admin-tools-install sql patch : First I browse to the correct file and upload it. then I attempt to run it.

What I get is :

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'install_admin_profiles.sql' at line 1
in:
[install_admin_profiles.sql;]
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.

This is the first time I have used asql patch. So, this may be a obvious error on my part.

I am using Zen Cart 1.3.8a and it is admin profiles 1.0.7.

Any advice would be hugely appreciated!

Thanks

Nick

---

It's a big of a guess, but historically we used a funny back apostrophe thingy around fields because some MySQL installations seemed unhappy if we didn't. More recenly I've been hearing of versions that don't like it.

So I'd recommend making a copy of the installation SQL and doing a global find and replace to remove them all, and then try running that file. And please let us know how you get on.

@alhakeem2001

stickman's diagnosis is the same as I would have made if I'd got here earlier. Did that resolve the problem for you?

umm ok. I downloaded the admin_profiles_v1_0_7 and I backed up my public_html file before I began.

I then opened file zilla and uploaded the admin folder found in the admin_profiles_v1_0_7 folder. I then uploaded the admin folder found in the extras_patched files for ZC1.3.8a.

I also went to the Admin - Tools - Install SQL Patches and I chose the file install_admin_profiles SQL file from the admin_profiles_v1_0_7.

Now from what I can gather from the instruction (which are VERY confusing by the way) that's all the appropriate steps.

However when I log into my admin and I go to admin - Tools - Admin Settings I see the two admin passwords there. Mine and the one I'm trying to limit access to. I'm ID 1 and she is ID 2. But there is no Orange Circle with a white P as the instructions in the install.txt states. All that is there is a green with white e circle, a red with white x circle and a arrow looking triangle.

Where did I go wrong?

Please tell me here and possible if you can e-mail it to me - wittlethangz######################? If need be I can let you into my zencart to edit it. I need to get this where this girl can add her products but does not have access to other things. I tried very hard to follow the instructions and now I'm lost. I thought what I was doing was correct, but I don't see the p so I must have misstepped or misunderstood somewhere.

PLEASE HELP!

Thank you!

Quote:

---

Originally Posted by kuroi

It's a big of a guess, but historically we used a funny back apostrophe thingy around fields because some MySQL installations seemed unhappy if we didn't. More recenly I've been hearing of versions that don't like it.

So I'd recommend making a copy of the installation SQL and doing a global find and replace to remove them all, and then try running that file. And please let us know how you get on.

---

Thanks for your answer.

Actually, what I did was re-download everything and start again. Much the same technique as whacking the TV or kicking your car. But like those techniques it seemed to work. Also, I got right level of swearing which is always important.

Sorry, not to be much help as I don't know why it did not play the game to begin with. But thanks for admin_profiles it does just what I need it to do and now works beautifully.

Nick