admin menu broken after installing many conflicting plugins

When I log into my admin page, I noticed that "Admin Access Management" is missing on the menus. How can I add this back?
thanks

That option is available out-of-the-box with a fresh install of Zen Cart.

So, when did this symptom start?
What changes did you make between "when it was there" and "when it disappeared"?

If I recall it was there when I first started, I tried to add Admin Profiles and had errors, which I believe I remove all of admin profiles. How could I restore this

You've got me confused.. first, what version are you using?

v1.5 comes with Admin Profiles already installed (now referred to in the menu as Admin Access Management).

In previous versions, you needed to install the "Admin Profiles" mod, which then appeared under Tools->Admin Profiles. It sounds like (I might be misunderstanding) you installed 1.5, then tried to install Admin Profiles mod (on top of the already existing code), then tried to uninstall it? If that's the case, my advice would be to start over with a fresh install - or use a compare program to find out what has changed, and revert it back to stock 1.5 code.

If i am misunderstanding, please clarify..

YOu are right. I started with 1.5 [I wanted more control over admin, and thinking admin profiles would do this I installed it], then had problems 500 errors, and did not even realize that it was even missing until a few days ago. Would upgrading to the 1.5.1 zencart fix this, would prefer not starting over.
Thanks

I wouldn't add the extra confusion of an upgrade into the mix until you get this sorted. If you don't want to start fresh, you can use a compare program to find what files are different from your site vs a clean installation - but you'll need to know what you're looking at, and determine if the differences are from your admin profiles "issue", or from customizations you've made.

If this were me - I would start with a fresh version of 1.5.. i'd do a compare with my site files, and then copy over any edits that you've made FROM your site, TO the fresh install. Most should be done in overrides folders, and will be easily transferred. Any core edits can be identified and transferred over. Then, when you're done, you'll have a complete set of 1.5 files along with your changes.

If you do it the other way around (copying files FROM fresh install TO your site files), it's very easy to miss something, and you could spend months chasing down admin access errors..

As always, all of this work should take place on a local backup of your files, and nothing should be done on live site until everything is tested and working.

Just my 2¢

I copied all the orginal files from from the orginal setup and that tab is missing there as well, that might have been why I looked into admin profiles.
What can I do? Could this be in the database?
Thanks

yes, in the new 1.5 version - modules have to be "registered" before they will appear on the admin menu. if you run these queries on your db vs a fresh test db, you'll see what you need to have in your db..

SELECT * FROM admin_pages where language_key LIKE "BOX_ADMIN_%"

also run:

SELECT * FROM admin_menus where language_key = "BOX_HEADING_ADMIN_ACCESS"

first one should return 4 results from a fresh install.. your db needs these same 4 results.

second one should return 1 result, again, you need that in your install if it's not there.

(these are educated guesses, as you're beyond normal procedure and are instead cobbling together pieces that were broken by the uninstall.. so again, do this on test db/site before doing anything to live. in theory if the files are all there, and you replace the database values, the menu should appear)

Do I enter this in the SQL Query Executor ?

From what I can tell the files needed are all there

Simplest approach:

use phpMyAdmin to:

• delete everything from your "admin" table
• put back a single new user
  These can be done by following this process: http://www.zen-cart.com/content.php?44-how-do-i-change-or-reset-my-admin-password-%28i-lost-it%29

then login to your admin and reset the password, again as described in that article

Do the symptoms still exist?

• if not, then go ahead and set up your own personalized admin user account, and delete the temporary one created by the above process
• if yes, then your problems are much deeper and will require quite a bit of digging, using phpMyAdmin

I get error: #1146 - Table 'tel1222205460806.admin' doesn't exist

Then you probably installed Zen Cart using some sort of one-click-auto-installer from your hosting company, and they've added a "zen_" (or some other) prefix to all your table names.
So the DELETE FROM admin will need to be changed to DELETE FROM zen_admin
Same with the INSERT INTO statement.

logged in with the admin, and the menu is still not there

I beleive I got the SQL database. How can I add all the products and groups back from this SQL file?

I have a store made up and have added many products, I noticed after adding all the products, setting up the interface for the user, and install plugins, that the admin menu is missing. I created a new zencart [on the same domain] with a new database and the admin page returns. If I take the new database, and have replace the damage database the admin menu returns[but I loose the products]. Does anyone know either where this is located in the database, or how I can get the menu back[need this to setup permissions for other users].
Thanks in advance

**CONTEXT:
**a) You said you've installed a clean new instance of Zen Cart into a new database.
b) And you want to fix a corrupted admin menu in the old database, using the clean working (uncustomized) menu from the new one.

c) You were thinking that you wanted to copy the products from the old one into the new one, as your fix. But, since this is an admin problem, don't touch the products/categories/etc.
Instead, focus on restoring just the menu, as in (b).

**RESTORING:
**As long as the tables in both database have the same prefixes (ie: the "admin" table is actually named "admin" and not "zen_admin" ... in both databases), then the following steps will put the clean new admin-user settings into the old database.

First, on the NEW DATABASE, that is the clean properly-working new version:

1. Login to phpMyAdmin, find your NEW Zen Cart database. Click on it so the tables are all listed.
2. click on the Export tab
3. A box will appear listing all your tables, click on each of these tables (using CTRL-click to select more than one at a time):

• admin
• admin_menus
• admin_pages
• admin_pages_to_profiles
• admin_profiles
  (Since you'll probably ask, NO, don't select the admin-activity-log table)

3. On the right-hand side, check the checkbox next to "Add DROP TABLE / VIEW / etc........"

4. On the bottom, check the "Save as file" checkbox

5. Click Go.

6. Now select the OLD BROKEN database from the pulldown on the far/top left.

7. Click the Import tab

8. Select the CHOOSE FILE browse button, and select the file you downloaded in #5 above.

9. Click Go.

Then delete the temporary "new" database and temporary store files, since it's not needed.

Did the above, message reads: Import has been successfully finished, 123 queries executed.
I logged into the admin page, and the problem is still there...

Okay, then the problem wasn't with the menu. Or else the tablenames have different prefixes and thus didn't actually restore anything.

no idea, not even sure where to look. I would have thought the menu names would have been in the database, considering that when the database is changed it shows up.

no idea, not even sure where to look
Load your database in phpmyadmin and inspect the table names
Look for any prefix to the table name
If there is a prefix then insure that ALL tables have the same prefix