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

[lotii10396]

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?

[lotii10396]

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

[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=999

[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.

Regards John bosich.

[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.

[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

[funkey]

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.

[kuroi]

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.

[kuroi]

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 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.

[kuroi]

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.

Regards John bosich.

John

Which version of Admin Profiles have you installed?