Fixed it. Had to drop all the tables and then re-uploaded the install_admin_profiles.sql.Quote:
Originally Posted by duketrac
Works great!
And thanks, you got me looking in the right place.
Printable View
Fixed it. Had to drop all the tables and then re-uploaded the install_admin_profiles.sql.Quote:
Originally Posted by duketrac
Works great!
And thanks, you got me looking in the right place.
I am using 1.3.7 for one of my clients. His employees started to change the appearance even though they were only authorized to update products and such.
So I Uploaded the Admin Profiles - made the changes according to the INSTALL guide.
Then I found myself locked out.
I called my hosting providers and they changed my password to ADMIN and it let me in but nothing is there - except the following error:
1146 Table 'allenlen_ahfcatalog.allenlenadmin_menu_headers' doesn't exist
in:
[select id from allenlenadmin_menu_headers where header = 'Configuration']
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.
I am SO AFRAID OF DOING A RESTORE - i HAVE OVER A DOZEN ACCOUNTS THIS COULD AFFECT.
Does anyone have any ideas?
You can see the error yourself @ www.american-health-foods.com/catalog/admin Login is rose PW = admin
You can't hurt anything because we can't get in.
This database has been intact since September and there are thousands of products loaded. very critical.
Ive installed this mod many times and also have a test bed before going live,
I have never had any real issues that weren't an easy fix
hope have done a db backup, just before the sql for admin profiles was added...just incase
i installed this addon months ago and we really never used it so now i'm just looking to quickly remove admin profiles from my database how do i change the mysql code to do so.
do i just change insert to drop or something?Code:# Admin Profiles
# version 1.0
#
# SQL to initialise user with admin_id = 1 for Admin Profiles
# -----------------------------------------------------------
#
# Create table structure for table `admin_menu_headers`
#
DROP TABLE IF EXISTS `admin_menu_headers`;
CREATE TABLE `admin_menu_headers` (
`id` int(11) NOT NULL,
`header` varchar(16) NOT NULL default '',
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;
#
# Insert data into table `admin_menu_headers`
#
INSERT INTO `admin_menu_headers` VALUES (0, 'Third Party Mods');
INSERT INTO `admin_menu_headers` VALUES (1, 'Configuration');
INSERT INTO `admin_menu_headers` VALUES (2, 'Catalog');
INSERT INTO `admin_menu_headers` VALUES (3, 'Modules');
INSERT INTO `admin_menu_headers` VALUES (4, 'Customers');
INSERT INTO `admin_menu_headers` VALUES (5, 'Taxes');
INSERT INTO `admin_menu_headers` VALUES (6, 'Localization');
INSERT INTO `admin_menu_headers` VALUES (7, 'Reports');
INSERT INTO `admin_menu_headers` VALUES (8, 'Tools');
INSERT INTO `admin_menu_headers` VALUES (9, 'GV_Admin');
INSERT INTO `admin_menu_headers` VALUES (10, 'Extras');
#
# Create table structure for table `admin_visible_headers`
#
DROP TABLE IF EXISTS `admin_visible_headers`;
CREATE TABLE `admin_visible_headers` (
`header_id` int(11) NOT NULL default '0',
`admin_id` int(11) NOT NULL default '0'
) TYPE=MyISAM;
#
# Insert data into table `admin_visible_headers`
#
INSERT INTO `admin_visible_headers` VALUES (1, 1);
INSERT INTO `admin_visible_headers` VALUES (2, 1);
INSERT INTO `admin_visible_headers` VALUES (3, 1);
INSERT INTO `admin_visible_headers` VALUES (4, 1);
INSERT INTO `admin_visible_headers` VALUES (5, 1);
INSERT INTO `admin_visible_headers` VALUES (6, 1);
INSERT INTO `admin_visible_headers` VALUES (7, 1);
INSERT INTO `admin_visible_headers` VALUES (8, 1);
INSERT INTO `admin_visible_headers` VALUES (9, 1);
INSERT INTO `admin_visible_headers` VALUES (10, 1);
#
# Create table structure for table `admin_files`
#
DROP TABLE IF EXISTS `admin_files`;
CREATE TABLE `admin_files` (
`id` int(11) NOT NULL auto_increment,
`page` varchar(64) NOT NULL default '',
`header` tinyint(4) NOT NULL default 0,
`submenu` tinyint(1) NOT NULL default 0,
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;
#
# Insert data into table `admin_files`
#
INSERT INTO `admin_files` VALUES (1, 'My Store', 1, 0);
INSERT INTO `admin_files` VALUES (2, 'Minimum Values', 1, 0);
INSERT INTO `admin_files` VALUES (3, 'Maximum Values', 1, 0);
INSERT INTO `admin_files` VALUES (4, 'Images', 1, 0);
INSERT INTO `admin_files` VALUES (5, 'Customer Details', 1, 0);
INSERT INTO `admin_files` VALUES (6, 'Shipping/Packaging', 1, 0);
INSERT INTO `admin_files` VALUES (7, 'Product Listing', 1, 0);
INSERT INTO `admin_files` VALUES (8, 'Stock', 1, 0);
INSERT INTO `admin_files` VALUES (9, 'Logging', 1, 0);
INSERT INTO `admin_files` VALUES (10, 'E-Mail Options', 1, 0);
INSERT INTO `admin_files` VALUES (11, 'Attribute Settings', 1, 0);
INSERT INTO `admin_files` VALUES (12, 'GZip Compression', 1, 0);
INSERT INTO `admin_files` VALUES (13, 'Sessions', 1, 0);
INSERT INTO `admin_files` VALUES (14, 'Regulations', 1, 0);
INSERT INTO `admin_files` VALUES (15, 'GV Coupons', 1, 0);
INSERT INTO `admin_files` VALUES (16, 'Credit Cards', 1, 0);
INSERT INTO `admin_files` VALUES (17, 'Product Info', 1, 0);
INSERT INTO `admin_files` VALUES (18, 'Layout Settings', 1, 0);
INSERT INTO `admin_files` VALUES (19, 'Website Maintenance', 1, 0);
INSERT INTO `admin_files` VALUES (20, 'New Listing', 1, 0);
INSERT INTO `admin_files` VALUES (21, 'Featured Listing', 1, 0);
INSERT INTO `admin_files` VALUES (22, 'All Listing', 1, 0);
INSERT INTO `admin_files` VALUES (23, 'Index Listing', 1, 0);
INSERT INTO `admin_files` VALUES (24, 'Define Page Status', 1, 0);
INSERT INTO `admin_files` VALUES (81, 'EZ-Pages Settings', 1, 0);
INSERT INTO `admin_files` VALUES (25, 'categories', 2, 0);
INSERT INTO `admin_files` VALUES (26, 'product_types', 2, 0);
INSERT INTO `admin_files` VALUES (27, 'products_price_manager', 2, 0);
INSERT INTO `admin_files` VALUES (28, 'options_name_manager', 2, 0);
INSERT INTO `admin_files` VALUES (29, 'options_values_manager', 2, 0);
INSERT INTO `admin_files` VALUES (30, 'attributes_controller', 2, 0);
INSERT INTO `admin_files` VALUES (31, 'downloads_manager', 2, 0);
INSERT INTO `admin_files` VALUES (32, 'option_name', 2, 0);
INSERT INTO `admin_files` VALUES (33, 'option_values', 2, 0);
INSERT INTO `admin_files` VALUES (34, 'manufacturers', 2, 0);
INSERT INTO `admin_files` VALUES (35, 'reviews', 2, 0);
INSERT INTO `admin_files` VALUES (36, 'specials', 2, 0);
INSERT INTO `admin_files` VALUES (37, 'featured', 2, 0);
INSERT INTO `admin_files` VALUES (38, 'salemaker', 2, 0);
INSERT INTO `admin_files` VALUES (39, 'products_expected', 2, 0);
INSERT INTO `admin_files` VALUES (88, 'products_to_categories', 2, 1);
INSERT INTO `admin_files` VALUES (40, 'modulesset=payment', 3, 0);
INSERT INTO `admin_files` VALUES (41, 'modulesset=shipping', 3, 0);
INSERT INTO `admin_files` VALUES (42, 'modulesset=ordertotal', 3, 0);
INSERT INTO `admin_files` VALUES (43, 'customers', 4, 0);
INSERT INTO `admin_files` VALUES (44, 'orders', 4, 0);
INSERT INTO `admin_files` VALUES (45, 'group_pricing', 4, 0);
INSERT INTO `admin_files` VALUES (46, 'paypal', 4, 0);
INSERT INTO `admin_files` VALUES (78, 'invoice', 4, 1);
INSERT INTO `admin_files` VALUES (79, 'packingslip', 4, 1);
INSERT INTO `admin_files` VALUES (47, 'countries', 5, 0);
INSERT INTO `admin_files` VALUES (48, 'zones', 5, 0);
INSERT INTO `admin_files` VALUES (49, 'geo_zones', 5, 0);
INSERT INTO `admin_files` VALUES (50, 'tax_classes', 5, 0);
INSERT INTO `admin_files` VALUES (51, 'tax_rates', 5, 0);
INSERT INTO `admin_files` VALUES (52, 'currencies', 6, 0);
INSERT INTO `admin_files` VALUES (53, 'languages', 6, 0);
INSERT INTO `admin_files` VALUES (54, 'orders_status', 6, 0);
INSERT INTO `admin_files` VALUES (55, 'stats_products_viewed', 7, 0);
INSERT INTO `admin_files` VALUES (56, 'stats_products_purchased', 7, 0);
INSERT INTO `admin_files` VALUES (57, 'stats_customers', 7, 0);
INSERT INTO `admin_files` VALUES (58, 'stats_products_lowstock', 7, 0);
INSERT INTO `admin_files` VALUES (59, 'stats_customers_referrals', 7, 0);
INSERT INTO `admin_files` VALUES (60, 'template_select', 8, 0);
INSERT INTO `admin_files` VALUES (61, 'layout_controller', 8, 0);
INSERT INTO `admin_files` VALUES (62, 'banner_manager', 8, 0);
INSERT INTO `admin_files` VALUES (63, 'mail', 8, 0);
INSERT INTO `admin_files` VALUES (64, 'newsletters', 8, 0);
INSERT INTO `admin_files` VALUES (65, 'server_info', 8, 0);
INSERT INTO `admin_files` VALUES (66, 'whos_online', 8, 0);
INSERT INTO `admin_files` VALUES (67, 'admin', 8, 0);
INSERT INTO `admin_files` VALUES (68, 'email_welcome', 8, 0);
INSERT INTO `admin_files` VALUES (69, 'store_manager', 8, 0);
INSERT INTO `admin_files` VALUES (82, 'ezpages', 8, 0);
INSERT INTO `admin_files` VALUES (70, 'developers_tool_kit', 8, 0);
INSERT INTO `admin_files` VALUES (71, 'define_pages_editor', 8, 0);
INSERT INTO `admin_files` VALUES (80, 'sqlpatch', 8, 0);
INSERT INTO `admin_files` VALUES (76, 'admin_control', 0, 1);
INSERT INTO `admin_files` VALUES (72, 'coupon_admin', 9, 0);
INSERT INTO `admin_files` VALUES (73, 'gv_queue', 9, 0);
INSERT INTO `admin_files` VALUES (74, 'gv_mail', 9, 0);
INSERT INTO `admin_files` VALUES (75, 'gv_sent', 9, 0);
INSERT INTO `admin_files` VALUES (83, 'record_artists', 10, 0);
INSERT INTO `admin_files` VALUES (84, 'record_company', 10, 0);
INSERT INTO `admin_files` VALUES (85, 'music_genre', 10, 0);
INSERT INTO `admin_files` VALUES (86, 'media_manager', 10, 0);
INSERT INTO `admin_files` VALUES (87, 'media_types', 10, 0);
#
# Create table structure for table `admin_allowed_pages`
#
DROP TABLE IF EXISTS `admin_allowed_pages`;
CREATE TABLE `admin_allowed_pages` (
`page_id` int(11) NOT NULL default '0',
`admin_id` int(11) NOT NULL default '0'
) TYPE=MyISAM;
#
# Insert data into table `admin_allowed_pages`
#
INSERT INTO `admin_allowed_pages` VALUES (1, 1);
INSERT INTO `admin_allowed_pages` VALUES (2, 1);
INSERT INTO `admin_allowed_pages` VALUES (3, 1);
INSERT INTO `admin_allowed_pages` VALUES (4, 1);
INSERT INTO `admin_allowed_pages` VALUES (5, 1);
INSERT INTO `admin_allowed_pages` VALUES (6, 1);
INSERT INTO `admin_allowed_pages` VALUES (7, 1);
INSERT INTO `admin_allowed_pages` VALUES (8, 1);
INSERT INTO `admin_allowed_pages` VALUES (9, 1);
INSERT INTO `admin_allowed_pages` VALUES (10, 1);
INSERT INTO `admin_allowed_pages` VALUES (11, 1);
INSERT INTO `admin_allowed_pages` VALUES (12, 1);
INSERT INTO `admin_allowed_pages` VALUES (13, 1);
INSERT INTO `admin_allowed_pages` VALUES (14, 1);
INSERT INTO `admin_allowed_pages` VALUES (15, 1);
INSERT INTO `admin_allowed_pages` VALUES (16, 1);
INSERT INTO `admin_allowed_pages` VALUES (17, 1);
INSERT INTO `admin_allowed_pages` VALUES (18, 1);
INSERT INTO `admin_allowed_pages` VALUES (19, 1);
INSERT INTO `admin_allowed_pages` VALUES (20, 1);
INSERT INTO `admin_allowed_pages` VALUES (21, 1);
INSERT INTO `admin_allowed_pages` VALUES (22, 1);
INSERT INTO `admin_allowed_pages` VALUES (23, 1);
INSERT INTO `admin_allowed_pages` VALUES (24, 1);
INSERT INTO `admin_allowed_pages` VALUES (25, 1);
INSERT INTO `admin_allowed_pages` VALUES (26, 1);
INSERT INTO `admin_allowed_pages` VALUES (27, 1);
INSERT INTO `admin_allowed_pages` VALUES (28, 1);
INSERT INTO `admin_allowed_pages` VALUES (29, 1);
INSERT INTO `admin_allowed_pages` VALUES (30, 1);
INSERT INTO `admin_allowed_pages` VALUES (31, 1);
INSERT INTO `admin_allowed_pages` VALUES (32, 1);
INSERT INTO `admin_allowed_pages` VALUES (33, 1);
INSERT INTO `admin_allowed_pages` VALUES (34, 1);
INSERT INTO `admin_allowed_pages` VALUES (35, 1);
INSERT INTO `admin_allowed_pages` VALUES (36, 1);
INSERT INTO `admin_allowed_pages` VALUES (37, 1);
INSERT INTO `admin_allowed_pages` VALUES (38, 1);
INSERT INTO `admin_allowed_pages` VALUES (39, 1);
INSERT INTO `admin_allowed_pages` VALUES (40, 1);
INSERT INTO `admin_allowed_pages` VALUES (41, 1);
INSERT INTO `admin_allowed_pages` VALUES (42, 1);
INSERT INTO `admin_allowed_pages` VALUES (43, 1);
INSERT INTO `admin_allowed_pages` VALUES (44, 1);
INSERT INTO `admin_allowed_pages` VALUES (45, 1);
INSERT INTO `admin_allowed_pages` VALUES (46, 1);
INSERT INTO `admin_allowed_pages` VALUES (47, 1);
INSERT INTO `admin_allowed_pages` VALUES (48, 1);
INSERT INTO `admin_allowed_pages` VALUES (49, 1);
INSERT INTO `admin_allowed_pages` VALUES (50, 1);
INSERT INTO `admin_allowed_pages` VALUES (51, 1);
INSERT INTO `admin_allowed_pages` VALUES (52, 1);
INSERT INTO `admin_allowed_pages` VALUES (53, 1);
INSERT INTO `admin_allowed_pages` VALUES (54, 1);
INSERT INTO `admin_allowed_pages` VALUES (55, 1);
INSERT INTO `admin_allowed_pages` VALUES (56, 1);
INSERT INTO `admin_allowed_pages` VALUES (57, 1);
INSERT INTO `admin_allowed_pages` VALUES (58, 1);
INSERT INTO `admin_allowed_pages` VALUES (59, 1);
INSERT INTO `admin_allowed_pages` VALUES (60, 1);
INSERT INTO `admin_allowed_pages` VALUES (61, 1);
INSERT INTO `admin_allowed_pages` VALUES (62, 1);
INSERT INTO `admin_allowed_pages` VALUES (63, 1);
INSERT INTO `admin_allowed_pages` VALUES (64, 1);
INSERT INTO `admin_allowed_pages` VALUES (65, 1);
INSERT INTO `admin_allowed_pages` VALUES (66, 1);
INSERT INTO `admin_allowed_pages` VALUES (67, 1);
INSERT INTO `admin_allowed_pages` VALUES (68, 1);
INSERT INTO `admin_allowed_pages` VALUES (69, 1);
INSERT INTO `admin_allowed_pages` VALUES (70, 1);
INSERT INTO `admin_allowed_pages` VALUES (71, 1);
INSERT INTO `admin_allowed_pages` VALUES (72, 1);
INSERT INTO `admin_allowed_pages` VALUES (73, 1);
INSERT INTO `admin_allowed_pages` VALUES (74, 1);
INSERT INTO `admin_allowed_pages` VALUES (75, 1);
INSERT INTO `admin_allowed_pages` VALUES (76, 1);
INSERT INTO `admin_allowed_pages` VALUES (77, 1);
INSERT INTO `admin_allowed_pages` VALUES (78, 1);
INSERT INTO `admin_allowed_pages` VALUES (79, 1);
INSERT INTO `admin_allowed_pages` VALUES (80, 1);
INSERT INTO `admin_allowed_pages` VALUES (81, 1);
INSERT INTO `admin_allowed_pages` VALUES (82, 1);
INSERT INTO `admin_allowed_pages` VALUES (83, 1);
INSERT INTO `admin_allowed_pages` VALUES (84, 1);
INSERT INTO `admin_allowed_pages` VALUES (85, 1);
INSERT INTO `admin_allowed_pages` VALUES (86, 1);
INSERT INTO `admin_allowed_pages` VALUES (87, 1);
INSERT INTO `admin_allowed_pages` VALUES (88, 1);
this missing table implies that the SQL patch hasn't been installed properly.Quote:
Originally Posted by aallenlenth
Just execute the drop table commands on their own from the SQL you posted. Beware though, if the Admin Profiles code that accesses those tables is still present, your Admin will fall over and die.Quote:
Originally Posted by MB1
KOH - Author of e_Start Your Web Store with Zen Cart - suggested I just restore the files that were changed - and WHALA - We are operational again.
I'll work w/o the admin profie MOD
aallen
Kuroi could you help me out. Ive ran into real huge problem. I forget clients password and restarted it through mysql in to admin admin. BUT now I cannot access anything due to admin profiles. Can I drop the whole admin_allowed_pages table? Im not really comfortable with sql so any help is greatly appreciated!
I've responded to your other thread.Quote:
Originally Posted by poosk
Is version Version: 1.0.7 compatible with Zen Cart 1.3.7?
What am I doing wrong with this mod,
Installed clean install 1.38a
copied and pasted install_admin_profiles.sql into the SQL Query Executor and send.
Copied the admin dir over the original admin dir on the server and also did this with the extras - patched files for ZC1.3.8a DIR.
Result: nothing changed in the admin setting page.
Result this morning: a blank admin settings page.
If somebody can give me directions I would be very glad.
After i have this working I also want to install easypopulate and dual_pricing_1.3.2.
is this posssible??
Thanx, Andre
Hard to say, it usually just works, did you check the files just to be sure they actually were copied to the server, look in db and be sure the extra tables and data are there.
did you try re uploading the files, perhaps something got corrupt during upload or in the wrong format, blank pages can sometimes mean that you have a bad file....
keep us posted.
for the other mods, not sure just do a backup and try, I have a test site just for that purpose
Quote:
Originally Posted by andre
I transfered the files one by one and I think its working now!!!
Thanx!!!!
Quote:
Originally Posted by kuroi
Reason being is that I Cant give it away, but for a small investment .......Quote:
Originally Posted by AndyII
if anyone is interested, I had the Admin mod revised (paid programming) to do full restrictions on category assignments, support for custom sales report, multiple owners for manufactures, ++++++++++ many things....
I see that here and other forums, it's a much wanted addition.
I am supposing that you are using Zen Cart - - How much did it cost you?Quote:
Reason being is that I Cant give it away, but for a small investment .......
I see that here and other forums, it's a much wanted addition.
The upstanding thing to do is to contribute back - - and in this case it might be something you paid for bet that others might benefit from much as you are most likely benefitting from Zen Cart
Installed and added IH2 Edited the image_handler_tools_dhtml.php xtra - box file as recommended.
IH2 frontend functioning but in admin > tools > it is not present
If I use the orig file it is present but then one can not access the selection
What did I miss?
image_handler_tools_dhtml.php file
Code:<?php
/**
* @package admin
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: image_handler_tools_dhtml.php - amended per Admin Profiles v-1.0.7
*/
if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');
}
$options = array( array('box' => BOX_TOOLS_IMAGE_HANDLER, 'page' => FILENAME_IMAGE_HANDLER)
);
foreach ($options as $key => $value)
if (page_allowed($value['page'])=='true')
$za_contents[] = array('text' => $value['box'], 'link' => zen_href_link($value['page'], '', 'NONSSL'));
?>
So.... if you invested say $400.00 and a great deal of time, You would give it away??, wow, you are an "upstanding" person
============
doesnt IH belong in the "other" thread?
Quote:
Originally Posted by kobra
I would, and have. Will giving it away hurt your bottom line? Was it developed with the intent of making money itself, or helping your store make money?
I guess all I can really say is I'm damn glad the Zen Cart developers and all the people uploading new mods don't think the way you do about it.
Do not know how upstanding I am but I contribute much time in posting to assist others and have invested much time in a few contributions that are Freely available just as Zen Cart is.Quote:
So.... if you invested say $400.00 and a great deal of time, You would give it away??, wow, you are an "upstanding" person
You may have invested time and $ into this, but so have the Devs of Zen Cart and they do not attempt to hijack you into paying to use it - Why not share?
Not when the question is about AdminProfiles and the box fileQuote:
doesnt IH belong in the "other" thread?
Hi,
I have installed the module. But I do not find any link in my admin menu?
Can you plz provide me manual or instructions to use this module. :oops:
i am not getting how can I make different admin and there permission? :cry:
thanks in advance.
Since the time that Kobra has invested helping people in this forum would be worth many times that sum even at minimum wage, the sarcasm seems misplaced.Quote:
Originally Posted by AndyII
In principle, I have no issues with professional developers creating commercial mods and charging them, provided that they comply with the GPL and they are prepared to maintain it, upgrade and provide a professional level of support to go with them. I'm not alone, the Free Software Federation encourages this too, seeing it as a way to improve the stock of freely available software.
However, if I understand correctly, you're not a professional developer and don't have the skills to provide support for the product that you are selling. Do you have an agreement in place to ensure support for your customers from the developer who did this work for you?
I also object to you cluttering up this support thread with crude attempts to market your commercial product.
If installed correctly then there is a 'new' selector - orange circle with a "P" in it in yourQuote:
Originally Posted by VINAYKANT
admin > tools > admin settings > area
Click it and a menu for permissions will be available
OK I have to post back and eat "crow":blush:Quote:
Originally Posted by KoBra
When setting permissions, there are many items in categories....
I religously checked each one and had the problem stated above....BUT...:oops:
In the Cat bar at the far left there is also a check box to enable the category....
And as you can surmise - this was not checked for the 3rd party modules....
Soooo while IH2 and others were checked individually the category they reside in was not....:bangin:
Hello,
I have installed this mod as per the install text file. No errors running the SQL or copying the files... now when I log on to the admin interface I get this:
1146 Table 'mydb.admin_menu_headers' doesn't exist
in:
[select id from admin_menu_headers where header = 'Configuration']
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.
What have I done wrong?
Cheers
Most probably you have a prefix - "mydb" and the SQL was not adjusted to add the prefixCode:Table 'mydb.admin_menu_headers' doesn't exist
Ok, I have installed this wonderful mod at least a dozen times. I am using 1.3.8a. Here is the problem, the admin navigation is still displaying. The "denied Page" does work for the options that are not checked, but all of the menu items are still present. I have install Admin Profiles 1.0.7.
I have been able to achieve the result of disappeared menus using ZC 1.3.7 and AP 1.0.6
Any help would be greatly appreciated
Could you look in your database (e.g. using phpMyAdmin) to see if you have an admin_menu_headers file there, or a file which has a prefix but ends that way? Similarly for admin_allowed_pages, admin_files and admin_visible_headers?Quote:
Originally Posted by megadood
Could you describe the contents of your admin_visible_headers database file?Quote:
Originally Posted by ptcdf
Hi Guys,
Many thanks for your help the error is now gone using the right prefix :)...
However problem two now is that even though i get no errors as far as i can see, there is no P under Admin Settings next to any admins i create... :huh: Any ideas?
aha fixed it now - forgot to apply the patch!...
thanks
This is the admin_menu_headers
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
I do also have admin_allowed_pages, admin_files and admin_visible_headers
My admin_visible_headers shows the numbers 1-10 id header_id with admin_id as 1
and header_id 1 with admin_id as 4
Hi Just wondering if anybody can help me please
I installed Admin Profiles mod and didnt realise that my admin id was 2 and not 1 so i was locked out of everything, I followed the info in the wiki section by sending the following with mysq
INSERT INTO `zen_admin_visible_headers` VALUES (8, 002)
INSERT INTO `zen_admin_allowed_pages` VALUES (67, 002)
After this i logged back into my site and could see the
Tools,Admin Settings and inside my admin user details , but when i clicked edit settings i get sent straight to the page saying
Sorry, your security clearance does not allow you to access this resource.
Please contact your site administrator if you believe this to be incorrect.
Sorry for any inconvenience.
Can anybody please help me :frusty:
Cheers
Mate2007
Try this too ...
INSERT INTO `zen_admin_allowed_pages` VALUES (76, 2);
Kuroi
Just to say a quick thank you, everythings ok now Phewww:laugh:
Cheers
Mate2007
i am running a french site, but mostly of the menus are handled with their english names by admin profiles. This is well and good. :clap:
But some menus are handled with their french names. In this case, they are considered as third party mods. Some of these items works without problems, but some others cannot be enabled by admin Profiles, and i cannot get access to it. I know, after reading the support threads, that A. P. doesn't support multi-lingual admin areas.
But i don't understand why some items works fine, and others not. All the items who don't work are from the Configuration menu.
My Store works, Minimum Values also (with their french names), Layout Settings, Customer Details not :frusty:.
Anybody has an idea?
Thank you for reading.
Risant
(zen-cart 1.3.8 // admin_profiles_v1_0_7)
Can anybody please point me in the right direction ?
risant
You are most likely going to have to get someone to look closely at how your language setup is constructed -Quote:
Originally Posted by risant
You can try the "commercial help" thread on this forum
I hope that this hasn't been covered in this thread, but I'm having an issue getting it to work. I've tried searching for as much as I can in here but haven't found an answer.
I'm using 1.3.8a and have downloaded the latest version of your mod. I've followed the instructions up until Step 3, then did the following, thinking it would be ok: Seeing as I hadn't altered the admin/admin.php file, I copied that across, then edited english.php as per the instructions and uploaded it.
Unfortunately I'm not getting the Permission icon to enable me to use this mod at all!
Is there likely to be something else that I've missed?
Any help would be greatly appreciated.
I've used this mod in the past and it's awesome!
Cheers.
the language setup :huh:Quote:
Originally Posted by kobra
This will be a bit tricky.
thank you for your answer
Have a good day
risant
Ok, scratch that, idiocy reigned this end. We were getting confused with which shop was which here, seeing as we have a few...
Very sorry (but I am glad it's all sorted!)
Cheer.
Hello
I decided to append the ability of choosing allowed product Categories. My aim is to create the restriction for admin, so he could see, manage and easyly add products and categories only in his own category, like moderators on forums. If anybody is being interested in such contribution, I will gladly post it to site when finish.
I added table "admin_allowed_categories" with columns "categories_id" & "admin_id" to the database and added similar with the native ones functions check_category and category_allowed. I also added row Categories with id 21 to "admin_menu_headers" table.
The first thing i've done was disabling disallowed Categories to show in Categories listing in Admin. That was done by verifing category id in the loop if it was allowed for current admin.
The question is: Am I on the right way, and how it could be done easier? Because there are many "selects" of products and categories in the admin files.
anafor
this is what I had coded, I needed to be able to restrict any admin to a manufacture and their associated categories.
took some time and money but it does work perfectly so far
AndyII, thank you for the reply.
Could you post it?
Or, at least give me some good advice how to do it myself?
I would be very appreciate to you.:smile:
Hello
I just want to announce, that i've finished coding the ability to add permissions for categories. It seems to work fine. If you are interested in it, I think you can get it soon throught download section. If not - mail me.)
anafor,
Thanks for sharing this as there is a select group of Zenners that have been wanting for something like this
Does this still exist.
I'm glad of making some contribution to the community:smile:
The latest version in the downloads section is 1.0.7
http://www.zen-cart.com/index.php?ma...products_id=86
The contribution has to be checked by administrator first. It is being done twice a week, as ZenCart team tells.
I'd better post it here too.
NOTE: This archive differs from that I've posted to the download section. This one has not critical bug fix.
:huh:
Code:#
# Create table structure for table `admin_allowed_categories`
#
DROP TABLE IF EXISTS `admin_allowed_categories`;
CREATE TABLE `admin_allowed_pages` (
`categories_id` int(11) NOT NULL default '0',
`admin_id` int(11) NOT NULL default '0'
) TYPE=MyISAM;
Today I've seen my post to download section:
1. It' s not a standalone version - I've just made some improvements of kuroi's version 1.0.7.
2. About the issue, that logged in Admin can see denied category by entering it's number to the browser's command line: admin\includes\init_includes\overrides\init_admin_auth.php fixes it.
I'd never want to discourage people from contributing to the Zen Cart community. Giving back in this way is admirable and I hope that you won't be discouraged. However, I have to disagree with both your statements aboveI don't see this as an improvement. Admin Profiles is very secure. Your extension to it is full of holes. This is most likely why the Zen Cart team have chosen to treat it as a separate mod. I'd recommend starting a separate support thread so that they can be dealt with without confusing support for the main mod.Quote:
Originally Posted by anafor
Unfortunately that only closes one route to access products outside of an admin's allowed categories. They can still access ANY product through other routes (I don't really want to discuss how on a public forum) and get at many products by simply using other Admin facilities.Quote:
Originally Posted by anafor
What you set out to do can be done. Earlier in this thread I listed all the files that needed to be changed to do it securely. But it's a lot of files and and it would mean that the resulting mod would clash with many others. In addition, the number of intrusions into core code would also make this very difficult and expensive to maintain.
I can see from what you did that your technical skills are sufficient to do this. You just need to give more thought to all the ways of accessing and editing products. However, unusually, I wouldn't recommend releasing it for general use, unless you are prepared to dedicate significant amounts of time to supporting other community members trying to use it.
believe i have found a problem. i have 1.3.8 running with admin profiles / privliges. after installing image handler it over rides the admin profiles mod.
With admin profile i am ment to be able to deny other admins access to areas and hide the unused buttons. This was working correct. After installing image handler all the buttons now show but still when clicked get the no access warning.
This makes the admin section very cluttered and not how i want it.
I am trying to install this mod in ZC 1.3.8.a, but I have the message
your securiy clearance....
I read the install.txt and so I have yet installed news box before
I have tried to do the instructions, but It doesn't go.
Also because in the file dhtml of news box, the part
It compares not $options, but
$za contest
and I don't have foreach...... in the dhtml of news box.
Someone know how I have to do?
I have to install now image handler and O solve the problem modifying that file?
:frusty:
I have solved I didn't yet installed the step 3 of install.txt so now it's ok.
Last thing, if I don't create a menu admin box is it the same thing? Or is it necessary?
I see all from admin>tools>admin settings
Thanks
:D
I could to request new function?
1. copy new permissions to new admin user from already user
2. no admin settings permissions, but can change self password
thanks! :smile:
Another idea, is to do a catch:
You have an init file catch the get string, then analyze it and refuses access if needed.
Quote:
Originally Posted by kuroi
If when installing other mods you over-write the Admin Profiles files then it will stop working, partially or completely. Though I puzzled as to how you would do that when installing Image Handler as that mostly adds rather than replaces existing files. But I would look carefully at your box files, as these are the ones that would have the efect that you describe.Quote:
Originally Posted by kitcorsa
If you don't adjust the box files as instructed users will still be restricted from visiting pages to which they are not supposed to have access, but they will see them in the menus as you will not have put in place the code to stop that.Quote:
Originally Posted by giuly
That can cover some of the restrictions needed, but to restrict access by category completely, it's still often necessary to turn off functions within specific pages, as the URLs available to the init file are often to general to enable them to be used as a filter.Quote:
Originally Posted by yellow1912
I'm not sure if you are aware, but there is a small bug in the latest versions' SQL patch.
Lines 268-276 read:
Line 273 should read:Code:#
# Create table structure for table `admin_allowed_categories`
#
DROP TABLE IF EXISTS `admin_allowed_categories`;
CREATE TABLE `admin_allowed_pages` (
`categories_id` int(11) NOT NULL default '0',
`admin_id` int(11) NOT NULL default '0'
) TYPE=MyISAM;
I've just installed this, and will be giving it a spin shortly.Code:CREATE TABLE `admin_allowed_categories` (
I think you must be referring to the Admin Users - Restrict Product Categories mod.Quote:
Originally Posted by mmand
This is the support thread for Admin Profiles which does not have the admin_allowed_categories table.
i pointed that out a while ago about the SQL patch......
isn't it ironic that after I had this developed for more restrictions, that someone would use an exact table name as I created?
seems suspicious , makes me wonder if someone is sharing stuff they shouldn't be sharing:oops:
Sorry, this was the support topic listed in the readme. I didn't realize the author of Admin Users hadn't changed any of that. :blush:Quote:
Originally Posted by kuroi
No problem. It was the author's intention that it would be an extension of this mod, but there were concerns over the extent to which it actually delivered what it set out to do, so it was moved of into a separate mod to keep it distinct from this one which is much more robust. Credit to you for taking the time to alert people to a problem and give a solution.Quote:
Originally Posted by mmand
The author of Admin Users and I have chatted about his mod and I'm pretty convinced that he is using code that he amended himself.Quote:
Originally Posted by AndyII
That said, I can't see any way that restrictions by category could be done properly without significant amendments to existing Zen Cart code, so if you are trying to restrict people from re-distributing your code, it either doesn't do the job properly or you are in violation of the GPL license.
Kuroi, what if we do something like this:
Of course we will have to change the algorithm of function page_allowed a bit, since we pass in the link, not the page.PHP Code:
<?php
/**
* @package admin
* @copyright Copyright 2003-2007 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: catalog_dhtml.php 6050 2007-03-24 03:20:50Z ajeh $
*/
if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');
}
$za_contents = array();
$za_heading = array('text' => BOX_HEADING_CATALOG, 'link' => zen_href_link(FILENAME_ALT_NAV, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_CATEGORIES_PRODUCTS, 'link' => zen_href_link(FILENAME_CATEGORIES, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_PRODUCT_TYPES, 'link' => zen_href_link(FILENAME_PRODUCT_TYPES, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_PRODUCTS_PRICE_MANAGER, 'link' => zen_href_link(FILENAME_PRODUCTS_PRICE_MANAGER, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_CATEGORIES_OPTIONS_NAME_MANAGER, 'link' => zen_href_link(FILENAME_OPTIONS_NAME_MANAGER, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_CATEGORIES_OPTIONS_VALUES_MANAGER, 'link' => zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_CATEGORIES_ATTRIBUTES_CONTROLLER, 'link' => zen_href_link(FILENAME_ATTRIBUTES_CONTROLLER, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_CATEGORIES_ATTRIBUTES_DOWNLOADS_MANAGER, 'link' => zen_href_link(FILENAME_DOWNLOADS_MANAGER, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_PRODUCT_OPTIONS_NAME, 'link' => zen_href_link(FILENAME_PRODUCTS_OPTIONS_NAME, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_PRODUCT_OPTIONS_VALUES, 'link' => zen_href_link(FILENAME_PRODUCTS_OPTIONS_VALUES, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_MANUFACTURERS, 'link' => zen_href_link(FILENAME_MANUFACTURERS, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_REVIEWS, 'link' => zen_href_link(FILENAME_REVIEWS, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_SPECIALS, 'link' => zen_href_link(FILENAME_SPECIALS, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_FEATURED, 'link' => zen_href_link(FILENAME_FEATURED, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_SALEMAKER, 'link' => zen_href_link(FILENAME_SALEMAKER, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_PRODUCTS_EXPECTED, 'link' => zen_href_link(FILENAME_PRODUCTS_EXPECTED, '', 'NONSSL'));
if ($za_dir = @dir(DIR_WS_BOXES . 'extra_boxes')) {
while ($zv_file = $za_dir->read()) {
if (preg_match('/catalog_dhtml.php$/', $zv_file)) {
require(DIR_WS_BOXES . 'extra_boxes/' . $zv_file);
}
}
$za_dir->close();
}
foreach ($za_contents as $key => $value) {
if (page_allowed($value['link'])!='true') unset($za_contents[$key] );
}
?>
<!-- catalog //-->
<?php
echo zen_draw_admin_box($za_heading, $za_contents);
?>
<!-- catalog_eof //-->
We will have to get the page from that link, which is easy.
The beauty of this, is that you dont have to edit any 3rd module box at all. And keep the modification of core code to the minimum.
If I understand correctly what you're suggesting the page_allowed algorithm would need to be expanded enormously.Quote:
Originally Posted by yellow1912
The approach that you're suggesting appears to be predicated on the idea that the $_GET variable contains the information needed to be able to determine whether an Admin User should be permitted to access a particular function.
There are two problems with this:
1. from an access control perspective we should be stopping users from attempting actions for which they don't have permission rather than rejecting those actions once taken; and
2. the information needed will often be part of an array in the $_POST variable, or worse, implicit in apparently unrelated information.
For example: if we were restricting users so that they could affect only products which they had originated (the most commoin reason for this request) we may want them to be able to create coupons for their products. Once there are coupons available they need to be maintained. This could mean increasing or decreasing the rate.
Obviously we don't want users playing with the discounts available for products that aren't theirs. But the coupon URLs don't give us the information necessary to make this determination so we would need new code in the allowed_pages algorithm to look-up the coupon and find out which products it applies to and then more code to find out whether these products are in permitted categories.
There are literally dozens of analagous examples spread through the Admin. So that algorithm would become very large and complex very quickly.
But even if we caught them all and the code worked, it would still be unsatisfactory since it users would not be prevented from browsing information containing products outside their category, and would experience frustrating rejections of actions that appeared to be legitimate and allowed.
No, not really.
Lets get back to what you have:
Basically, you the pass the 'page' into this function page_allowedPHP Code:$options = array( array( 'page' => FILENAME_REVIEWS, 'box' => BOX_CATALOG_REVIEWS),
Now, what if you accept the original array?
So, what I am saying is, in the case you will have to pass a already built link, so what you have to do is from that already built link, you have to get back FILENAME_REVIEWS, which is not hard.PHP Code:$za_contents[] = array('text' => BOX_CATALOG_REVIEWS, 'link' => zen_href_link(FILENAME_REVIEWS, '', 'NONSSL'));
So basically you dont change the algorithm of that function, but you add the piece of code that would get the 'page' back from the generated 'link'
Forgive me for not looking through 57 pages in this topic...I don't really have the time right now.Quote:
Originally Posted by kuroi
I was hoping you found a way to display a different index.php for restricted users. (RE: page 16ish.) I've tried playing with the code myself, but I know so little about ZenCart that nothing I did would change anything.
Thanks in advance.
Okie, kuroi, so I went ahead and made the changes, and it seems to work pretty well, here is what I do:
First, Go to the admin/includes/boxes, assuming all the files there are the original ones:
I overwrite configuration_dhtml.php using your file.
For the rest, I search for:
And add below:PHP Code:$za_dir->close();
}
Now I edit admin/includes/functions/admin_profiles.phpPHP Code:foreach ($za_contents as $key => $value) {
if (page_allowed($value['link'])!='true') unset($za_contents[$key]);
}
I search for:Add right above it:PHP Code:$page = strip_suffix($page,".php");
Done!PHP Code:if(strpos($page, HTTP_SERVER) !== false || strpos($page, HTTPS_SERVER) !== false){
$page = current(explode('?', end(explode('/', $page))));
}
Kuroi, I attach here I modified version, let me know what you think. All seem to work well, except 1 minor possible bug caused by me:
Under Extras, the first link seems to be blank, but when you click on it you will go to the admin profiles.
@yellow1912
I get it now. We were talking at cross-purposes.
The post to which you replied originally was about an attempt to restrict users to a particular categories or set of categories. The problem that you are attempting to resolve, is how to avoid the need for restructuring the box files - different but still a very worthy objective.
I've looked at your code, installed it up and given it a run out and I like it. There are two very good ideas in there that minimise the changes needed to the box files. However, following your lead, I think that we can do away with the final change too - a significant step forward in the ease of installation and use of this mod. I've some more changes and testing to do, but this is looking good.
:thumbsup:
I have an issue for which I'm hoping someone can offer suggestions: I'm working with a new 1.3.8 install - no mods or add-ons except Admin profiles. I first did an install of both on a local test server - no hitches at all - worked like a charm. I then installed them onto a shared host server. Except this time, on the public server install, when I log in and try to set permissions for a user profile and click "save changes", there's a pause and then i'm returned to the admin login page (essentially i get booted out). I can log back in and can verfiy that any permissions changes requested are lost instead of applied.
I've scoped around and all other admin functionality seems to be intact and unaffected - meaning i can add a new admin user, delete it, add / edit products, make other config changes etc, etc ....but only changes to an admin's permissions seem to cause the rejection. I verified that the tables were added to the database - and they seem to be in order and populated with the same data specified in the install script. I even removed and re-uploaded new admin profiles php files - to no avail.
I did notice that, on the problematic installation, that the Admin with admin_id = 1 was set with an admin_level = 0. This, when compared to my local install, was found to be different - my local admin_id 1 also had a admin_level = 1. I tried manually assigning this value from 0 to 1 but it seems to have had no effect. I still am booted as soon as I try to save permissions changes on this public server.
Any suggestions??
box files??Quote:
Originally Posted by kuroi
what would i been looking for?? this problem is on a fresh install of 1.3.8a and the only thing i have done is installed my template and installed IH and AP
IH and AP have no common files that are over writen. Its a wierd error!!!
Great! Cant wait to see the new version ^_^Quote:
Originally Posted by kuroi
No response to my earlier post for assistance so i've been attempting to resolve the issue myself - but to no avail. Sigh...:frusty:
What i've done: I've removed Zen cart entirely from my public host (including the database) and reinstalled fresh. This is a fresh 1.3.8a with the first and only mod installed is Admin Profiles 1.0.7. Not even a custom template, products, categories or anything - just ZC and AP straight from the "boxes" so to speak. The install of AP was followed to the letter - including the patch files.
ZC and it's Admin seems to work just fine - including the creation and editing of new admin users. However, every time i attempt to edit an admin's user permissions, i am just booted back to the admin login screen. Very frustrating.
The most frustrating thing about all this is that my localhost install works just fine - i just can't get AP to run on my shared hosts' server. Too bad because my primary interest in ZC was for the availability of AP.
Any assitance/suggestions would be greaty appreciated.
Is this when you try to enter the settings screen or when you try to save the results?Quote:
Originally Posted by stride-r
If it's the former, are you clicking in the yellow symbol or on the button? If you hover over either what URL appears in the box left hand corner of your browser?
No, it's not just a user error. :wink: This happens when i try to save any changes made to the permissions.Quote:
Originally Posted by kuroi
FYI - My admin account (id=1) shows full permissions already (everything is checked), a newly created test user however is a blank slate (which i believe is normal). When i try to save any newly assigned permissions for this test user, i get booted out. Same thing happens when i try to edit my own permissions.
I have a basic question on the admin profile install and I'm so green at this you will have to talk to me like I'm a toddler. Explain it. I have read and reread the instructions.
Here is where I am. I'm have backed up my databases. I see where it says to run the sql install. I go to zencart and tools>install sql patches
I am lost here. I see where I can upload the sql patch but do I put anything in the box where it says enter the query to be executed? Or do I just browse for the file and upload install_admin_profile.sql
next: I understand how to drop the admin file in the admin file on the ftp but do I do anything with the extra one? I don't know if anything has been done because I paid someone to install it for me. The version is 1.3.8a That being said i guess if I don't have it working right I need to drop the extras folder into admin ftp also....Right?:shocking:
At this point it should be working if I did the above correctly, am I right?
I asked about having the same person do this install for me but she wanted to charge me so I want to attempt this myself so I can save the money.
Hopefully y'all can instruct me better. Please....:unsure:
I just attempted to install this mod, and it's not working, as far as I can tell. I would see a difference in tools/admin settings if it had been successful, correct? I cannot figure out what I did wrong, I dropped the admin files in, and installed the sql patch. Any ideas?
so you dont see a round yellow icon with a Capital P in it?
and your admin ID is 1?
Quote:
Originally Posted by abcoombe
Exactly. My id is 1, and I can't see that image.
Nevermind, I had help figuring it out, and it's fixed now!
I just installed this mod and it seems to be working well, except for one thing. The TOOLS menu shows up for all users. I checked to be sure I used the included file and the proper records are in the database tables added, so i'm a little stumped on this. Anyone seen this before? Suggestions on what to check?
The user cannot actually access the functions in the sub-menus unless authorized, but they are still showing up.
Thanks,
Bah.... Never mind. Tripped up in my own shorts and lost the tools_dhtml file. Duh.
Hey Guys.
I'm having a major issue with Admin Profiles right now.
No matter what I do, a 3rd party mod (easy populate) shows up in the tools menu on all profiles. I have no idea why it's happening!!!!
Can anyone help, I'm desperate!
Thanks,
Tom
Have you followed the instructions about amending the 3rd party mod's box file so that Admin Profiles can recognize and exclude it?Quote:
Originally Posted by thomasharding
Yessum, I have.Quote:
Originally Posted by kuroi
Here is the original code for EasyPop:
PHP Code:$za_contents[] = array('text' => BOX_TOOLS_EASYPOPULATE, 'link' => zen_href_link(FILENAME_EASYPOPULATE, '', 'NONSSL'));
and what I've amended it to:
Have I done this correctly?PHP Code:if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');
}
$options = array(
array('text' => BOX_CATALOG_EASYPOPULATE, 'link' => zen_href_link(FILENAME_EASYPOPULATE, '', 'NONSSL'))
);
foreach ($options as $key => $value)
if (page_allowed($value['page'])=='true') $za_contents[] = array('text' => $value['box'], 'link' => zen_href_link($value['page'], '', 'NONSSL'));
It's been blind panic trying to get this sorted, so I probably haven't :wacko:
Sounds like a deep breath and a careful checking of your options array is needed. 'text' should be 'box' and 'link' should be 'page'.Quote:
Originally Posted by thomasharding
Thankyou sir, you are an utter saint :)Quote:
Originally Posted by kuroi
Thanks for the module too, along with Easy Pop, Admin Profiles is the most essential addon released for Zen Cart. Gotta keep those pesky customers from destroying their store!
Hello,
I created a new admin and gave him access to the customer orders.
Is it possible to restrict the access so that he can see only the orders with a specific status? For instance, only delivered orders.
Thank you,
Jessica
Not using Admin Profiles. The mod restricts which pages an admin user can see, but doesn't interfer with the content on those pages.Quote:
Originally Posted by jessica_a
Thank you Kuroi for your very quick answer!
Do you know if there is any other add-on that can restrict the admin user access to some specific orders?
Always open to correction, but I don't believe that there is one.Quote:
Originally Posted by jessica_a
I thought I had done everything correctly according to the install readme; however when I attempt to access the cart's admin panel now, I get the following error:
1146 Table 'villacol_zen2db.admin_visible_headers' doesn't exist
in:
[select admin_id from admin_visible_headers where header_id = '1']
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.
I searched the forums for this error, but it returned a ton of unrelated threads and posts. I googled it as well and found:
http://www.zen-cart.com/wiki/index.p...Admin_Profiles
specifically: "This usually indicates that your user ID is something other than 1. Admin Profiles installs a full set of accesses for one user only and by default that user has ID 1. You have two options: either use phpMyAdmin to change your user ID to 1 and then close down all browser windows to end your session and remove all traces of you having been something else, or run the following script using a utility such as phpMyAdmin"
Now, I used my very limited SQL experience, I opened up the DB and checked the tables. As best as I can tell, my admin ID is a value of 1. I do not know if that is the same thing as "user ID" referenced in the above quote; however, I couldn't find a table with an entry for just "user ID".
I am totally lost. Fortunately, this is a secondary cart with nothing outside of the stock install so far, so if I have to reinstall, that is an option; but I'd really like to figure out what I did wrong now, as I was planning on using this mod on my live and populated cart.
Any help would be greatly appreciated!
Thanks in advance :)
Strange that your google search didn't direct you to this entry on the same wiki page that you reference aboveQuote:
Originally Posted by bstrange
Although that's not widely helpful, this is because the wiki can't know how you attempted to install the SQL patch. If you could provide some more details, maybe we ca work out why it didn't work for you.Quote:
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[sic] SQL.
Actually, I went to admin>tools and chose the sql patch update, then pasted the text from install_admin_profiles.sql, specifically
seeing how I can no longer get to admin>tools, I am not sure how I can fix this now.Code:# Admin Profiles
# version 1.0
#
# SQL to initialise user with admin_id = 1 for Admin Profiles
# -----------------------------------------------------------
#
# Create table structure for table `admin_menu_headers`
#
DROP TABLE IF EXISTS `admin_menu_headers`;
CREATE TABLE `admin_menu_headers` (
`id` int(11) NOT NULL,
`header` varchar(16) NOT NULL default '',
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;
#
# Insert data into table `admin_menu_headers`
#
INSERT INTO `admin_menu_headers` VALUES (0, 'Third Party Mods');
INSERT INTO `admin_menu_headers` VALUES (1, 'Configuration');
INSERT INTO `admin_menu_headers` VALUES (2, 'Catalog');
INSERT INTO `admin_menu_headers` VALUES (3, 'Modules');
INSERT INTO `admin_menu_headers` VALUES (4, 'Customers');
INSERT INTO `admin_menu_headers` VALUES (5, 'Taxes');
INSERT INTO `admin_menu_headers` VALUES (6, 'Localization');
INSERT INTO `admin_menu_headers` VALUES (7, 'Reports');
INSERT INTO `admin_menu_headers` VALUES (8, 'Tools');
INSERT INTO `admin_menu_headers` VALUES (9, 'GV_Admin');
INSERT INTO `admin_menu_headers` VALUES (10, 'Extras');
#
# Create table structure for table `admin_visible_headers`
#
DROP TABLE IF EXISTS `admin_visible_headers`;
CREATE TABLE `admin_visible_headers` (
`header_id` int(11) NOT NULL default '0',
`admin_id` int(11) NOT NULL default '0'
) TYPE=MyISAM;
#
# Insert data into table `admin_visible_headers`
#
INSERT INTO `admin_visible_headers` VALUES (1, 1);
INSERT INTO `admin_visible_headers` VALUES (2, 1);
INSERT INTO `admin_visible_headers` VALUES (3, 1);
INSERT INTO `admin_visible_headers` VALUES (4, 1);
INSERT INTO `admin_visible_headers` VALUES (5, 1);
INSERT INTO `admin_visible_headers` VALUES (6, 1);
INSERT INTO `admin_visible_headers` VALUES (7, 1);
INSERT INTO `admin_visible_headers` VALUES (8, 1);
INSERT INTO `admin_visible_headers` VALUES (9, 1);
INSERT INTO `admin_visible_headers` VALUES (10, 1);
#
# Create table structure for table `admin_files`
#
DROP TABLE IF EXISTS `admin_files`;
CREATE TABLE `admin_files` (
`id` int(11) NOT NULL auto_increment,
`page` varchar(64) NOT NULL default '',
`header` tinyint(4) NOT NULL default 0,
`submenu` tinyint(1) NOT NULL default 0,
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;
#
# Insert data into table `admin_files`
#
INSERT INTO `admin_files` VALUES (1, 'My Store', 1, 0);
INSERT INTO `admin_files` VALUES (2, 'Minimum Values', 1, 0);
INSERT INTO `admin_files` VALUES (3, 'Maximum Values', 1, 0);
INSERT INTO `admin_files` VALUES (4, 'Images', 1, 0);
INSERT INTO `admin_files` VALUES (5, 'Customer Details', 1, 0);
INSERT INTO `admin_files` VALUES (6, 'Shipping/Packaging', 1, 0);
INSERT INTO `admin_files` VALUES (7, 'Product Listing', 1, 0);
INSERT INTO `admin_files` VALUES (8, 'Stock', 1, 0);
INSERT INTO `admin_files` VALUES (9, 'Logging', 1, 0);
INSERT INTO `admin_files` VALUES (10, 'E-Mail Options', 1, 0);
INSERT INTO `admin_files` VALUES (11, 'Attribute Settings', 1, 0);
INSERT INTO `admin_files` VALUES (12, 'GZip Compression', 1, 0);
INSERT INTO `admin_files` VALUES (13, 'Sessions', 1, 0);
INSERT INTO `admin_files` VALUES (14, 'Regulations', 1, 0);
INSERT INTO `admin_files` VALUES (15, 'GV Coupons', 1, 0);
INSERT INTO `admin_files` VALUES (16, 'Credit Cards', 1, 0);
INSERT INTO `admin_files` VALUES (17, 'Product Info', 1, 0);
INSERT INTO `admin_files` VALUES (18, 'Layout Settings', 1, 0);
INSERT INTO `admin_files` VALUES (19, 'Website Maintenance', 1, 0);
INSERT INTO `admin_files` VALUES (20, 'New Listing', 1, 0);
INSERT INTO `admin_files` VALUES (21, 'Featured Listing', 1, 0);
INSERT INTO `admin_files` VALUES (22, 'All Listing', 1, 0);
INSERT INTO `admin_files` VALUES (23, 'Index Listing', 1, 0);
INSERT INTO `admin_files` VALUES (24, 'Define Page Status', 1, 0);
INSERT INTO `admin_files` VALUES (81, 'EZ-Pages Settings', 1, 0);
INSERT INTO `admin_files` VALUES (25, 'categories', 2, 0);
INSERT INTO `admin_files` VALUES (26, 'product_types', 2, 0);
INSERT INTO `admin_files` VALUES (27, 'products_price_manager', 2, 0);
INSERT INTO `admin_files` VALUES (28, 'options_name_manager', 2, 0);
INSERT INTO `admin_files` VALUES (29, 'options_values_manager', 2, 0);
INSERT INTO `admin_files` VALUES (30, 'attributes_controller', 2, 0);
INSERT INTO `admin_files` VALUES (31, 'downloads_manager', 2, 0);
INSERT INTO `admin_files` VALUES (32, 'option_name', 2, 0);
INSERT INTO `admin_files` VALUES (33, 'option_values', 2, 0);
INSERT INTO `admin_files` VALUES (34, 'manufacturers', 2, 0);
INSERT INTO `admin_files` VALUES (35, 'reviews', 2, 0);
INSERT INTO `admin_files` VALUES (36, 'specials', 2, 0);
INSERT INTO `admin_files` VALUES (37, 'featured', 2, 0);
INSERT INTO `admin_files` VALUES (38, 'salemaker', 2, 0);
INSERT INTO `admin_files` VALUES (39, 'products_expected', 2, 0);
INSERT INTO `admin_files` VALUES (88, 'products_to_categories', 2, 1);
INSERT INTO `admin_files` VALUES (40, 'modulesset=payment', 3, 0);
INSERT INTO `admin_files` VALUES (41, 'modulesset=shipping', 3, 0);
INSERT INTO `admin_files` VALUES (42, 'modulesset=ordertotal', 3, 0);
INSERT INTO `admin_files` VALUES (43, 'customers', 4, 0);
INSERT INTO `admin_files` VALUES (44, 'orders', 4, 0);
INSERT INTO `admin_files` VALUES (45, 'group_pricing', 4, 0);
INSERT INTO `admin_files` VALUES (46, 'paypal', 4, 0);
INSERT INTO `admin_files` VALUES (78, 'invoice', 4, 1);
INSERT INTO `admin_files` VALUES (79, 'packingslip', 4, 1);
INSERT INTO `admin_files` VALUES (47, 'countries', 5, 0);
INSERT INTO `admin_files` VALUES (48, 'zones', 5, 0);
INSERT INTO `admin_files` VALUES (49, 'geo_zones', 5, 0);
INSERT INTO `admin_files` VALUES (50, 'tax_classes', 5, 0);
INSERT INTO `admin_files` VALUES (51, 'tax_rates', 5, 0);
INSERT INTO `admin_files` VALUES (52, 'currencies', 6, 0);
INSERT INTO `admin_files` VALUES (53, 'languages', 6, 0);
INSERT INTO `admin_files` VALUES (54, 'orders_status', 6, 0);
INSERT INTO `admin_files` VALUES (55, 'stats_products_viewed', 7, 0);
INSERT INTO `admin_files` VALUES (56, 'stats_products_purchased', 7, 0);
INSERT INTO `admin_files` VALUES (57, 'stats_customers', 7, 0);
INSERT INTO `admin_files` VALUES (58, 'stats_products_lowstock', 7, 0);
INSERT INTO `admin_files` VALUES (59, 'stats_customers_referrals', 7, 0);
INSERT INTO `admin_files` VALUES (60, 'template_select', 8, 0);
INSERT INTO `admin_files` VALUES (61, 'layout_controller', 8, 0);
INSERT INTO `admin_files` VALUES (62, 'banner_manager', 8, 0);
INSERT INTO `admin_files` VALUES (63, 'mail', 8, 0);
INSERT INTO `admin_files` VALUES (64, 'newsletters', 8, 0);
INSERT INTO `admin_files` VALUES (65, 'server_info', 8, 0);
INSERT INTO `admin_files` VALUES (66, 'whos_online', 8, 0);
INSERT INTO `admin_files` VALUES (67, 'admin', 8, 0);
INSERT INTO `admin_files` VALUES (68, 'email_welcome', 8, 0);
INSERT INTO `admin_files` VALUES (69, 'store_manager', 8, 0);
INSERT INTO `admin_files` VALUES (82, 'ezpages', 8, 0);
INSERT INTO `admin_files` VALUES (70, 'developers_tool_kit', 8, 0);
INSERT INTO `admin_files` VALUES (71, 'define_pages_editor', 8, 0);
INSERT INTO `admin_files` VALUES (80, 'sqlpatch', 8, 0);
INSERT INTO `admin_files` VALUES (76, 'admin_control', 0, 1);
INSERT INTO `admin_files` VALUES (72, 'coupon_admin', 9, 0);
INSERT INTO `admin_files` VALUES (73, 'gv_queue', 9, 0);
INSERT INTO `admin_files` VALUES (74, 'gv_mail', 9, 0);
INSERT INTO `admin_files` VALUES (75, 'gv_sent', 9, 0);
INSERT INTO `admin_files` VALUES (83, 'record_artists', 10, 0);
INSERT INTO `admin_files` VALUES (84, 'record_company', 10, 0);
INSERT INTO `admin_files` VALUES (85, 'music_genre', 10, 0);
INSERT INTO `admin_files` VALUES (86, 'media_manager', 10, 0);
INSERT INTO `admin_files` VALUES (87, 'media_types', 10, 0);
#
# Create table structure for table `admin_allowed_pages`
#
DROP TABLE IF EXISTS `admin_allowed_pages`;
CREATE TABLE `admin_allowed_pages` (
`page_id` int(11) NOT NULL default '0',
`admin_id` int(11) NOT NULL default '0'
) TYPE=MyISAM;
#
# Insert data into table `admin_allowed_pages`
#
INSERT INTO `admin_allowed_pages` VALUES (1, 1);
INSERT INTO `admin_allowed_pages` VALUES (2, 1);
INSERT INTO `admin_allowed_pages` VALUES (3, 1);
INSERT INTO `admin_allowed_pages` VALUES (4, 1);
INSERT INTO `admin_allowed_pages` VALUES (5, 1);
INSERT INTO `admin_allowed_pages` VALUES (6, 1);
INSERT INTO `admin_allowed_pages` VALUES (7, 1);
INSERT INTO `admin_allowed_pages` VALUES (8, 1);
INSERT INTO `admin_allowed_pages` VALUES (9, 1);
INSERT INTO `admin_allowed_pages` VALUES (10, 1);
INSERT INTO `admin_allowed_pages` VALUES (11, 1);
INSERT INTO `admin_allowed_pages` VALUES (12, 1);
INSERT INTO `admin_allowed_pages` VALUES (13, 1);
INSERT INTO `admin_allowed_pages` VALUES (14, 1);
INSERT INTO `admin_allowed_pages` VALUES (15, 1);
INSERT INTO `admin_allowed_pages` VALUES (16, 1);
INSERT INTO `admin_allowed_pages` VALUES (17, 1);
INSERT INTO `admin_allowed_pages` VALUES (18, 1);
INSERT INTO `admin_allowed_pages` VALUES (19, 1);
INSERT INTO `admin_allowed_pages` VALUES (20, 1);
INSERT INTO `admin_allowed_pages` VALUES (21, 1);
INSERT INTO `admin_allowed_pages` VALUES (22, 1);
INSERT INTO `admin_allowed_pages` VALUES (23, 1);
INSERT INTO `admin_allowed_pages` VALUES (24, 1);
INSERT INTO `admin_allowed_pages` VALUES (25, 1);
INSERT INTO `admin_allowed_pages` VALUES (26, 1);
INSERT INTO `admin_allowed_pages` VALUES (27, 1);
INSERT INTO `admin_allowed_pages` VALUES (28, 1);
INSERT INTO `admin_allowed_pages` VALUES (29, 1);
INSERT INTO `admin_allowed_pages` VALUES (30, 1);
INSERT INTO `admin_allowed_pages` VALUES (31, 1);
INSERT INTO `admin_allowed_pages` VALUES (32, 1);
INSERT INTO `admin_allowed_pages` VALUES (33, 1);
INSERT INTO `admin_allowed_pages` VALUES (34, 1);
INSERT INTO `admin_allowed_pages` VALUES (35, 1);
INSERT INTO `admin_allowed_pages` VALUES (36, 1);
INSERT INTO `admin_allowed_pages` VALUES (37, 1);
INSERT INTO `admin_allowed_pages` VALUES (38, 1);
INSERT INTO `admin_allowed_pages` VALUES (39, 1);
INSERT INTO `admin_allowed_pages` VALUES (40, 1);
INSERT INTO `admin_allowed_pages` VALUES (41, 1);
INSERT INTO `admin_allowed_pages` VALUES (42, 1);
INSERT INTO `admin_allowed_pages` VALUES (43, 1);
INSERT INTO `admin_allowed_pages` VALUES (44, 1);
INSERT INTO `admin_allowed_pages` VALUES (45, 1);
INSERT INTO `admin_allowed_pages` VALUES (46, 1);
INSERT INTO `admin_allowed_pages` VALUES (47, 1);
INSERT INTO `admin_allowed_pages` VALUES (48, 1);
INSERT INTO `admin_allowed_pages` VALUES (49, 1);
INSERT INTO `admin_allowed_pages` VALUES (50, 1);
INSERT INTO `admin_allowed_pages` VALUES (51, 1);
INSERT INTO `admin_allowed_pages` VALUES (52, 1);
INSERT INTO `admin_allowed_pages` VALUES (53, 1);
INSERT INTO `admin_allowed_pages` VALUES (54, 1);
INSERT INTO `admin_allowed_pages` VALUES (55, 1);
INSERT INTO `admin_allowed_pages` VALUES (56, 1);
INSERT INTO `admin_allowed_pages` VALUES (57, 1);
INSERT INTO `admin_allowed_pages` VALUES (58, 1);
INSERT INTO `admin_allowed_pages` VALUES (59, 1);
INSERT INTO `admin_allowed_pages` VALUES (60, 1);
INSERT INTO `admin_allowed_pages` VALUES (61, 1);
INSERT INTO `admin_allowed_pages` VALUES (62, 1);
INSERT INTO `admin_allowed_pages` VALUES (63, 1);
INSERT INTO `admin_allowed_pages` VALUES (64, 1);
INSERT INTO `admin_allowed_pages` VALUES (65, 1);
INSERT INTO `admin_allowed_pages` VALUES (66, 1);
INSERT INTO `admin_allowed_pages` VALUES (67, 1);
INSERT INTO `admin_allowed_pages` VALUES (68, 1);
INSERT INTO `admin_allowed_pages` VALUES (69, 1);
INSERT INTO `admin_allowed_pages` VALUES (70, 1);
INSERT INTO `admin_allowed_pages` VALUES (71, 1);
INSERT INTO `admin_allowed_pages` VALUES (72, 1);
INSERT INTO `admin_allowed_pages` VALUES (73, 1);
INSERT INTO `admin_allowed_pages` VALUES (74, 1);
INSERT INTO `admin_allowed_pages` VALUES (75, 1);
INSERT INTO `admin_allowed_pages` VALUES (76, 1);
INSERT INTO `admin_allowed_pages` VALUES (77, 1);
INSERT INTO `admin_allowed_pages` VALUES (78, 1);
INSERT INTO `admin_allowed_pages` VALUES (79, 1);
INSERT INTO `admin_allowed_pages` VALUES (80, 1);
INSERT INTO `admin_allowed_pages` VALUES (81, 1);
INSERT INTO `admin_allowed_pages` VALUES (82, 1);
INSERT INTO `admin_allowed_pages` VALUES (83, 1);
INSERT INTO `admin_allowed_pages` VALUES (84, 1);
INSERT INTO `admin_allowed_pages` VALUES (85, 1);
INSERT INTO `admin_allowed_pages` VALUES (86, 1);
INSERT INTO `admin_allowed_pages` VALUES (87, 1);
INSERT INTO `admin_allowed_pages` VALUES (88, 1);
Do you need any other information? I'm not that familiar with either sql or zen cart addons, in fact this is the first one I have tried to do anything with (probably a good thing :blink:)
Thanks for the quick response!
and you are correct, there is no admin_visable_headers table in the DB, I just checked :no:
Do you have an "admin" table? If not, do you have a table with a similar name such as "zen_admin"?
In your admin/includes/configure.php file what are the defined values of these two fields?
Do not post any other information from this file!!Quote:
define('DB_PREFIX', ??????);
...
define('DB_DATABASE', ??????);
In Admin > Tools > Install SQL Patch did any error messages appear at the top of the page when you clicked on the "send" button?