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

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
in:
[select admin_name from admin where admin_id = ]
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 about this prolem
when I try to change the interface of the language

tyw71:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
in:
[select admin_name from admin where admin_id = ]
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 about this prolem
when I try to change the interface of the languagePlease could you provide the following information.

Which version of Admin Profiles are you using?
Which version of Zen Cart are you running?
Does your PHP environment have registers_global set on or off?
How have your tried to change your language interface and do you mean the interface in the shop or the one in the Admin area?
What had you done immediately prior to getting this messgae?

kuroi:

Please could you provide the following information.

Which version of Admin Profiles are you using?
Which version of Zen Cart are you running?
Does your PHP environment have registers_global set on or off?
How have your tried to change your language interface and do you mean the interface in the shop or the one in the Admin area?
What had you done immediately prior to getting this messgae?

I have used the lastest admin profiles
my zencart vestion is 1.3.1 and update to 1.3.2 now
registers_global set on
interface in the Admin area
now any

it work well when i selet tools- admin setting-edit permission

tyw71:

I have used the lastest admin profiles
my zencart vestion is 1.3.1 and update to 1.3.2 now
registers_global set on
interface in the Admin area
now any

it work well when i selet tools- admin setting-edit permissionRegister_global set to on can cause problems generally, but I don't think that it is the cause of this one.

Which language pack have you installed?

By "now any" do you mean that the problem occurs as soon as you enter the Admin area?

You say that "it works well when i selet tools- admin setting-edit permission". This is Admin Profiles. Are you saying that Admin Profiles works, but the rest of Admin doesn't?

In which order did you install the language pack and Admin Profiles and when did the problem first appear?

it works well, but when I click to other language, it shows the problem

I have a quick question about the Admin Profiles contrib.

I have a client that does corporate catalogs for multiple businesses, the type of thing where you get jackets, shirts, mugs, etc. with their logo on it. For simplicity I will call my client "Printer" and my client's clients "Clients". Printer would like me to setup the (web)site so that when Clients' employees wish to order something from their corporate catalog they can, then it generates an e-mail that requires an approval from somewhere within the Clients' business. Upon approval Printer will get the order and can begin the fulfillment. Printer owns the domain and catalog sites, and charges a monthly service fee for each Clients' own catalog.

For admin level I see myself (Contracted Webmaster) as the main full admin. Printer would be able maintain the catalog and pricing, and receive approved orders. If Printer needs it they should also be able to maintain the payment system for the orders, but at this time I don't know it payment will be made through the cart or invoiced separately. Client should be able to have regular users, and a person that can review and approve orders. The Client approval person should get notification of orders.

I will be setting this up with a single hosting location, each Client would have it's own Zencart installed in a separate folder with it's own subdomain. All the catalogs look the same save some branding for each Client, and each one would have it's own separate database.

So my question is, Is the Admin Profiles contrib what I am looking for to do this? How should I best set this up? If the Admin Profiles contrib is not what I am looking for (or only part of it,) could you please point me to something that will do what I need?

Thank you very much for your assistance.

Quick question. I installed this mod under 1.3.02 today, with Super Orders and with Image Handler 2. So far everything works except for one little issue.

If I go into the Coupon editor and click the 'Restrictions' button, none of my admins have permission. Even if they have every single item checked in the permissions dialog.

Any ideas?

Thanks!

tyw71

I have now reproduced your problem and I see what you mean. If you wish to change languages, I recommend leaving the Admin Profiles screen first. Changing language. Then returning.

Sadly though, it probably won't do you much good, as Admin Profiles is resolutely monolingual. I could allow the internationalisation of the header text and pick up other language alternatives for the configuration menu. However, the majority of the text on the page is derived from the names of the executable files that make up Admin, so to make it multilingual a large number of files and all calls to them would have to be re-named, and keep being re-named with each new release of Zen Cart.

As the the error message, I'm going to leave the bug in there. As changing language brings no benefits, taking away the error message would do no more than you could do by clicking on your broiwser's back button. Not a great solution I know, but happily it will only be an issue for a limited period of time.

This is because the Zen Cart Admin area is due for a re-write in release 1.6. Hopefully the Zen Cart team will be taking the need for a user access system into account - I will certainly be encouraging them to - and if it is done as part of core Zen Cart it will be much easier to deal with issues like the one that you have raised.

T313C0mun1s7:

I have a quick question about the Admin Profiles contrib.

I have a client that does corporate catalogs for multiple businesses, the type of thing where you get jackets, shirts, mugs, etc. with their logo on it. For simplicity I will call my client "Printer" and my client's clients "Clients". Printer would like me to setup the (web)site so that when Clients' employees wish to order something from their corporate catalog they can, then it generates an e-mail that requires an approval from somewhere within the Clients' business. Upon approval Printer will get the order and can begin the fulfillment. Printer owns the domain and catalog sites, and charges a monthly service fee for each Clients' own catalog.

For admin level I see myself (Contracted Webmaster) as the main full admin. Printer would be able maintain the catalog and pricing, and receive approved orders. If Printer needs it they should also be able to maintain the payment system for the orders, but at this time I don't know it payment will be made through the cart or invoiced separately. Client should be able to have regular users, and a person that can review and approve orders. The Client approval person should get notification of orders.

I will be setting this up with a single hosting location, each Client would have it's own Zencart installed in a separate folder with it's own subdomain. All the catalogs look the same save some branding for each Client, and each one would have it's own separate database.

So my question is, Is the Admin Profiles contrib what I am looking for to do this? How should I best set this up? If the Admin Profiles contrib is not what I am looking for (or only part of it,) could you please point me to something that will do what I need?

Thank you very much for your assistance.There's not much quick about this question :smile: but I'll try not to make the answer overly long.

Your question breaks down into two parts. Can you restrict access to certain functions by user? and can you have orders placed in a pending state awaiting authorisation by an administrator (albeit one with limited access to the system)?

The answers in summary are yes and yes :thumbsup:

Once you have decided how payments will work, you will need to install an appropriate payment module on each Cart. This payment module will have a Set Order Status field which is the default order status when a purchase is made using that payment module, and one of the values is pending.

Admin Profiles will allow you to define users who only have access to certain menus and screens, such as those necessary to move an order from pending to the processing state. Presumably Printer's staff would move the status to shipped. I expect that these statii could be renamed fairly easily if needed.

The only bit I am not sure about is sending an email to the clients' authorisers when an order is placed. You may wish to post a separate question on this to attract the attention of somebody with more knowledge in this area that me. In the meantime my 2 cents worth is that there may not be email such as you want generated at the moment; but there is a confirmation sent to the user who placed the order. If all users where set up with the email of the person who needs to authorize the order, then they would receive the notification that you want. Alternatively, adding a bit of extra code to duplicate the confirmation email to a specified authorizers's address would not be too difficult.

Shawn Parr:

Quick question. I installed this mod under 1.3.02 today, with Super Orders and with Image Handler 2. So far everything works except for one little issue.

If I go into the Coupon editor and click the 'Restrictions' button, none of my admins have permission. Even if they have every single item checked in the permissions dialog.

Any ideas?

Thanks!Can you post the code from the following files: super_orders_customers_dhtml.php and super_orders_reports_dhtml.php. You'll find them in your admin/includes/boxes/extra_boxes folder.

Sure can:

super_orders_reports_dhtml.php (modified version after installing your mod)

<?php /** Truncated for brevity */ if (!defined('IS_ADMIN_FLAG')) { die('Illegal Access'); } $options = array( array('box' => BOX_REPORTS_SUPER_AWAIT_PAY_REPORTS, 'page' => FILENAME_SUPER_AWAIT_PAY_REPORT), array('box' => BOX_REPORTS_SUPER_CASH_REPORT, 'page' => FILENAME_SUPER_CASH_REPORT) ); foreach ($options as $key => $value) if (page_allowed($value['page'])=='true') $za_contents[] = array('text' => $value['box'], 'link' => zen_href_link($value['page'], '', 'NONSSL')); ?>

super_orders_customers_dhtml.php (modified version after installing your mod)

<?php /** truncated 2006-04-17 by kuroi */ if (!defined('IS_ADMIN_FLAG')) { die('Illegal Access'); } $options = array( array('box' => BOX_CUSTOMERS_SUPER_ORDERS, 'page' => FILENAME_SUPER_ORDERS), array('box' => BOX_CUSTOMERS_SUPER_BATCH_STATUS, 'page' => FILENAME_SUPER_BATCH_STATUS), array('box' => BOX_CUSTOMERS_SUPER_BATCH_FORMS, 'page' => FILENAME_SUPER_BATCH_FORMS) ); foreach ($options as $key => $value) if (page_allowed($value['page'])=='true') $za_contents[] = array('text' => $value['box'], 'link' => zen_href_link($value['page'], '', 'NONSSL')); ?>

TIA!

kuroi, thank you for your reply.

kuroi:

Your question breaks down into two parts...
The answers in summary are yes and yes :thumbsup:
I was not even sure of that, so defining how it would break down was immensely helpful.

kuroi:

Once you have decided how payments will work, you will need to install an appropriate payment module on each Cart...
It seems that payment will not be handled by the carting system, and will be handled separately. They currently HATE their custom programmed cart, but it does not require any updating of status. I think all the status updates are going to require someone to log in and do so. I really hope this extra effort does not turn into a problem.

kuroi:

The only bit I am not sure about is sending an email to the clients' authorizers when an order is placed...
Thank you again. I will have to work on this one I guess, as without a notification the person doing the authorization does not know there is anything to authorize.

Thank you one again for your help.

Update: Okay, I just went back into the Admin Settings to enable a new mod I just installed and now coupon restrictions shows up in there under 3rd party. I swear it wasn't there before!:wacko:

All is good now though. Thanks for the help, and the great mod! :laugh:

Shawn Parr:

Update: Okay, I just went back into the Admin Settings to enable a new mod I just installed and now coupon restrictions shows up in there under 3rd party. I swear it wasn't there before!:wacko:

All is good now though. Thanks for the help, and the great mod! :laugh:

:D

its okay, shawn! i'm also facing the same problem last time...

Shawn Parr:

Update: Okay, I just went back into the Admin Settings to enable a new mod I just installed and now coupon restrictions shows up in there under 3rd party. I swear it wasn't there before!:wacko:I believe you Shawn

Let me explain what has happened. Admin Profiles on the edge of Admin quietly monitoring what is happening and acting, as any good security measure should, to prevent activity which it has not been told explicitly is permitted.

Most third party add-ins will add themselves to the Admin menu via the box files that you diligently edited. Files referenced by the modified box files are spotted by AP which then adds them to its database of stuff to ask you about when you set up or modify a user profile.

However, sometimes a whopping big add-in comes along that has been divided up into modules, not all of which need to appear on the Admin menu, as they are called from higher level modules that are. Super Orders adds 8 php files to the Admin directory, but only 5 to the Admin menus.

When the ones about which AP knows nothing are executed, it does its job, stamps its little foot and says "access denied" (rather loudly).

But it's quite a well brought up little mod so rather than taking its toys and sulking in the corner (as I probably would), it plays nicely and generously inserts the unknown function into its database anyway so that it can prompt you about it next time you're editing profiles. The credit for this is not mine, but rather belongs to AP's grandpappy - the chap who originally built Admin Levels which later spawned AP.

The point of all this, is to recommend that you make sure that you have exercised all Super Orders functionality, and then go back and double check the profiles for your Admins in case other functions have appeared.

All the best ...

Hi,

I am a housewife who would like to build a website with some friends for our own handmade works.

Is it possible to assign a user to only one certain category by a droping down menu? For example,i only allow user 1 to add/edit/delete all the products in category 1, then user 2 to add/edit/delete the products of cetagory 2.....So that different users can work in their own cetagory of products without interfering with each other.

In "edit permissions" there is only a checkbox for a whole categories. Is it possible to add a drop down menu with all the categories listing inside for the Administer to select from?

It will be very much aprreciated if someone could help. Thanks!!

My Zencart v1.3.0.2
Admin Profiles v1.0.3

tartgc:

Hi,

I am a housewife who would like to build a website with some friends for our own handmade works.

Is it possible to assign a user to only one certain category by a droping down menu? For example,i only allow user 1 to add/edit/delete all the products in category 1, then user 2 to add/edit/delete the products of cetagory 2.....So that different users can work in their own cetagory of products without interfering with each other.

In "edit permissions" there is only a checkbox for a whole categories. Is it possible to add a drop down menu with all the categories listing inside for the Administer to select from?

It will be very much aprreciated if someone could help. Thanks!!

My Zencart v1.3.0.2
Admin Profiles v1.0.3

i also like this feature but its impossible for this time being... see here: http://www.zen-cart.com/forum/showpost.php?p=225334&postcount=39

I installed the contrib as per the instructions using the Admin Install SQL Patch tool to take care of the SQL bit. I am using the current version of ZenCart and the only other contrib I have installed is the Image Handler 2 contrib (so your instruction went very smoothly). I made sure that I (as the only admin) had the ID of 1, I put a check in the box for the Image Handler contrib and applied it. It showed up in the tools menu - great, so far so good.

Then the Sh1* hit the fan. I went to add a second admin. I clicked on insert and filled in the form - Username, E-mail, Password, and Admin Level 2. Upon hitting submit I got a white screen with the following text:

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.

I think this is the standard deny page. I can get to the admin home page by manually putting the base URL in the address bar, but I am denied access to any other admin page. Also I have the first menu line with the time, date, Home --- Logout links, but not the second bar with the box menus. I can not even access any of the admin pages from history. Also according to browsing the DB tables in phpMyAdmin it looks like is successfully added the second admin user.

Help I am so screwed right now and I am in a real time pinch. What the heck did I do and what can I do to fix it. This cart was almost done. I have it fully branded and I have been staying up nights to get it finished, I currently have over 40 hours into it in the last 3 days.

Any help is appreciated.

T313C0mun1s7:

I installed the contrib as per the instructions using the Admin Install SQL Patch tool to take care of the SQL bit. I am using the current version of ZenCart and the only other contrib I have installed is the Image Handler 2 contrib (so your instruction went very smoothly). I made sure that I (as the only admin) had the ID of 1, I put a check in the box for the Image Handler contrib and applied it. It showed up in the tools menu - great, so far so good.

Then the Sh1* hit the fan. I went to add a second admin. I clicked on insert and filled in the form - Username, E-mail, Password, and Admin Level 2. Upon hitting submit I got a white screen with the following text:

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.

> 
> I think this is the standard deny page. I can get to the admin home page by manually putting the base URL in the address bar, but I am denied access to any other admin page. Also I have the first menu line with the time, date, Home --- Logout links, but not the second bar with the box menus. I can not even access any of the admin pages from history. Also according to browsing the DB tables in phpMyAdmin it looks like is successfully added the second admin user.
> 
> Help I am so screwed right now and I am in a real time pinch. What the heck did I do and what can I do to fix it. This cart was almost done. I have it fully branded and I have been staying up nights to get it finished, I currently have over 40 hours into it in the last 3 days.
> 
> Any help is appreciated.

the admin level should be entered 1, not 2 but i think its not a big deal! try add the 3rd admin user and see what happen...

tajul_ashyqin:

try add the 3rd admin user and see what happen...

Sure, and just how should I do this? I have no access to the admin now. :cry: