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

[nadsab]

Hi,

I'm Using ZC 1.3.8a with no database prefix's used. I don't use PhpMyAdmin to manage the database, (never have). I use Navicat.

install.txt indicates - If you are not using database prefixes, simply run the install_admin_profiles.sql file using your preferred tool for executing SQL (e.g. PhpMyAdmin).

My (maybe) dumb question is, is using PhpMyAdmin required? Can I run the install either via Zen Cart's Admin > Tools > Install SQL Patch facility, or via Navicat?

[nadsab]

Also, if I can upload install_admin_profiles.sql to the SQL Query Executor in ZC Admin (instead of using PhpMyAdmin), what's the complete command syntax I need to enter into the “Enter the query
to be executed:“ box to run the install_admin_profiles.sql file?

[mauryg]

My (maybe) dumb question is, is using PhpMyAdmin required? Can I run the install either via Zen Cart's Admin > Tools > Install SQL Patch facility, or via Navicat? Also, if I can upload install_admin_profiles.sql to the SQL Query Executor in ZC Admin (instead of using PhpMyAdmin), what's the complete command syntax I need to enter into the “Enter the query
to be executed:“ box to run the install_admin_profiles.sql file?

Very simple. DO NOT try to EXECUTE the file from the SQL Patch Install tool. Simply open the .sql file in a text editor, copy the whole file and paste it into the query window and run it. You can use any SQL tool to execute the query. The advantage of the ZenCart tool is that it will automatically apply the table prefix if you are using one in your database.

[nadsab]

Thanks mauryg

Think I got it!

I assume that by sql patch install tool, that you mean the "SQL Query Executor" in Zen Cart Admin - correct?

When you say run the .sql file, do I just paste it in and click send, or do I need to also add an sql command at the begging of the .sql file?

[nadsab]

Hi,

I ran the script as described and it installed. There seems to be a problem in my setup though.

The menu headers, even though I disabled them for a user, are still showing up whether or not I check them off in admin permissions.

I read this post earlier in this thread http://www.zen-cart.com/forum/showthread.php?t=35911&page=37 In which Kuroi assisted someone else who had a similar problem

It sounds as though you have upgraded by over-writing the existing files, rather than merging changes into the new files.

If this is the case you will need to re-apply the admin box files from the mod as that's where the allowable menu accesses are checked. Even better would be to compare them with the new files in case there are new menu items added in this release that aren't allowed for in the mod's box files. I haven't yet checked this.

I did not upgrade, this was a fresh, new install with no changes to admin files other than the patches I applied as per install.txt step 3:

Code patches:
If you have installed or upgraded to Zen Cart 1.3.6 and have NOT made changes to admin\admin.php or admin\includes\languages\english.php, and have NOT since installation/upgrade applied any other add-ons that affect these files, then you may use the pre-patched files in the folder named "extras - patched files for ZC1.3.6".

Otherwise you will need to apply the following patches manually. The patches differ a little between Zen Cart versions 1.3.0.2 and 1.3.6.

All I did was install and overwrite the old admin files which came with ZC with the new patches which is what I thought was the correct procedure.

My question is, even if this is a fresh install for a 1.3.8a store, is overwriting files not recommended? Do i need to run a compare – merge change with every file in extras - patched files for ZC1.3.6 and every ZC admin file that would be overwritten by the patches?

[nadsab]

One more question on this, from the previous post: http://www.zen-cart.com/forum/showth...=35911&page=37

What is meant by “re-apply the admin box files from the mod”? Use the old box files from ZC? Over write old with new that come with the mod? Compare and merge?

[mauryg]

Nadsab,

The menu headers, even though I disabled them for a user, are still showing up whether or not I check them off in admin permissions

I learned a long time ago, "when you hear hoofbeats, think horses, not zebras."
Let's check the simple thing first. You unchecked the individual menu items for the user. Did you ALSO uncheck the menu name itself? It is a separate box on the blue bar.
When Kuroi said "reapply the box files from the mod" he means re-copy those files from the Admin Profiles mod set, specifically the files in the admin/includes/boxes folder. These are the ones which set the menu items. Since the mod was written BEFORE v1.38a ( I think 1.35), there may have been changes made to these files between the time the mod was written and 1.38a was released. If you simply replaced the 1.38a files with the mod files, you would lose those changes.
I also installed Admin Profiles over a fresh install of v1.38a. The procedure as I remember was to install the files in the 'admin' folder and then copy in the files from the patches for v1.36. That brings you to the latest version of Admin Profiles. It works fine, but I did do a WinMerge comparison of the files. I just checked my install and, for example, my copy of admin/includes/boxes/catalog.dhtml is essentially the same as the one in the Admin Profiles mod except for an extra line near the end which reads " $za_dir->close();" which came from v1.38a (it was a change from v1.37). This appears in most of the box files. I have zipped up all of my updated box files if you want to use them. They are all patched for 1.38a so you could just copy these files over your existing ones.

Hope this helps

[nadsab]

I learned a long time ago, "when you hear hoofbeats, think horses, not zebras."

:)

Let's check the simple thing first. You unchecked the individual menu items for the user. Did you ALSO uncheck the menu name itself? It is a separate box on the blue bar.

Yes mauryg, actually I tried all possible combinations of check boxes, was pulling what's left of my hair out all day, and still could not find the problem. Finally instead of taking your kind and gracious offer of your above zip file, i decided to pull more hair out and try to learn what I did wrong, so I downloaded and installed KDiff3 and ran a file compare, found lo and behold that all of the local files and server side files in the boxes dir were identical. I realized that somehow I neglected uploading all of the files from the Admin Profiles Mod (boxes dir only) to server, and all the files in boxes dir server side were original 1.3.8a files, not Admin Profiles Mod files. Anyway I uploaded the older boxes files from the mod and all seems to be working ok (except one little problem below). I finally saw the horses (I seem to love zebras though :)).

When Kuroi said "reapply the box files from the mod" he means re-copy those files from the Admin Profiles mod set, specifically the files in the admin/includes/boxes folder. These are the ones which set the menu items. Since the mod was written BEFORE v1.38a ( I think 1.35), there may have been changes made to these files between the time the mod was written and 1.38a was released. If you simply replaced the 1.38a files with the mod files, you would lose those changes.

So in reference to above, now all files in my boxes dir are from older modifications of the ZC 1.3.6 version for this mod. I have read that others are using this on 1.3.8a with no problems. Even though they are older files all seems to be working well, only concern here is, could this eventually cause admin problems if I don't do a merge and bring over code additions from the newer 1.3.8a boxes files into Admin Profiles boxes files?

I also installed Admin Profiles over a fresh install of v1.38a. The procedure as I remember was to install the files in the 'admin' folder and then copy in the files from the patches for v1.36. That brings you to the latest version of Admin Profiles.

I read in install.txt that no patches were needed in fresh store install, but I assume that was for 1.3.6 (and install.txt is also outdated), so even though instructions say manual edit of patches are not necessary you did it anyway because of 1.3.8a?

Which brings me to the last problem – when a user with lesser privileges than full admin clicks on the “Version” link in upper right of admin menu, that annoying message comes up - “Sorry, your security clearance does not allow you to access this resource...” instead of showing the ZC version, which I would like all to see. Do you or anyone know what file I can edit to add that version check back in?

[nadsab]

Strike that very last question - it's the Tools>Server Info checkbox that brought back the version.

[mauryg]

Glad to hear that you got it workinig