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

i just installed this mod on my cart and when i log into the admin I get this message

1146 Table 'kjoistud_zc1.zen_admin_files' doesn't exist
in:
[select id from zen_admin_files where page = 'server_info']
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.

with no links on the panel.

please help!

I found this on the WIKI:
When I logged in, I got this message - 1146 Table 'MY_DB.admin_menu_headers' doesn't exist - and no headers, so I couldn't go to Tools
This indicates that the tables used by Admin Profiles don't exist in your database. Most likely you have not run (successfully) the Admin Profiles installtion SQL.

Ok, now, i guess i know what is wrong, but if I can't get to my tools to run the installation SQL, how do I fix it?:blink:

gotalkaboutit:

Hey everyone,

I'm getting a weird error when a FRESH install of 1.3.7 -

I used the patched files plus the sql install both in my phpMyadmin (1st time) and my Install SQL Patches (2nd time).

I get this error every time when i click on permissions (which by the way isn't the image, just a text link)

500 Error (Internal Server Error) due to it trying to reach this link..
/admin/FILENAME_ADMIN_CONTROL.php?adminID=1

Any ideas on WHY this is happening??

Thanks in advance,

BradThat Zen Cart can't find the permissions image, or resolve the FILENAME_ADMIN_CONTROL reference shows that you have installed the files to the wrong place.

Please track down and post the full path name to you admin_control.php file. This will hopefully show what has gone wrong and what needs to be done to fix it.

kjoistudios:

I found this on the WIKI:
When I logged in, I got this message - 1146 Table 'MY_DB.admin_menu_headers' doesn't exist - and no headers, so I couldn't go to Tools
This indicates that the tables used by Admin Profiles don't exist in your database. Most likely you have not run (successfully) the Admin Profiles installtion SQL.

Ok, now, i guess i know what is wrong, but if I can't get to my tools to run the installation SQL, how do I fix it?:blink:You will need to use whatever external mechanism your web host makes available for running SQL patches. Most common is phpMyAdmin. If you are using a database prefix you will need to edit the DQL manually to add it to the commands.

i have a problem i forgot my user name and password to the admin page. i tired
DELETE FROM admin WHERE admin_name = 'Admin'; INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level) VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

but when i log in i dont have the menus so i cant do anything. Please help

xav13r:

i have a problem i forgot my user name and password to the admin page. i tired
DELETE FROM admin WHERE admin_name = 'Admin'; INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level) VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

but when i log in i dont have the menus so i cant do anything. Please help
Try using whatever method your web host provides for accessing your database directly (e.g. phpMyAdmin) to edit the ID for your newly created Admin user to "1".

thanks for the help

I'm having trouble installing admin profile module. Where do install it. Please make it as simple as u can.

Dave

Hello all,

First, I wanted to thank Kuroi for such a rockin' mod!

Second, I wanted to share how I solved the problem of "the missing P" cited in some of the previous posts for this thread. Following the whole template override idea, I tried to carry this over to the admin section when copying the admin.php file. For example, I instinctively placed Kuroi's admin.php as admin\yourtemplate\admin.php since there was already an admin.php in existence and I didn't want to overwrite it.

Guess that doesn't really work for admin side? I'm not sure, but since I haven't altered the admin.php for my site and had a backup copy, I used Kuroi's file and placed it directly in the admin folder, overwriting the original. Magically, the "P" appeared and everything works great.

If I'm making a huge mistake in doing this, someone please comment so others don't do the same. Thanks!

I installed everything where I think that it's suppose to be (I think). I instulled the install_admin_profiles and upgrade_admin_profiles. I still do not have the "P".

Dave:frusty:

Hi, does this plugin works for ZC 1.3.7???
Cuz I only see updates for 1.3.6 on the archive..

thanks

Did I miss something?

I copied admin_control to admin.

I copied denied to admin.

I copied icon_permissions to admin/images.

I copied config_admin_profile to admin/includes/auto_loaders.

I copied product_music+extras.dhtmp to admin/includes/boxes/extra_boxes.

I copied catalog_dhtml, configuration_dhtml, customers_dhtml, extras_dhtml, gv_admin_dhtml, localazation_dhtml, modules_dhtml, reports_dhtml, taxes_dhtml, tools_dhtml

to admin/includes/boxes.

I copied admin_profile_data to admin/includes/extra_datafiles.

I copied admin_profile to admin/includes/functions.

I copied int_admin_auth to admin/includes/int_includes/overrides.

I copied button_edit_permissions to admin/includes/languages/english/images/buttons.

I copied english (from the extras_patches) to admin/includes/languages.

I copied user_tracking_tools_dhtml to extras.

also I updated file with install_admin_profiles, and upgrade_admin_profile.

It still doesn't work. What did I do wrong.

:frusty:
Dave

Did I miss something?

I copied admin_control to admin.

I copied denied to admin.

I copied icon_permissions to admin/images.

I copied config_admin_profile to admin/includes/auto_loaders.

I copied product_music+extras.dhtmp to admin/includes/boxes/extra_boxes.

I copied catalog_dhtml, configuration_dhtml, customers_dhtml, extras_dhtml, gv_admin_dhtml, localazation_dhtml, modules_dhtml, reports_dhtml, taxes_dhtml, tools_dhtml

to admin/includes/boxes.

I copied admin_profile_data to admin/includes/extra_datafiles.

I copied admin_profile to admin/includes/functions.

I copied int_admin_auth to admin/includes/int_includes/overrides.

I copied button_edit_permissions to admin/includes/languages/english/images/buttons.

I copied english (from the extras_patches) to admin/includes/languages.

I copied user_tracking_tools_dhtml to extras.

also I updated file with install_admin_profiles, and upgrade_admin_profile.

It still doesn't work. What did I do wrong.

:frusty:
Dave

creative:

I wanted to share how I solved the problem of "the missing P" cited in some of the previous posts for this thread. Following the whole template override idea, I tried to carry this over to the admin section when copying the admin.php file. For example, I instinctively placed Kuroi's admin.php as admin\yourtemplate\admin.php since there was already an admin.php in existence and I didn't want to overwrite it.

Guess that doesn't really work for admin side? I'm not sure, but since I haven't altered the admin.php for my site and had a backup copy, I used Kuroi's file and placed it directly in the admin folder, overwriting the original. Magically, the "P" appeared and everything works great.

If I'm making a huge mistake in doing this, someone please comment so others don't do the same. Thanks!You're not making a mistake at all. The over-ride system hasn't yet been extended to the Admin part of Zen Cart, so currently you must overwrite rather than override the file there.

fher98:

Hi, does this plugin works for ZC 1.3.7???
Cuz I only see updates for 1.3.6 on the archive.Yes. There was no need to upgrade it for 1.3.7 or 1.3.7.1.

daver1510:

Did I miss something?

I copied admin_control to admin.

I copied denied to admin.

I copied icon_permissions to admin/images.

I copied config_admin_profile to admin/includes/auto_loaders.

I copied product_music+extras.dhtmp to admin/includes/boxes/extra_boxes.

I copied catalog_dhtml, configuration_dhtml, customers_dhtml, extras_dhtml, gv_admin_dhtml, localazation_dhtml, modules_dhtml, reports_dhtml, taxes_dhtml, tools_dhtml

to admin/includes/boxes.

I copied admin_profile_data to admin/includes/extra_datafiles.

I copied admin_profile to admin/includes/functions.

I copied int_admin_auth to admin/includes/int_includes/overrides.

I copied button_edit_permissions to admin/includes/languages/english/images/buttons.

I copied english (from the extras_patches) to admin/includes/languages.

I copied user_tracking_tools_dhtml to extras.

also I updated file with install_admin_profiles, and upgrade_admin_profile.

It still doesn't work. What did I do wrong.

:frusty:
DaveWhy not just follow the installation instructions packaged with the mod?

Maybe I'm missing something. I found the install_admin_profiles.sql file, but could not find the install_adminlevels.sql file.

If you are using a database prefix for your Zen Cart tables, you must either: run the install_adminlevels.sql file using Zen Cart's Admin > Tools > Install SQL Patch facility, or edit the file to change the prefix for all create table and insert statements, before running it using your preferred tool.

If you are not using a database, simply run the install_admin_profiles.sql file using your preferred tool for executing SQL (e.g. phpMyAdmin

I dropped the admin folded in my shop and checked everything is where it should be but I still do not get the "P".

Help!

daver1510:

Maybe I'm missing something. I found the install_admin_profiles.sql file, but could not find the install_adminlevels.sql file.

I dropped the admin folded in my shop and checked everything is where it should be but I still do not get the "P".That you should run install_admin_profiles.sql and not install_adminlevels.sql has been covered several times previously in this support thread.

Which option did you select for step 3?

Is there an abilty to tie a particular user to an IP address with this mod?

I would like to restrict a users access to a work computer.
They shouldn't be able to have access from another computer away from work.

gilby:

Is there an ability to tie a particular user to an IP address with this mod?Not currently, but it's on the To Do list and not that far from the top now.