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

Sorry all - I know this is a common one but I've spent an hour searching specific threads and I'm not really getting anywhere....plus theres so many threads it will take way too much time to keep browsing for an answer....

USING: admin_profiles_v1_0_6 & Zen Cart 1.3.7

SQL installed directly via phpAdmin console, files uploaded via FileZilla

Admin login error as detailed in lots of places:

1146 Table 'my_database.admin_menu_headers' doesn't exist
in:
[select id from admin_menu_headers where header = 'Configuration']

BUT - the table IS there and I've cross-checked that they also contain the inserted data as specified in the 2 SQL files. How do I know the table is there? Well heres the results when I run the EXACT SAME SQL query above directly from phpAdmin.....

Showing rows 0 - 0 (1 total, Query took 0.0001 sec)
SQL query:
SELECT id
FROM admin_menu_headers
WHERE header = 'Configuration'
LIMIT 0 , 30

Here is the contents of 'admin_menu_headers' also run directly from SQL

Showing rows 0 - 10 (11 total, Query took 0.0001 sec)
SQL query:
SELECT *
FROM admin_menu_headers
LIMIT 0 , 30 Profiling [ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]

        row(s) starting from record #  

in horizontal horizontal (rotated headers) vertical mode and repeat headers after cells
Sort by key: id (Ascending) id (Descending) None id header
0 Third Party Mods
1 Configuration
2 Catalog
3 Modules
4 Customers
5 Taxes
6 Localization
7 Reports
8 Tools
9 GV_Admin
10 Extras

---------------------------------------------------------------------

If I try the visible "version" menu option I get the similar error:

1146 Table 'my_database.admin_files' doesn't exist
in:
[select id from admin_files where page = 'server_info']

---------------------------------------------------------------------

Again checking in phpAdmin confirms both that the tables DOES exist and the query can be run from the SQL panel. So does anyone have any ideas? Obviously the new files are there (as they would be the only ones referring to the new tables) AND the site must be connecting to the database - so why cant it access the new tables?

Further info - I have created some custom php pages which successfully run the [[select id from admin_menu_headers where header = 'Configuration'] SQL query, so I further confirm that the site IS connecting to the database and that the tables & data exist.

My forum searching indicates that this error is typical when the tables have not been created or populated correctly (usually because of table prefixes) but this is NOT the cause of my error, and I simply cant find the solution in the posts.

Can someone shed some light as to where (ie what files) I should be looking to investigate this? I was thinking of using this module as it certainly seems to provide the solution I am looking for, but if I can't get it to work/get some insight from the forums then I suppose I'll re-invent the wheel.....again:(

I got this module to work with Zen Cart v1.3.8. I am stuck with the (extras - user tracking.)

After instlling the files in the (extras - user tracking) older, the option under

I get this under
tools>
BOX_TOOLS_USER_TRACKING
BOX_TOOLS_USER_TRACKING_CONFIG

Is this due to the fact I am using Zen Cart v1.3.8. I

Check the screen shots

When I click on BOX_TOOLS_USER_TRACKING it takes me to domain/store/admin/FILENAME_USER_TRACKING.php

When I click on BOX_TOOLS_USER_TRACKING_CONFIG it takes me to domain/store/admin/configuration.php?gID=999

Have done a clean install of Version 1.3.7 of Zencart then installed Admin Profiles files, did database sql patches. All working to a point no errors but secondary user always has no priviliges to anything except Admin Home. Have I missed something or is there other problems with 1.3.7 ZenCart version. When I check any of the boxes and save I get no change when I log back in as the secondary user but all boxes checked remain checked. :dontgetit

Regards John bosich.

First, please excuse me if this has already been asked. I was unable to find an answer.

So, I am using Admin Profiles to restrict access to two other people. These people will be processing orders and adding products to the Catalog. So that they do not mess up my settings I don’t want them to have access to the nuts and bolts of the Cart. I would however, like them to have access to change their passwords if need be. I attempted to give them access to the Tools menu and then access to the Admin Settings. I did not check off the Admin Controls* box listed under Third Party mods.

Unfortunately, this gives them access to change their passwords but also everyone else’s and gives them access to the Admin Controls which defeats the purpose.

Does anyone know how I could restrict their access to resetting their passwords only?

Thank you much.

Sorry, one more thing I just noticed. No one, myself included even with full admin privileges, is allowed to have their Password resent from the Admin Login (in case they forget).

How may I turn this back on?

Thanks

kuroi:

Are you using a database prefix?

Nope.

The only change I made from the install instructions was to re-name the .sql file to mysql_admin_profiles_106.sql and put it in zc_install/sql/plugins/ in order to get it to run at the correct point at the install.

It's a prefix-less DB, with no caching on MySQL 5.0.20.

lotii10396:

My forum searching indicates that this error is typical when the tables have not been created or populated correctly (usually because of table prefixes) but this is NOT the cause of my error, and I simply cant find the solution in the posts.Although I've seen this problem many times, every instance that I have seen has been due to either not installing the SQL at all, which clearly isn't the case here, or not handling database prefixes correctly during installation, which you hint isn't the case either. Beyond that I can only assure you that the problem doesn't originate from Admin Profiles as the mod using the same generic database class to access the database as does the rest of Zen Cart. I'd be very interested to hear what it is though when you get to the bottom of it.

roosterd:

I got this module to work with Zen Cart v1.3.8. I am stuck with the (extras - user tracking.)

After instlling the files in the (extras - user tracking) older, the option under

I get this under
tools>
BOX_TOOLS_USER_TRACKING
BOX_TOOLS_USER_TRACKING_CONFIG

Is this due to the fact I am using Zen Cart v1.3.8. I

Check the screen shots

When I click on BOX_TOOLS_USER_TRACKING it takes me to domain/store/admin/FILENAME_USER_TRACKING.php

When I click on BOX_TOOLS_USER_TRACKING_CONFIG it takes me to domain/store/admin/configuration.php?gID=999Have you installed the user tracking mod? From your error messages it looks as though you may have only installed to extra files included with Admin Profiles to allow user tracking to work with it.

John Bosich:

Have done a clean install of Version 1.3.7 of Zencart then installed Admin Profiles files, did database sql patches. All working to a point no errors but secondary user always has no priviliges to anything except Admin Home. Have I missed something or is there other problems with 1.3.7 ZenCart version. When I check any of the boxes and save I get no change when I log back in as the secondary user but all boxes checked remain checked. :dontgetit

Regards John bosich.John

Which version of Admin Profiles have you installed?

Cienwen:

First, please excuse me if this has already been asked. I was unable to find an answer.

So, I am using Admin Profiles to restrict access to two other people. These people will be processing orders and adding products to the Catalog. So that they do not mess up my settings I don’t want them to have access to the nuts and bolts of the Cart. I would however, like them to have access to change their passwords if need be. I attempted to give them access to the Tools menu and then access to the Admin Settings. I did not check off the Admin Controls* box listed under Third Party mods.

Unfortunately, this gives them access to change their passwords but also everyone else’s and gives them access to the Admin Controls which defeats the purpose.

Does anyone know how I could restrict their access to resetting their passwords only?

Thank you much.Amazingly, this hasn't been asked before. And you're right. I have made a note of this for consideration for future releases.

Cienwen:

Sorry, one more thing I just noticed. No one, myself included even with full admin privileges, is allowed to have their Password resent from the Admin Login (in case they forget).

How may I turn this back on?I suspect that you may be using one of the older versions of Admin Profiles, as this was fixed several releases back. Which version are you using?

funkey:

Nope.

The only change I made from the install instructions was to re-name the .sql file to mysql_admin_profiles_106.sql and put it in zc_install/sql/plugins/ in order to get it to run at the correct point at the install.

It's a prefix-less DB, with no caching on MySQL 5.0.20.You're venturing into new ground here. Are the tables being created when you execute the SQL this way?

kuroi:

Have you installed the user tracking mod? From your error messages it looks as though you may have only installed to extra files included with Admin Profiles to allow user tracking to work with it.

Is the user tracking a separate mod or is it contained within the admin profile mod?
Is its a separate mod, is it located in the download section?

Thank you for your help!

Hi,
excuse me for my english, I'm Italain.

I'have some problems with admin profiles modules!

the problem is when 2 admin with different permissions logged-in.

If i'm logged in in admin and another admin user with other permission log-in, the my admin permission change!!!!

Help me!!

roosterd:

Is the user tracking a separate mod or is it contained within the admin profile mod?
Is its a separate mod, is it located in the download section?It's a separate mod. Beyond that, I'm afraid I know nothing about it.

kevinx:

I have some problems with admin profiles module!

If i'm logged in in admin and another admin user with other permission log-in, my admin permissions change!!!!That's curious. I'm unable to reproduce this with the current version. There were some problems with this with a long time ago due to a Zen Cart issue when PHP register_globals was switched on. But this was fixed in Zen Cart in version 1.3.0.1 or 1.3.0.2 I think.

What version of Zen Cart are you using? What version of Admin Profiles? And do you have registers_global turned on?

kuroi:

You're venturing into new ground here. Are the tables being created when you execute the SQL this way?

They certainly are, i've got tables for admin_menu_headers, admin_visible_headers, admin_menus and admin_allowed_tables.

Anything else I should look for?

Cienwen:

Sorry, one more thing I just noticed. No one, myself included even with full admin privileges, is allowed to have their Password resent from the Admin Login (in case they forget).

How may I turn this back on?

Thanks

I had the same experience, fresh install of Zen Cart 1.3.8a and Admin Profiles 1.0.6 from the downloads. I applied the fix listed in the Contribution:Admin Profiles Wiki and everything seems to be working. sort of.

I tested this on two servers one with Register Globals OFF and one Register Globals ON (I know I know, but this is not under my control). The patch from the wiki enabled the resend password function on both servers.

On the server with Register Globals OFF everything seems to function normally, but on the server with Register Globals ON if I try to check the "password forgotten" under Admin Profiles and click the "Save Changes" button i get logged off and the change is not made, but the password resend function still works. I also have to clear my browser cookies to log back on.

I will tipping back Heinekens on beaches of Big Island for the next few days, so I will not be able to respond to any questions about my experience untill I get back.

Thanks,
Jim

funkey:

They certainly are, i've got tables for admin_menu_headers, admin_visible_headers, admin_menus and admin_allowed_tables.

Anything else I should look for?Are they populated?