Glad to hear everything is working as anticipated.Quote:
Originally Posted by Igor_
Printable View
Glad to hear everything is working as anticipated.Quote:
Originally Posted by Igor_
I just installed 1.1.1 and now only see the configuration button in the admin screen.
I double checked my edited files against the originals, and everything looks like the instructions say.
I have two admins and they both show the same thing.
Any ideas? I really don't want to uninstall this mod.
Thanks in advance,
Joe
Got it figured out.
Thanks anyway...
Joe
I know this has probably been asked before but after about 90 pages I still cant find what I am looking for so here goes.
I have the newest zen cart installed on my site. I downloaded the Admin Profiles mod today and have read over the instructions on installation.
My question is this. When I get to this screen from Admin/tools/install SQL patch, it says in the directions to run the following
install_admin_profiles.sql. Im new to Zen Cart and do not know how to "Run" this. I tried putting it in the box and hitting send but i get errors. I know I am not doing it right. If there is a tutorial on running this, please direct me to it, or if anyone has any info that would help me out, that would be great!
Thanks!
Mark and Jessica
What you actually do is to open install_admin_profiles.sql in a text editor such as notepad (NOT MSWord or other word-processor) and then copy and paste the content into the box and then hit Send
Ryk, thanks so much! Another question if I may. I am so totally new and learning so much from you all.
I did renam my original Admin Folder, like instructed, and in these instructions that came with the mod, it says to rename the admin folder in the mod before I drag and drop to my ftp. My question is, do I rename it to the same as my admin folder that is already there, or do I just rename it something else.
I have a good handle on editing the code lines, using Notepad++ and all, but I don't want to name the file wrong.
Thanks so much!
Mark and Jessica
You rename it to exactly the same as you renamed your admin folder as you want the files to go in there when you upload them to your site.
Thanks so much! Im a first time user and managed to get my Zen up loaded and running the first time no problems. This is my first Mod ever and I surely want to understand it all.
You guys are the best!
Mark and Jessica
I have followed all directions for installing the mod. I have logged into my admin area, none of my menu options are available, only the configuration menu. I followed the instructions to the letter, but obviously missed something. :oops:
I have logged out and logged back in to try to get it to come up.
will I have to uninstall the mod and start over again.
These are the steps I have taken: (I have the newest version of zencart 1.3.9h)
1. I did run the install sql patch from the Admin/Tools/Install SQL Patch first.
2. Changed the admin folder in the mod.
3. Dropped it into my root directory on my ftp.
4 made the required changes in my files as per the instructions.
5. Logged back into my admin area.
Im not sure how to attach a screenshot or copy and paste here so that I can show my coding changes.
any assistance would be greatly appreciated as I really really do not want to uninstall/reinstall this mod. Please, if you need further info, I will try to put it up here.
Thanks so much
Mark and Jessica
Ok, 86 the last question I asked. I figured it out and it worked right away! Ill tell you what happened if you promise not to laugh.
I am on dial up #1 - yeah yeah, we don't even get cable where we live.
#2 - I could not get FileZilla to work correctly so I used Core FTP - usually it runs top notch for me when nothing else will.
#3 - It didn't load the files.
Sooooo, I uploaded them manually to their correct directories and locations and Viola! Worked right off the bat. One of those Aha moments. Mind you I did this all on dial up so how many things could have gone wrong and did not! It only took me 20 min to upload Zen Cart via dial up so that was good as well.
Anywho, thank you all so much for allowing me to ramble, and for helping me out with the SQL thingy! Im learning as I go....and I am sure that I will be back on the boards to get help with other issues!
Thanks again!
Jess:clap::clap::clap:
I hate to ask this question as i am sure it is somewhere in the posts. I looked back about 10 pages and didnt see a link or anything were i could download this mod.
If you have it or can point me in the right direction.
Thanks
After installing Admin Profiles on the latest version of zencart, my admin login page loaded without the menu options.
I checked the cache and this is what it said:
[02-Apr-2011 16:05:08] PHP Fatal error: Call to undefined function menu_header_visible() in /Applications/XAMPP/xamppfiles/htdocs/zencart/dr38fdruejdorjeio/includes/header_navigation.php on line 18
I don't know what I did wrong or what to do to fix this. Any suggestions?
I just installed admin profiles and now i get a blank page at admin login.
Zencart 1.3.9h
This is the debug file -
[27-Apr-2011 01:11:06] PHP Fatal error: Cannot redeclare zen_draw_admin_box() (previously declared in /home/newmedia/public_html/newmediastudio/onlinequote/admin-renamed/includes/functions/general.php:2955) in /home/newmedia/public_html/newmediastudio/onlinequote/admin-renamed/includes/functions/admin_profiles.php on line 259
I re-uploaded everything but still the same problem. I've looked at both functions/general.php and functions/admin_profiles.php but I can't see the problem.
I'm a bit stuck here so all sugestions greatly appreciated.
Thanks.
You shouldn't have that function in both functions/general.php and functions/admin_profiles.php. That's what it means by being unable to redeclare it.
The one in functions/general.php should be commented out or removed.
Thanks Kuroi,
that fixed it. I don't know why it would have that code twice. Any ideas?
The function in functions_general is the original Zen Cart version, the other is the one that replaces it.
OK, thanks.
Did i miss that in the readme.txt somewhere?
Is there anything else to change apart from the changes to admin/admin.php ?
It's patch 4 in the step 3. And yes, patch 3 is for changes to the admin/includes/languages/english.php file.
I have searched the forums and tried to narrow my search to this forum post, but could not figure it out. Unless maybe my problem has not even been addressed yet.
I have installed the profiles module step by step and have not had a single issue until I get to the point where after I log in, I go to Admin > Tools > Admin Settings
And this is what comes up on my screen instead of menus where I assign permissions, etc:
Parse error: syntax error, unexpected $end in /home/danny89/public_html/shop/test_admin/admin.php on line 346
Can anyone tell me what is causing this and how I go about solving the issue?
V 1.3.9h
This means that you have made a small error when applying the patches to the admin.php file. I recommend double checking them very carefully, This could be as small as a single character out of place.Quote:
Originally Posted by planetdh
This is what my code says: (not sure how I applied the patches wrong when this was the file given to me from the zip file : / I even tried relocating that last script to just about the </html> tag thinking maybe it was out of place..but then it told me the error was on line 347.Quote:
Originally Posted by kuroi
338 <!-- body_eof //-->
<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
346 <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
Awesome! Fixed the problem! The last line of code (Line 346) on the admin.php file, it's missing a '}' at the front of the closing php tag! :D
But NOW...I have a new problem, I can't add additional users!! :huh:
From the Admin Settings page, I click 'Insert' to create a new user, but the only thing that happens is the Insert button disappears and the url changes to what SHOULD be the add new user page!
Any thoughts or suggestions on this one?
Hello Kuroi,
I run a website useing 1.3.8.a zen cart and use the Admin Profiles, previously it run welll, and then we have change some add-ons, like sitemap, update it the latest, and add the ceon url mapping rewrite modual, and today I want to set the admin files, when I tick some menu for the admin user, and click save it saved and returned to main page of admin, but when I check again about it, found that the menu which choose to tick is not tick at all,
that means, the admin files can't save it.
Could you tell me that the problem is? Thank you very much
Sort of. I'm not convinced that your fix was correct. The line number reported is merely where the PHP parser detected the problem of the missing bracket. The place from which it was missing would have been rather earlier.Quote:
Originally Posted by planetdh
So although you've managed to get past the error, the underlying problem is still there.
Trouble is it doesn't resolve any that I've seen before, so is specific to your site, making it difficult to comment with greater clarity.
Which version of Admin Profiles are you using? Is it one designed for 1.3.8a or 1.3.9?Quote:
Originally Posted by alan145
I use the one designed for 1.3.8a, and I have try to re-install it, and it is oK, but then the sub catagories are missing, you can see the pictures, I really confused about thatQuote:
Originally Posted by kuroi
Although your second picture is of Admin Profiles, I don't recognise the first one, which must come from an add-on module with which I'm not familiar. Not knowing the add-on, it's difficult to understand what the problem.Quote:
Originally Posted by alan145
Dear Kurol, what I mean is that the precious one come with the product catogeries and sub catagories, but after install this add-on, the catogeries and sub catagories and missing, Can you understand me now? Sorry I do not express wellQuote:
Originally Posted by kuroi
I'm trying to install Apsona ShopAdmin and am getting a particular error, so I contacted their support and they referred me to this thread. After doing some reading on it, it seems the error in trying to install the this mod is based on some incorrect SQL syntax from this mod, Admin profiles.
I'm trying to do all this on my install of 139H. The install error that I get when trying to install ShopAdmin is as follows:
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 'apsona_index');'' at line 1
in:
[SELECT id FROM admin_files WHERE page = '#" title="Apsona ShopAdmin - opens in new window" onclick="apsona_showPopup('apsona_index');']
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.
It seems to stem from this line in apsona_app_tools_dhtml.php:
$za_contents[] = array('text' => "Apsona ShopAdmin", 'link' => '#" title="Apsona ShopAdmin - opens in new window" onclick="apsona_showPopup(\'apsona_index.php\');');
Does anyone have a fix for this, to make ShopAdmin work with Admin Profiles? I'm using the Admin profiles for 139h.
@alan145
I wonder if you're using http://www.zen-cart.com/index.php?ma...oducts_id=1088
This was developed from Admin Profiles but was a bad idea, immediately abandoned by its author, and it would be a surprise if it worked in current versions of Zen Cart.
I'm afraid that's not supported here, or anywhere else to my knowledge.
@autoace
The problem isn't with Admin Profiles. It's that Apsona launches itself in a non-standard way and the mini script that it uses to do so and which you're putting in your database is breaking SQL when used in a query.
You're already escaping the single quotes, e.g. putting "\" before them in your admin_files entry for Apsona. You could try escaping the escapes (i.e. put two more backslashes before each single quote), but there's no guarantees for that, so please let us know whether or not it works.
So what do you suggest I do? I copy/pasted the code below for clarity.
<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); }?>
Quote:
Originally Posted by kuroi
So what do you suggest I do? I copy/pasted the code below for clarity.
<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); }?>
I suggest doing a file comparison between your version of this file and the one in an unchanged version of Zen Cart to find the place where the bracket matching problem has slipped in, rather than just adding an extra bracket at the end.Quote:
Originally Posted by planetdh
Quote:
Originally Posted by kuroi
Wow...I guess file comparisons really do work! I found where I left out the }
Thank you very much for pointing me in the right direction. I guess I need to be more careful about copying ALL info in the instructions! :smile:
Glad you found it. I find file comparisons from a good automated tool (I particularly like Beyond Compare) invaluable for getting a much more accurate assessment of changes (working or otherwise) than I could possibly achieve from a visible inspection alone.
Oh, and credit to you too. Often when us old hands keep telling people the same thing they get frustrated thinking that we're not getting it. Can happen, but usually it's the opposite. You though were listening and so got to the bottom of the issue, which is always good to see.
@kuroiQuote:
Originally Posted by kuroi
Did as you suggested and no go :no:
Would you be able to suggest another possible work around so that both mods can live in harmonly :)
You could try replacing the whole box_file with just the lineand then right clicking to launch in a new tab/window when you want to use it.Quote:
$za_contents[] = array('text' => "Apsona ShopAdmin", 'link' => 'apsona_index.php');
Help me about multi languages in Admin Profile.
when i chose Edit Permission, then select a language Vietnamese in combobox Define Languages. ZenCart have a error such as:
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.
Please, help me how to fix this error? Thanks a lot
Which version of Zen Cart? Which version of Admin Profiles? Does this happen if you change your language before starting to Edit Permissions?Quote:
Originally Posted by anbt
Zen Cart version 1.3.9h.
Admin Profile version 1.1.1.
No error when i change your language before starting Edit Permissions.
When i choose Edit Permission after I changes my language, have a error such as i said. But when i click button Go back on Web Browser, Admin Profile is still normal and my languages has changed.
It is small error. It does not affect to my app. but i want to known where is error.
Thanks
It sounds as though the error isn't actually in Admin Profiles, but in the way that parameters are lost when the language is changed. That said Admin Profiles should handle the absence of key parameters better.
Kuroi
Please forgive me I am not all that well versed in Zen. I am trying to upload your admin mod and when I do I get:
500 Internal Server Error.
when I do this: http://www.yourstorename.com/admin/a....php?adminID=1
I get page not found
(I have changed it to match my own site)
I have double checked to make sure all files were put in correct folders. Can you please help me. I know it must be a simple fix. I would like it for you to word it like you are talking to a child so I can understand it since this is all very new to me.
Thank you so much for taking the time to reply to me.
This is most likely a problem with the permission levels on the files after uploading rather than with the mod itself.Quote:
Originally Posted by MollyOlly
There is a FAQ entry that helps with this.
For the page not found message, I can only suggest double checking that the path that you put in your address bar correctly reflects the location of the file.
I am using 1.3.9h and when I install Admin Profiles. I am able to see all the menus however when ever I select one I get this error:
Sorry, your security clearance does not allow you to access this resource....
There is only one admin but I want to add more. The admin id = 1, admin_level=0
I have tried all combinations of admin_id = 0 and admin_level=0 all with the same results - the error shown above.
Please help. I have use Admin Profiles in older versions of Zen Cart without any issues. This is a new site using 1.3.9h.
Is it possible for admin users to be redirected straight to the Catalogue page in admin? I am using Admin profiles but I don't want other administrators to see all the customer and webstats shown on the admin index page.
Probably. You'd need to tinker with the login page code to detect your admin and where to send them. But that wouldn't stop them from clicking on home and going back to see them.Quote:
Originally Posted by lavendersblue
Probably better is to suppress them from the home page. There are posts giving the exact code needed for that earlier in this thread.
Hi, thank you for getting back to me so quickly. I have found and followed the instructions for hiding the details on the admin index page, however it has hidden the customer order information but it is still possible to see the website stats, the number of customers the website has, the number of orders, etc. I don't want the other admin users to be able to see anything at all on this page, or I need to redirect them to another page, is this possible? I have tried searching for various possible threads relating to this but can't find anything appropriate, perhaps I am not using the correct search wording or should I be searching in the general section of the forum rather than on this thread? :cry:
I was wondering how to uninstall Admin profiles? It doesnt come with an uninstall sql :no:
There is an uninstall sql in with the install file pack.Quote:
Originally Posted by sweetikins
You can prevent them from seeing other boxes by extending the approach you've already implemented for your order information.Quote:
Originally Posted by lavendersblue
Redirecting them to another page on login (and keeping them from coming back the landing page) is a little more complex and, yes, beyond the scope of this mod's support thread.
This is true for the current version, but I suspect not for older versions.Quote:
Originally Posted by lavendersblue
I'm pretty sure that there are uninstall instructions in this thread, but just in case. You can see which tables need to be dropped from the install SQL for your version. But (and this is really important). Don't drop them until you have reversed and code changes made in the install and removed the files that were added.
Just as an aside though. I wouldn't bother to uninstall it. PCI requirements make mandatory some form of access control over and above a simple login. So I expect you'll find yourself dealing with something similar again in the future anyway.
Thanks, I will continue preventing them seeing the other boxes, however I also cannot see the boxes when I log in as administrator now, despite having added my username to the code. I did get a code error when I added this code
<?php if ($_SESSION['admin_id'] == <myusername>) { ?>
- this was solved by removing the <> from around my username, but I think this is stopping my being able to see the boxes when I log in. How can I solve this? Sorry I am not very good at php code :-(
<?php if ($_SESSION['admin_id'] == <myusername>) { ?>
should use your admin user id rather than user name. The ID is numeric. If you were the first user and haven't been re-entered, that would be "1", in which case this would read
<?php if ($_SESSION['admin_id'] == 1) { ?>
Thank you so much for your help, very much appreciated. Brilliant add-on and working perfectly :-)
Possible Bug
If a module's name contains punctuation like a period (.), then admin profiles will not work for that mod.
The fix is on line 41 of admin/includes/functions/admin_control.php, change to:
PHP Code:$field = $_POST[str_replace(array(' ', '.'), '_', $pages->fields['page'])];
I am having the hardest time getting this module to work. I have installed it 2 other times just fine, but am now trying to install it for a third time on a new site.
When I try and merge the header_navigation.php file it does not work and makes my header bar disspear. This is what I have for my original php coding:
How do I merge the new coding which is this: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: header_navigation.php 3089 2006-03-01 18:32:25Z ajeh $
*/
if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');
}
?>
<!-- Menu bar #2. -->
<div id="navbar">
<ul class="nde-menu-system" onmouseover="hide_dropdowns('in')" onmouseout="hide_dropdowns('out')">
<?php
require(DIR_WS_BOXES . 'configuration_dhtml.php');
require(DIR_WS_BOXES . 'catalog_dhtml.php');
require(DIR_WS_BOXES . 'modules_dhtml.php');
require(DIR_WS_BOXES . 'customers_dhtml.php');
require(DIR_WS_BOXES . 'taxes_dhtml.php');
require(DIR_WS_BOXES . 'localization_dhtml.php');
require(DIR_WS_BOXES . 'reports_dhtml.php');
require(DIR_WS_BOXES . 'tools_dhtml.php');
require(DIR_WS_BOXES . 'gv_admin_dhtml.php');
require(DIR_WS_BOXES . 'extras_dhtml.php');
?>
</ul>
</div>
Then when I try and add these 2 files, it crashes the admin screen all together to where I am not able to even view the log in screen: admin/includes/functions/DS.Store and admin/includes/functions/admin_profiles.php.Code:if (menu_header_visible('Configuration')) require(DIR_WS_BOXES . 'configuration_dhtml.php');
if (menu_header_visible('Catalog')) require(DIR_WS_BOXES . 'catalog_dhtml.php');
if (menu_header_visible('Modules')) require(DIR_WS_BOXES . 'modules_dhtml.php');
if (menu_header_visible('Customers')) require(DIR_WS_BOXES . 'customers_dhtml.php');
if (menu_header_visible('Taxes')) require(DIR_WS_BOXES . 'taxes_dhtml.php');
if (menu_header_visible('Localization')) require(DIR_WS_BOXES . 'localization_dhtml.php');
if (menu_header_visible('Reports')) require(DIR_WS_BOXES . 'reports_dhtml.php');
if (menu_header_visible('Tools')) require(DIR_WS_BOXES . 'tools_dhtml.php');
if (menu_header_visible('GV_Admin')) require(DIR_WS_BOXES . 'gv_admin_dhtml.php');
if (menu_header_visible('Extras')) require(DIR_WS_BOXES . 'extras_dhtml.php');
I have insatlled the SQL patch, I did that first. I then started adding each file individually so I could find out which files were causing the problems. I am now not able to view any of the menus when I click under the admin menu. I can't see the layout boxes controller or anything let alone the admin settings.
The site address is http://www.scraps-n-pieces.com/store/
Any help you could give me would be great!
Can anyone help me?
I could really use some suggestions on this one... can anyone help me out?
Hi all,
After enabling this module I cannot use the AJAX search feature of another module --- Products by Attribute Stock.
If anybody has a solution please advise, will try putting some files in the override (products_with_attributes_stock.php, products_with_attributes_stock_ajax.php) to see if it solves anything and will post back with results.
Thanks.
EDIT: Not sure how to add these files to the overrides (line 23), any ideas?
Quote:
Originally Posted by kuroi
I recently installed admin profiles on 1.3.9h , but it showing only the configuration tab in the admin area.
all other tabs are missing.
i do not know how can i get back all those tabs.
kindly help me.
Quote:
Originally Posted by muteyaar
Quote:
Originally Posted by kuroi
I reinstalled the admin profiles again now, and this time, all is well except for the admin settings tab.
when i click on the admin settings tab, then i get this error:
Parse error: syntax error, unexpected T_VARIABLE in /home/...../public_html/zc_admin/admin.php on line 1
can anyone help me please?
Hi Kuroi!
Ok, I went and made a BIG MISTAKE! I accidentally turned off the admin function on my own profile and I am unable to make any changes to mine or any other admins now! (I thought I was disabling another admin...but it was mine) :oops:
Is there a way to regain access to the admin functions?
Thank-you!!
(By the way, everything was working PERFECTLY until I messed up! The install was very simple and straight forward, functioned like a charm! KUDOS to you!!)
:clap:Hello again! Problem solved! Found the solution deep within the threads!Quote:
Originally Posted by kawikapoi
Thank-you!
Hi all.
I am using Zen Cart 1.3.7 and the v.1.0.7 version of Admin Profiles.
Recently for one reason or another when I try to make changes to a users permissions, it boots me back to the admin dashboard screen (the one you get when you first log in) and upon reentering the admin permissions error no changes have been saved.
Any ideas?
I have kind of traced the problem into my application top script (i.e in admin_controls.php I havebefore and after thePHP Code:echo "here";
and only the first one shows up.PHP Code:include(application_top.php);
Regards, John.
Disregard that I jsut reinstalled the files and all is now well.
Thanks for a great mod!
It sounds as though some of the security features from a later version of Zen Cart may have found their way into your site. But by reinstalling you kicked 'em out again.
But you really need to think about going the who hog and upgrading as 1.3.7 has known vulnerabilities fixed in later versions.
I just installed this mod in my store. When I click on edit permissions and check the boxes for the categories, so I can access my prducts, and click save changes it takes me back to the admin home page and I still cannot get into my categories.
Can you tell me what I've done wrong please?
Please click on reply and answer the questions in the posting tips.
Sorry...
I'm using v1.3.9h it was updated from 1.3.9g back in June.
the add ons I have are image tiles, sale report, and free gifts
:blush:
You're not telling us which versions of the add-on modules you're using. In particular for Admin Profiles. The problem you're describing was common when tried to use older versions with either 1.3.9 (or 1.3.8a with the security patch), but I've not heard of this happening with version 1.0.7 (released primarily for security patch compatibility) or 1.1.1.
I'm using the version 1.0.8
Ah. That would explain it. You're actually using "Admin Users - Restrict Product Categories".
That was a fork of Admin Profiles, but alas it didn't really do what it claimed to. Sadly the author didn't update the readme file which is why you thought you had Admin Profiles. Worse, the add-on doesn't appear to be being supported or maintained.
I can only recommend that you uninstall it, and use the Admin Profiles instead.
Do you have the fixes that you applied to accomplish hiding the admin home? Thanks.Quote:
Originally Posted by lavendersblue
I am using Zen Cart 1.3.9h
I have the english and greek languages installed
I have admin profiles 1.1.1 installed
until today everything worked properly with admin profiles
Today will I was in the admin session Configuration -> Email Options I changed the language from english to greek and instead of seeing the Configuration -> Email Options page I saw the usual - your clearance does not permit you... page from the admin profiles addon. As usual i visited the Tools -> Admin settings -> edit permissions in order to check the new box that jas appeared but after this box there is no description as usual. You can see the difference in the following source code:
<label class="permissionBox"><input name="additional_product_images_upload" class="Third Party Mods" type="checkbox" checked="on" value="on">additional product images upload</label>
<label class="permissionBox"><input name="" class="Third Party Mods" type="checkbox" value="off"></label>
and so even i check the empth box and click on save nothing changes and the box is still not checked.
Again today accidentaly while trying to figure out the above problem i tried to change the language while on the Tools -> Admin settings -> edit permissions page and i got the following page instead of returning me to the Tools -> Admin settings -> edit permissions page
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 field.
I believe that the first problem i stated has something to do with the second problem but really i can not figure out what to do in order to fix these problems
Can somebody help me?
It must not be a new issue but still I would be great full for any help. I have just gotten a new partner who would be helping me in updating my categories in Zen Cart. I was trying to install the admin access module on my Zen Cart 1.3.8.
All links seem to work fine but I cannot see the categories now which my friend has to update. Everytime I click on the categories link, this is what I get.
1146 Table 'chandan_zc4.zen_admin_allowed_categories' doesn't exist
in:
[select admin_id from zen_admin_allowed_categories where categories_id = '0']
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 field
I have also tried to replace the categories.php page but to no avail. Have also checked this table, it does not exist in the DB.
Help me sort this issue please.
Thanks,
Chris
@chris13 See post #1174, it applies to you too.
You also really need to upgrade to 1.3.9. 1.3.8 has known vulnerabilities that have been published on hacker websites and for which they go looking.
Hi can someone help me please, i have gone to change the admin as it is part of the security and now i keep getting error 403 and cant sign into my admin page or get on my c/panel for zen cart thanks
this is what i am getting 404 Error - File Not FoundQuote:
Originally Posted by BABY-INFORMATION
The resource you have requested could not be found on the server. There are many possible reasons for this.
Either the file does not exist, there is an error in your request, or the file is not accessible in the requested directory.
Please verify that:
You have used the proper case; requests ARE case-sensitive!
You have entered the URL correctly. (i.e. proper directory/filename)
You used the FULL URL. (i.e. proper file type: .html, .gif , .jpg, etc.)
@baby-information, which version of Admin Profiles have you installed?
My problem is that when i check the third party mode and save the changes it does not hold, when i try to access some of these third party modes i get this message:
"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."
When i check the permission again i find out that the mod that i wanted to access is unchecked and every thing else is still checked. Any ideas?
my zen cart is 1.3.7
@TamyA
There were significant changes to the way in which Zen Cart handles admin forms since 1.3.7. Recent releases of Admin Profile confirm to the new standards, and it sounds as though incompatibilities in this area may be causing your problem.
The only solution that I can suggest is to bring your Zen Cart up-to-date, by upgrading to 1.3.9. This would be standard advise to anyway running 1.3.7 as these sites are vulnerable to being hacked.
Thanks Kuroi,
I know i need to upgrade to the latest Zen Cart, what is stopping me is i did not follow the follow the override system of zen cart and lots of changes made directly to core files. I need to see if there is an easy way to upgrade and get the changes from those files to the new version.
Thanks again
Hi TamyA,Quote:
Originally Posted by TamyA
This may help you in your upgrade to undo what you have since you did not make changes by following override system. What you are going to do is reverse install and when finished will leave you with the parts to install in the new 1.3.9.h. This also assumes you have working knowledge of Beyond Compare and how to compare and merge files and folders.
Here are the steps:
- Make a list of all your 3rd party installs with the version number.
- Download your shopping cart and name “Work Copy”.
- Download a copy of Beyond Compare.
- Download a copy of each 3rd party mod and place in a folder called Mods. Then place each mod in their own folder inside Mods Folder.
- Un-Zip each mod inside its Zip up folder and look for any folders called “YOUR_TEMPLATE” folders/files that should been placed in your override folder. Make a note of these 3rd party mods on your list in step 1.0 so you know which later to Change (the name of “YOUR_TEMPLATE” to what you should have named your override folder).
- Open Beyond Compare and first load a mod that does not have a override folder in the mod on the “Left Side” and load the “Work Copy” of your shopping cart on the “Right Side”. Next Compare the “Left side” to “Right Side” and DELETE any files that are “equal or the same” from your “Right Side the “Work Copy” ” After you have finished removing all Mods that Do Not have a “YOUR_TEMPLATE” folders you are ready to remove the Mods that are in “Core Files”. Save a copy of the “Work Copy” with Mods removed each time just in case of a mistake.
- Make and name a work copy of each Mod that has the “YOUR_TEMPLATE” folder. Next in this work copy mod “REMOVE” the “YOUR_TEMPLATE” folder leaving all folders and files downstream intact.
- Load one of these Work Mods from step 1.6 in the “Left Side” just like you did in step 1.5. Compare Left Side to Right Side and preform the same steps in 1.5 loading each of the Work Mods on Left Side from step 1.6. Be sure to save a copy of “Work Copy” after you remove each Mod.
- What you now have left is your Shopping Cart with all mods removed, and should only have the changes that make your Shopping Cart different than the Original Basic Zencart.
- Now load in Beyond Compare and on the Left Side the Original Version of Zencart you used to build your shopping cart. Do a Compare then remove all files that are equal leaving the folder empty on the Right Side.
- Next load each file that is not equal and remove all lines of code on the Right Side that match the Left Side. When finished what remains on the Right Side is the path of empty folders to the few folders containing files with a few lines of code that is the mod “For Your Cart” Save this file inside a Folder called “My zencart Mod” and make a Master Copy.
- Load into the Right Side of Beyond Compare zencart 1.3.9h and load on Left Side “MY zencart Mod” merged Left Side into Right Side. Save a copy of “My_Master_zencart_no_Mods” and UpLoad this copy and test to see if appearance of your shopping cart is correct. If all OK you are ready for 3rd Party mods.
Creating a Master 3rd Party Mod. Be sure first to change the name of “YOUR_TEMPLATE” to your override name on each of the mods.
Take your list of 3rd party mods and load the largest one into Beyond Compare Right Side. Load the next mod in your list and merge into Left Side. Do this with each mod in your list. When finished you will have a Master 3rd Party Mod. that was working with your previous version. Save and name a copy to be merge into your new 1.3.9h from step 1.11 Before you merge your 3rd party mod always make a careful comparison to all files on Right Side “1.3.9h” to make sure you are not going to be overwriting any core files or if you will be you know why/where and if it is OK.
Only use this method after you know the mods works with your shopping cart. Then when new versions of same series of cart are released is simple to update. I have used this method for years now with no problem and I don't install a new unproven mod until it has been tested, if OK then add to your Master 3rd Party mod file.
Thanks EZorb,
I am about 95% done with the upgrade.
I am doing it on a local server (wampserver), i kind followed something like your guidelines and it has been fun seeing the result coming a long.
Thanks again and you trouble is much appreciated.
I have a problem. I can't log into admin. It's saying wrong username or password. Is there a way to retrieve the password or get in and change it? Don't know what to do. Thanks for anyones help.
Admin Profiles doesn't go anywhere near the login mechanism of the admin password. I suggest that you just use the normal process described in the FAQ.Quote:
Originally Posted by ubstampin
I installed the Admin Profiles plugin and updated all of the PHP scripts, as per the installation instructions. I double checked the changes I made, but the following error is still occuring:
1146 Table 'erezer_net_13.zen_pet_storeadmin_menu_headers' doesn't exist
in:
[SELECT id FROM zen_pet_storeadmin_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 searched the Internet, the support forum and this thread for an answer to this problem and I still cannot find an answer.
This thread is huge, so it could be cumbersome to read the entire thread to find an answer for this problem in the time I need it solved.
Also, I'm using ZenCart v1.3.9h (supposedly current) with Admin Profiles Version: 1.1.1.
The message is telling you that a table doesn't exist. Have you looked in your database to see whether or not it's there?
How did you install the extra tables for this add-on?
The message also implies that you are prefixing all your database table names with the prefix "zen_pet_store". Is this correct?
No, I haven't looked to see if the table exists. I didn't install any tables. All I did was follow the installation instructions. Copy over the directories and make the appropriate modifications to the PHP files. I didn't add anything into the array in line 23 of admin/includes/init_includes/overrides/init_admin_auth.php, as the installation instructions say that it is usually not needed. I really don't know jack about MySQL.Quote:
Originally Posted by kuroi
I think I used the wrong instructions when I installed the add-on. I think I misunderstood the "fresh installation" instructions as going with a fresh installation of Zen Cart and the "upgrade" as being to upgrade a current Zen Cart installation. How I made that mistake, I don't know. Seems to be common sense, and it was probably a mental glitch on my part. I will probably have to uninstall the add-on and then re-installl it with the correct procedure. I apologize for taking up support space with this mistake. :oops:
If you have already added the files correctly (and the error would seem to imply that you have) then you need only add the tables.
However, there's a catch. By adding the files you prevent yourself from accessing the Zen Cart feature to add run the SQL that adds the tables. So it would need to be done by hand with your database prefix edited into the SQL by hand and then it being run via a third party app such as phpMyAdmin.
I have the impression that might not be something with which you're comfortable - in which case removing the files and re-installing using the installation instructions would be a better option.
I've used PHP admin a little bit, and I can do what I need to do if I know precisely how to do it.
I attempted to install this add-on again, and this time I did not neglect to do the DB update. My site broke again. When I went to browse -> select file -> install_admin_profile.sql, it just kind of refreshed the page, and didn't tell me whether or not the upgrade was successful.
Maybe it would have worked better, had I copied and pasted the DB into the text box at the DB update screen?
I backed up the MySQL databases in phpMyAdmin (hopefully the right way), and I only commented out the lines of PHP I changed this time. Hopefully I can quickly revert Zen Cart to the form I had it in before I made the changes that broke the site, and then later, install the plugin the right way.
So I'm still not sure how to install this plugin the "right way", and I need a little help here.
Hi! I've had admin profiles for nearly a year now? Many, many months it seems- anyway, I'm not sure what version I have or how to find that information out, but I went to install Sales Mod and my sales mod won't work at all, it kicks me back to the log in page, and I'm not getting any help over at the sales mod thread, so I'm wondering if anyone else has experienced and issue with the conflicting mods? "You are presently using: v1.3.9d" Please don't ask me to update my version of zen either, it scares me! :shocking::blink::(:P:unsure:
any help would be awesome, thank you!
Thanks for the mod.
I've installed other SQL patches where I simply copied and pasted the entire file contents into the Zen Admin tool. With this SQL file, I'm not sure if I'm supposed to do that or where exactly in the file to start copying.
Also, I don't understand: "change the following line if the super user (person to have access to everything) has an admin ID other than 1SET @superuser = 1;" Let's say my admin username is "joeshmoe," where exactly do I put that?
Clarification on these two points would be appreciated.
R
You assign or should assign #1 to the person that has rights to all items. You can assign other numbers to other persons in your organization to have limited access like only allowed to process orders. Or say you have a developer you can assign a number to and give all rights or limited.Quote:
Originally Posted by giftmeister
SQL is pasted as all sql files.
Just to add to this when you look at your list of users in "Admin Settings" you'll see the user id in the left column. Usually the first account set up is the store admin hence ID 1 having full rights.Quote:
Originally Posted by EZorb
Thanks, it installed perfectly!