I was messing around with the admin setting and erased the admin name and email address. Now I can't log into the admin side of my site. What file do I need to reset???
Thanks for any help. This dufus won't be doing that again:ohmy:
Printable View
I was messing around with the admin setting and erased the admin name and email address. Now I can't log into the admin side of my site. What file do I need to reset???
Thanks for any help. This dufus won't be doing that again:ohmy:
Hope someone can help, Ive been hunting this forum for a solution!!
I would like to be able to turn off the admin_demo that appears everytime I want to change something, ie tools, admin settings just one example there are many others. I am sloooooowly finding my way around Im no computer wiz...:down: If I could just suss out this problem first then I'll see how I do. (Ive only sussed out how to post on this forum), must be us brits:P
Thanking you all in advance.
Desperado zenned terry
in phpMyAdmin, click on the "SQL" tab, and enter this statement and click "Go":
Code:
Code:update configuration set configuration_value=0 where configuration_key = 'ADMIN_DEMO';
Many thanks..... Ive seen this post before but I cannot locate phpmyadmin anywhere in the admin side or the cpanel side, Ive tried php chat, I dont seem to have a seperate icon to click onto as you describe, I have found phpadmin in file manager etc but I dont think thats the same is it.
Could you guide me where it is.:thumbsup:
Thanks for you quick reply...
I have just stummbled onto phpmyadmin, had been there before but didnt know what to do, now tried the copy paste line into SQL tab but it comes up with page not found, what do I do now.:thumbsup:
Getting this message. :cry:
The page cannot be displayed
The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings.
--------------------------------------------------------------------------------
its depends where u is your MySQL DAta base if its in your machine and u are with Apache u should try http://localhost/phpmyadmin
for diferent server please ask your support for managing your DAta base
I dont understand this. Could you be a lot more specific:blush: . I have not idea what you are saying, you must be a really brainy person to know all this stuff, because my head is in overload. I have to admit now I am getting a bit dispondant with all the changes you have to make to get things to work, I was told I didnt need to do any of this. I have only a couple of demo products online at the mo, if you wish (please, pretty please) you could look at my admin etc I will give you the pass word that I was given so you can have alook around.... so you can see what is wrong, I'll pay you for your time as long as it isnt to much:P Thank you kindly so far for you help
look i can not help with that kind of help only that i could do is to navigate you some and Im not so bariny person the things are easy alll u need it to get it some how
now first tell me where is you hosted your web site on your machine or some web server.
u can connect me with ICQ 151121629 or skype: koroto (Radoslav Miroslavov)
Your hosting company is responsible for your phpMyAdmin configuration. You need to talk to them if you're getting errors trying to use phpMyAdmin.Quote:
Originally Posted by cyberdis
where is the phpMyAdmin? to remove and reset the structure?Quote:
Originally Posted by Ajeh
what is it DROP TABEL IT EXIXTS admin?
where to CREATE TABLE admin to save where? (w'd it be text editor? if so save with what namne?)
what is admin VALUES? And how to apply the VALUES?
SORRY FOR BEING SO STUPED, I JUST DON'T KNOW?
RGDS.
UNI
uni ... it's not necessary to post multiple copies of the same question.
Please continue your discussion in your original post on this topic:
http://www.zen-cart.com/forum/showthread.php?t=42743
HEEE..EEE..EEELP
when i was following the security recommendations made a mistake and cant login. first ive changed the admin directory name and it works when i tried it. then i wanted to change my password and there all begins /i blame that moment doing that/. i tried to use case sensitive admin name and alfa- numeric password to it. after loggin off i cant login again.
then i did what forum says, in phpmyadmin i copied-pasted those codes in 2 steps but still cant login.
is the admin name case-sensitive or not? do i miss something there, maybe check-uncheck boxes...
now im really suffering about loss of my works
please help
maybe the table name must be with prefix zen_??
yes it is! i logged in. i did it by myself.
thank you zen followers for all u r doing
im really happy today!
hurry up to do next dummmy steps forward
Thanks for the update and glad you sorted out the problem ... :smile:
Hi,
I see you have contributed really well in the forum and was hoping you could offer some advice for me please. I can't log into Admin:
- I've tried resubmitting my pwd but its not send ing to my email address?
- I checked the password via PHPMYAdmin in the admin_table and it had a whole lot of numbers like a76565363638282877823872378:90. replaced this entire string including the ":90" with my password. I then tried accessing Admin with the new details but still no dice
Any ideas?
Hi,
I see you have contributed really well in the forum and was hoping you could offer some advice for me please. I can't log into Admin:
- I've tried resubmitting my pwd but its not send ing to my email address?
- I checked the password via PHPMYAdmin in the admin_table and it had a whole lot of numbers like a76565363638282877823872378:90. replaced this entire string including the ":90" with my password. I then tried accessing Admin with the new details but still no dice
Any ideas?
I#ve followd the steps proposed by 'Ajeh' but still can't login.
Following errormessage appears:
'Error: Sorry, there is no match for that email address and/or password.'
Any idea what's going wrong?
thx for your help!
aber
https://www.zen-cart.com/tutorials/index.php?article=2
Now login with username: Admin Password: admin
That will work.
I've tried all the messages and It still says there is an error. Any other suggestions?
My front page is blank, also... but I will figure that out after I can get into the admin area.
Thanks for any assistance!
Patrick
Update: I decided that I was looking to hard and the answer was probably really simple.
So, I went back to the simplest thing to do, I re-uploaded some of the core files and viola, it's working again. :clap:
Patrick
I just installed zen cart v1.3.8a and can't login into admin. It keeps refreshing.
I have rebuilt the Admin table using phpMyAdmin as Ajeh pointed,
and,Code:DROP TABLE IF EXISTS admin;
CREATE TABLE admin (
admin_id int(11) NOT NULL auto_increment,
admin_name varchar(32) NOT NULL default '',
admin_email varchar(96) NOT NULL default '',
admin_pass varchar(40) NOT NULL default '',
admin_level tinyint(1) NOT NULL default '1',
PRIMARY KEY (admin_id),
KEY idx_admin_name_zen (admin_name),
KEY idx_admin_email_zen (admin_email)
) TYPE=MyISAM;
But still I couldn't login into the Admin.Code:INSERT INTO admin VALUES (1, 'Admin', '[email protected]', '351683ea4e19efe34874b501fdbf9792:9b', 1);
Is there something that I missed?
Close your browser sessions ... clear cache and cookies ... open new browser and it should be working ...
This happens to me periodically in FireFox ... :lamo:
Thanks Ajeh for trying to help,
Unfortunately it doesn't work even when I used IE. I still can't login into my admin. I reinstalled zen cart and it stills the same.
I'm confuse :no:
Check the two configure.php files on the server in:
/includes/configure.php
/admin/includes/configure.php
ensure that both are using the same database information ...
Then, go to phpMyAdmin on your domain Control Panel and browse the admin table to ensure that you have the right entry for the admin login ... remember everything is case sensative ...
If you are not positive on the login and password, then run the following in the SQL:
Then to set the login to:Code:ROP TABLE IF EXISTS admin;
CREATE TABLE admin (
admin_id int(11) NOT NULL auto_increment,
admin_name varchar(32) NOT NULL default '',
admin_email varchar(96) NOT NULL default '',
admin_pass varchar(40) NOT NULL default '',
admin_level tinyint(1) NOT NULL default '1',
PRIMARY KEY (admin_id),
KEY idx_admin_name_zen (admin_name),
KEY idx_admin_email_zen (admin_email)
) TYPE=MyISAM;
Admin
admin
use this:
Code:INSERT INTO admin VALUES (1, 'Admin', '[email protected]', '351683ea4e19efe34874b501fdbf9792:9b', 1);
OK, I just figured out something when I removed the .htaccess file from the root public_html directory. I installed ZenCart v1.3.5 before and moved all the files to the root (public_html). So that it becomes 'mysite.com' and not 'mysite.com/zenstore'.
Last Monday, I bought an addon domain and installed ZenCart v1.3.8a into the directory 'public_html/mynewstore/'. I also include the same .htaccess for the "URL" reason.
I just removed both .htaccess files and finally I can login into the admin page. There must something wrong with my .htaccess file or maybe I should move the 1.3.5 version back to it's directory.
Place take a look at my .htaccess file code and let me know what is the right thing that should be done.
Thanks Ajeh.
Code:# Use PHP4 as default
AddHandler application/x-httpd-php4 .php
##### NOTE: Replace /shop/ with the relative web path of your catalog in the "Rewrite Base" line below:
Options +FollowSymLinks
RewriteEngine On
RewriteBase /
# From Ultimate SEO URLs
RewriteRule ^(.*)-p-(.*).html$ index\.php?main_page=product_info&products_id=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-c-(.*).html$ index\.php?main_page=index&cPath=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-m-([0-9]+).html$ index\.php?main_page=index&manufacturers_id=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-pi-([0-9]+).html$ index\.php?main_page=popup_image&pID=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-pr-([0-9]+).html$ index\.php?main_page=product_reviews&products_id=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-pri-([0-9]+).html$ index\.php?main_page=product_reviews_info&products_id=$2&%{QUERY_STRING} [L]
# For Open Operations Info Manager
RewriteRule ^(.*)-i-([0-9]+).html$ index\.php?main_page=info_manager&pages_id=$2&%{QUERY_STRING} [L]
# For dreamscape's News & Articles Manager
RewriteRule ^news/?$ index\.php?main_page=news&%{QUERY_STRING} [L]
RewriteRule ^news/rss.xml$ index\.php?main_page=news_rss&%{QUERY_STRING} [L]
RewriteRule ^news/archive/?$ index\.php?main_page=news_archive&%{QUERY_STRING} [L]
RewriteRule ^news/([0-9]{4})-([0-9]{2})-([0-9]{2}).html$ index\.php?main_page=news&date=$1-$2-$3&%{QUERY_STRING} [L]
RewriteRule ^news/archive/([0-9]{4})-([0-9]{2}).html$ index\.php?main_page=news_archive&date=$1-$2&%{QUERY_STRING} [L]
RewriteRule ^news/(.*)-a-([0-9]+)-comments.html$ index\.php?main_page=news_comments&article_id=$2&%{QUERY_STRING} [L]
RewriteRule ^news/(.*)-a-([0-9]+).html$ index\.php?main_page=news_article&article_id=$2&%{QUERY_STRING} [L]
# All other pages
# Don't rewrite real files or directories
RewriteCond %{REQUEST_FILENAME} !-f [NC]
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*).html$ index\.php?main_page=$1&%{QUERY_STRING} [L]
# =============================================================
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
# -----------------------------------------------------------
RewriteCond %{HTTP_HOST} !^www\.mens-designer-jackets\.com [NC]
RewriteRule ^(.*) http://www.mens-designer-jackets.com/$1 [L,R=301]
# -----------------------------------------------------------
</IfModule>
# =============================================================
<Files 403.shtml>
order allow,deny
allow from all
</Files>
deny from 38.99.203.110
Incredible! I was just able to recover my Admin Username on my local (development) XAMPP based system. In the course of doing Zillion things, I forgot the Username completely (it wasn't admin or Admin): I was able to resend the password to my email address, but not the Username. Only the above procedure by Ajeh saved me from having to re-install and re-configure everything from scratch.
Thank you, Ajeh!
Daniel
You are most welcome ... thanks for letting us know that this worked for you in resetting the Admin password ... :smile:
Thank YOU, Ajeh. You have helped me numerous times in the past and this is yet another such time (even though I didn't post any question, just did a good search).
One minor clarification: I didn't reset the Admin password (I had it already, along with the Admin email address). What I amazingly forgot was the Admin Username (it wasn't 'Admin' or 'admin'). Funny and frustrating at the same time... :blink:
:frusty: I've done the step to reset it but I still have a blank page in both IE & Firefox. What else could be wrong? I think I'm missing a file. When I first installed zen cart I used to have 97 files and today when I logged in to phpmyadmin I had 95, after I ran the reset codes I have 96, What file could I be missing?
how do I determine my admin username. I signed up today but it won't allow me to log into my admin area. says wrong admin username or password. I know the password is correct
If you look at the post #2 of this thread ... I have it spelled out for you how to rebuild the admin table of your database so that you can then login and reset your password ... :smile:
so how do I get to phpmyadmin...
phpMyAdmin should be in the Control Panel for your domain ...
If you cannot locate this, you will want to contact your hosting site for additional help with your server and utilizing this application ...
This is what it appears after I run the first step,
DROP TABLE IF EXISTS admin;# MySQL returned an empty result set (i.e. zero rows).
CREATE TABLE admin(
admin_id int( 11 ) NOT NULL AUTO_INCREMENT ,
admin_name varchar( 32 ) NOT NULL default '',
admin_email varchar( 96 ) NOT NULL default '',
admin_pass varchar( 40 ) NOT NULL default '',
admin_level tinyint( 1 ) NOT NULL default '1',
PRIMARY KEY ( admin_id ) ,
KEY idx_admin_name_zen( admin_name )
) TYPE = MYISAM ;# MySQL returned an empty result set (i.e. zero rows).
and when I run the second step this is what I get,
Error
SQL query:
NSERT INTO admin VALUES ( 1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1 )
MySQL said: Documentation
#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 'NSERT INTO admin VALUES (1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b50' at line 1
What should I do???
Looks like you missed the I on the word INSERT ... :unsure:
I can not login too
When I use right user name and password it refreshs login page instead of proceeding admin-index page. If -either- password or username is wrong it gives "You entered the wrong username or password." warning message.
My solution is : If I am using Firefox, if there are multiple tabs or not, all firefox windows must be closed down.. Reopen fresh firefox window and try again to access, that time it enters admin area. OR, if it fails to enter in firefox, I do open another internet explorer window from there I am able to access. What could be causing it I don't know but something regarding the way browser's handling of zen cart/php codes. Or maybe something new, trojan (even my multiple trojan cleaners can not detect) or else causing failed access attempt
I hope this may help some of you.
Thanks for posting the update of what works for you ...
My trick that works in FireFox ... is to delete the cookie for the specific domain that I am working for ... sometimes that will save a step ...
If not, the close all browser windows ... clear cache ...
If not, do both ... :smile:
:frusty::censored: I've tried this steps for over a month now, and I can't log in to my site. I really don't know what to do!!! Please what else can I do?
I have exactly the same problem - cannot login to the admin panel - doesnt matter if I use firefox, internet explorer or whatever, whether I clear the cache, drop and recreate the default admin tables its always the same - returns to the login screen with no warning (if you deliberately put in an incorrect username or password, it tells you, type in the correct one, just refreshes the page.)
In short this is a disaster - i cant tell my client how to fix it and I cant login. Im at a total loss. :(
If you could drop me a PM, I can try to help you out of this mess to see if it is you or something with your setup ... :smile:
Many thanks Ajeh, :smile:
PM on its way to you.
Cheers,
Dan.
Since I have enabled SSL, I cannot log into Zen Cart with the current username and password. So I tried rebuilding the Admin table with the default settings via phpMyAdmin (Ajeh's recommendation). It didn't work. I tried disabling SSL, made sure that my configure files were writable, and applied Ajeh's process again...and it didn't work. What do you recommend I do?
I've tried installing a new Zen Cart store and couldn't log into that one either. Please help.
Thank you,
Herbalto
Check the files.on the server, for:
/includes/configure.php
/admin/includes/configure.php
are they both using the same paths, database, username and password?
Can you login to the Catalog?
Have you ever been able to login?
Hello and thank you for responding...I've checked both files (/includes/configure.php and /admin/includes/configure.php) and both are using the same paths, database, username and password.
In the past, I have been able to log into the catalog, upload a completely new template, and make significant changes, but just recently I was unable to log into Zen Cart when I enabled the SSL.
I've talked to a representative of BlueHost and he said that they were unable to help me. Is there another way to reset it? My client wants to test her site but I'm unable to log into Zen Cart to erase the current "fake" customers so that we can test it properly. Whenever I create a new "fake" customer via the actual web site and I use my email address, it says that I cannot re-use the same email address for another "fake" customer.
I really appreciate your help with this...and also am impressed with how secure you've created this site to be.
Waiting patiently,
Herbalto
Can you login as a customer on your shop?
If you turn off the Enable on the SSL in the Admin configure.php can you login?
It would help to be able to see your configure.php files, from the server, without your username or password ...
Did you go through the steps of closing all browsers, clearing your cache and cookies and then trying to login?
It sounds like an issue with your secure server URLs or perhaps there is an issue on the secure server and your hosting provider needs to restart the secure server ...
I had this exact same problem. It's pretty frustrating. However, the issue seems to be a problem with storing sessions in the database. When I changed my config to the default session storage, things returned to normal.
I haven't dug into the root problem, but this work-around should help.
I am having the same problem as others, I cannot get logged in to the admin account.
I just forgot my username and password for the site, so I went through and ran the scripts but when I try to login as Admin \ admin I get error 401 unauthorized, you failed to provide a valid account required for access to page in firefox, and when I try in IE it just brings up the display box again asking for username and password. I have tried resetting cookies and cache etc. in both browsers and even tried logging in from a different computer. Everything with the site seems to be working fine I just can't get logged in as Admin.
Any other suggestions of things I could try?
I have spent an inordinate amount of time attempting to login in to admin with new install of 1.3.8. I have read the majority of posts and suggestions that have been made have been tried.
URL for new store is:
http://www.lindarobertsgallery.info/store
Here's copy of configuration file:
<?php
/**
* @package Configuration Settings circa 1.3.8
* @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
*/
/*************** NOTE: This file is similar, but DIFFERENT from the "store" version of configure.php. ***********/
/*************** The 2 files should be kept separate and not used to overwrite each other. ***********/
// Define the webserver and path parameters
// Main webserver: eg-http://www.your_domain.com -
// HTTP_SERVER is your Main webserver: eg-http://www.your_domain.com
// HTTPS_SERVER is your Secure webserver: eg-https://www.your_domain.com
// HTTP_CATALOG_SERVER is your Main webserver: eg-http://www.your_domain.com
// HTTPS_CATALOG_SERVER is your Secure webserver: eg-https://www.your_domain.com
/*
* URLs for your site will be built via:
* HTTP_SERVER plus DIR_WS_ADMIN or
* HTTPS_SERVER plus DIR_WS_HTTPS_ADMIN or
* HTTP_SERVER plus DIR_WS_CATALOG or
* HTTPS_SERVER plus DIR_WS_HTTPS_CATALOG
* ...depending on your system configuration settings
*
* If you desire your *entire* admin to be SSL-protected, make sure you use a "https:" URL for all 4 of the following:
*/
define('HTTP_SERVER', 'http://www.lindarobertsgallery.info');
define('HTTPS_SERVER', 'https://www.lindarobertsgallery.info');
define('HTTP_CATALOG_SERVER', 'http://www.lindarobertsgallery.info');
define('HTTPS_CATALOG_SERVER', 'https://www.lindarobertsgallery.info');
// Use secure webserver for catalog module and/or admin areas?
define('ENABLE_SSL_CATALOG', 'false');
define('ENABLE_SSL_ADMIN', 'false');
// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
// these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
define('DIR_WS_ADMIN', '/store/admin/');
define('DIR_WS_CATALOG', '/store/');
define('DIR_WS_HTTPS_ADMIN', '/store/admin/');
define('DIR_WS_HTTPS_CATALOG', '/store/');
define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_CATALOG_IMAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'images/');
define('DIR_WS_CATALOG_TEMPLATE', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/templates/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
define('DIR_WS_CATALOG_LANGUAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/languages/');
// * DIR_FS_* = Filesystem directories (local/physical)
//the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
define('DIR_FS_ADMIN', '/var/www/vhosts/lindarobertsgallery.info/httpdocs/store/admin/');
define('DIR_FS_CATALOG', '/var/www/vhosts/lindarobertsgallery.info/httpdocs/store/');
define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
define('DIR_FS_CATALOG_TEMPLATES', DIR_FS_CATALOG . 'includes/templates/');
define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');
define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', '******');
define('DB_SERVER_PASSWORD', '********');
define('DB_DATABASE', '*******');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'db');
// for STORE_SESSIONS, use 'db' for best support, or '' for file-based storage
// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from: none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'file');
define('DIR_FS_SQL_CACHE', '/var/www/vhosts/lindarobertsgallery.info/httpdocs/store/cache');
// EOF
I've setup numerous other installations of ZenCart and never had this much trouble to get a new installation up and running. Setup for this is similar to another cart which is 1.3.7 and its working fine.
I have correct permissions on cache directory. I don't have SSL running and its set to "false". I've checked database name, username and password and that's correct. I've cleared cookies, cache etc in web browser. PHP version is 4.3.1. Any other suggestions to attempt to resolve?
also I have same problem, I had to upgrade the site on a hosting and ok, then I did new installation on a new server dedicated, ok, then I transfered database and files, and ok.
And now I see store but I can't login, I saw the faq to reset admin but it doesn't go.
And the email doesn't function because really I installed the system on a dedicated server identified with a number, then I will configure mail and other, so I think it is this because don't send email.
Please, I did all correctly now it misses only the login.
How can I do?
Please
:cry::cry:
I have moved to a different server. Site is up and running ok, all products displaying.
But I cant login. I sent a new password and tried using that and it still wont let me into admin.
I created a new customer account with new email address and password. I could not login in there either. I even got an email indicating that I have a new customer. So the database end of business is working.
What could be causing the blocking of anyone logging in?
I solved with this
http://www.zen-cart.com/index.php?ma...products_id=82
I don't have do step by step procedure for move to another host.
Sorry, but I solved so.
And without apply the two patch codes above.
Thank you very much
I hope you solved too
:clap:
You can try, but before try delete old sql and reimport sql in this way and then applicate the fix (file goes in the root directory of store) in this way you can use your password and not Admin and admin. I did so.
That didnt help.
Oddly, the other website I have works fine on the same server.
Yikes
V1.36
Logged into a test directory of v138 ok
My new server is 5.2.
are you italian?
pixel...padre
I don't understand if you have solved at last
:smile:
I am upgrading to 1.38 and hope that it will work better. My other store was 1.38.
yup, that was the problem. I was running zc1.36 with php 5.2.
Fix cache key doesn't work but I appreciate the input. I have used that solution when changing a shopping cart from one server to another but shouldn't be needed on a fresh install. I did at least confirm that I writing to the correct cache directory.
I'm ready to dial back to 1.3.7 as I have multiple ZenCart stores running on my server without login issue unless someone else on the ZenCart forum has any other ideas....
Cheers,
Gene Fourney
InteractiveWest
Have you tried another re-install of the newer code? Perhaps something went wrong in your upload/install? Or maybe you've used a faulty one-click install offered by the hosting company?
Or there's the related FAQs on the topic:
- https://www.zen-cart.com/tutorials/i...hp?article=281
- https://www.zen-cart.com/tutorials/index.php?article=84
After spending 2-3 weeks trying to salvage my old ZC1.36 website, I have come to the rational conclusion that no one should ever attempt to recontstruct an outdated website.
I used WinMerge as suggested, but there were more than 3000 files that had some minor differences, including white spaces. It was a daunting task. And after making all the changes and uploading, I still couldnt login.
My solution....
I simply installed the latest version and made the mods that I needed to get back the way it was. Most of those changes were in the stylesheet file.
I had several different mods on my original site. In time, if I think they are necessary I will add them. But for right now, I have my site back and I am back in business.
IMHO don't EVER waste your time trying to save your old website. Just update your database to the latest via the Install routine. Then install the latest ZC.
My site is now better looking and faster.
I thought I would update all on this forum on admin login issue that we were able to resolve on our end. After uninstalling 1.3.8 and installing older version 1.3.7 I still wasn't able to login to Admin. After talking with my server admin and errors I was seeing on initial configuration page we edited PHP Safe Mode on our server to "Off" and was able to login. Now reinstalling 1.3.8 version of ZenCart which we believe will work.
Thought I'd give you another update. 1.3.7 version works when PHP Safe Mode is set to "Off" on our server and able to login to admin only with Firefox browser. IE6 browser won't let me login.
I tried reinstalling 1.3.8 as I'd like to be able to use the latest version but I was unable to login to Admin even after PHP Safe Mode was set to "Off".
Here's what we're running on our server:
Apache: 2.046.71
MySQL: 4.1.21
PHP: 4.3.2
Please read my advice above.
Its worth mentioning that after not having a sale for 2 months, my new look snagged a sale only a few days after the new install.
the voice of experience
after setting up some redirects yesterday, I am now no longer able to log into my website.com/admin area. I used the sql script mentioned earlier in this thread with no success. I need to access the admin area as soon as possible. please pm me for any other information that is needed as I don't want my web address to be listed in this post.
Thanks in advance for all your help.
thank you Dr. Byte for your prompt reply. That has been done. Now when I go to the admin area in my browser I get the following error....
Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home4/capturf6/public_html/admin/includes/classes/logger.php:127) in /home4/capturf6/public_html/includes/functions/sessions.php on line 108
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home4/capturf6/public_html/admin/includes/classes/logger.php:127) in /home4/capturf6/public_html/includes/functions/sessions.php on line 108
Warning: Cannot modify header information - headers already sent by (output started at /home4/capturf6/public_html/admin/includes/classes/logger.php:127) in /home4/capturf6/public_html/admin/includes/init_includes/init_templates.php on line 71
Warning: Cannot modify header information - headers already sent by (output started at /home4/capturf6/public_html/admin/includes/classes/logger.php:127) in /home4/capturf6/public_html/admin/includes/functions/general.php on line 41
by the way, I still cannot log into admin after removing the redirects.
Similar problem but was not messing with admin settings. I had just updated a lot of products and logged out. Next time i try to log in and enter admin/pass and click to log in, it just clears the fields but does not log me in.
I tried the "resend pass" option. When I enter the email and click it just clears the field but I never receive any email with the password.
I will try to use the SQL method to reset to temporary password but wondering still...why would an functional log in just decide not to work?
:blush:
Usually when the log in does not work as in you enter your login information and click Login and just get the login page again it is either:
1 bad username or password note: these are case sensative
2 bad paths on the /admin/includes/configure.php
If the email is not working, I have to think you need to check your database table admin and confirm the username and email address ...
There could also be an issue on your server with the email itself or a configuration issue on your settings for emails ...
See if checking the admin table sheds any light ...
I cannot login to save my life. I have changed codes, and changed passwords in both admin sections, and pasted the codes, and still nothing. I just started on this today and NONE of the user names/passwords work. emailing the password to my email doesnt work either.
First ...
1 Can you get to your shop Home page?
2 Can you login/create an account on your shop?
3 Can you get to your Admin login page?
4 If you get to the Admin login page and try to login ... what happens? Do you see the Admin menus or do you still see the login screen again?
I can get to the homepage.
I can also get to the admin logon page.
It just keeps telling me wrong name or paswword, and I wrote them down at first. Since changing and trying your script code to reset it, still not working.
I did create a customer page for myself, but still have not received a confirmation email.
I've never even been able to log in and see an admin page, still working on password correction.
I have a kill command in the process list.
thank you!
Cristine
You created an account in the shop ...
When not logged in ...
Add a product to the cart ...
Now Login ...
Could you log in?
Is that product still in the cart?
If so ... check the two configure.php files ...
They are different, but similar ...
Make sure the paths, databases etc. are the same ...
Sometimes, closing your browser sessions, clearing cache and tossing your cookies ... er ... deleting the cookies for your site will fix this ... :cool:
this is my first log in ever...
there are no products because I've never even used this site before.
the site is still in it's original form.
i have been into the admin and zen_admin and made sure the user names and passwords matched and were correct and also the email address and still nothing.
You need to compare the contents of the two files on the server for:
/includes/configure.php
/admin/includes/configure.php
Make sure both of those are set for the same URLs, paths, database info, username and passwords ...
If the paths are incorrect or the login and password in the database for the Admin login are incorrect you will have a problem ...
If your Admin login stays on the login page itself on each attempt, be sure you that the username and password you are using is correct and remember this is case sensative ...
If you still cannot login, do you have access to your database via phpMyAdmin?
OK. So this morning I had a crapload of emails with new passwords in them. Guess they were hung up in the email server or something.:D
So went back to log in page, and tried to log in. Wrong PW. I had a new password resent, and that one arrived quickly but doesn't work either, so now it must be the user name. :blush:
:wacko:
I can get into the phpmyadmin info.
When I go into the php info, the user names are listed as Admin or admin, and then there's the long numbers and letters for the random password that gets sent to my email.
Should those admin and Admin be the same? it's in zen_admin and admin files.:yuck:
I am not sure why you would get that error as the first drops the table and rebuilds it and the second adds the login ...
NOTE: make sure that you are not using prefixes on your database table names ... if you are, you will see it referenced in your two configure.php ...
[FONT=Verdana]I just reset my hosting account and install new zen cart. After the installation I have uploaded the backup files/folders (+mysql database) to the new zen cart directory except the 2 configure.php files (to prevent from being overwritten).
The website was fine but I can't login to the admin. I enter my new username & password. But it keeps saying 'You entered the wrong username or password'. Anyone know what cause the problem? Is there any file I shouldn't overwrite?[/FONT]
Use the post above that I made for recreating the table and inserting the default login ...
Once you are logged in, then change the Admin login and password to your own ...
I tried the post above but it still says 'You entered the wrong username or password'.
Admin Username:Admin
Admin Password: admin
Can you check the file, on the server, for:
/admin/includes/configure.php
Make sure you are using the right database ...
Make sure that if you are using a prefix on your database tables that you alter the SQL statements to include those on the database ...
Is this what you meant by prefix?
How should I alter the SQL statements?PHP Code:
define('DB_PREFIX', 'zen_');
Code:DROP TABLE IF EXISTS YOURPREFIXHERE_admin;
CREATE TABLE YOURPREFIXHERE_admin (
admin_id int(11) NOT NULL auto_increment,
admin_name varchar(32) NOT NULL default '',
admin_email varchar(96) NOT NULL default '',
admin_pass varchar(40) NOT NULL default '',
admin_level tinyint(1) NOT NULL default '1',
PRIMARY KEY (admin_id),
KEY idx_admin_name_zen (admin_name)
) TYPE=MyISAM;
NOTE: the prefix is case sensativeCode:INSERT INTO YOURPREFIXHERE_admin VALUES (1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);
Also, if you see both a table called:
admin
zen_admin
And you are using the prefix on your database tables, as in all start with YOURPREFIXHERE_, then the admin table should not be there ...
Finally! Thank you Ajeh. :D
You are most welcome ... :smile:
Thanks for the update that you are using table prefixes on your database and needed to update your admin table using the table prefix in the SQL statements ...
Hi,
I thought did the rest but I think I dropped the zn_admin...before running the script or something...
when I try to log in I get:
zc_admin' doesn't exist
Can I rebuild it?
Lasa
The code in post #87 will rebuild the table ... if you need to be sure to put your prefix where it is marked in red ... if you do not use a prefix then remove the YOURPREFIXHERE_ ...
You can run it in phpMyAdmin to fix the missing admin table from your database ...
Then, the login will be:
Admin
admin
until you update the Admin login ... which you will want to do immediately once you get into your Admin ... :smile:
HI Linda, I followed the directions in this thread to reset the Admin through mysql. This may be a dumb question but what exactly am I entering in the use name box 1. Admin or 2. Admin admin?
Then am I using the reset password that was sent to us? Or am I misunderstanding and should be using Admin username with admin password?
It's been a while since I have needed to ask a question. I really appreciate your help.
Here is the link to log in:
http://rockngemsnjewels.com/zencarts...dmin/login.php
I can email you the password that was sent to us.
I am wondering if somehow the client reset the password again and if I should just request one final password and then try using admin as the user name?
The site is www.rockngemsnjewels.com I am not sure what version it is running. I think it is the one before the last update.
http://picasaweb.google.com/BrassWin...32951200625106
I also saw this link somewhere else but did not try this as perhaps it is just another way to do the same thing.
http://kb.siteground.com/article/How..._Zen_Cart.html
The code in post #81 is for sites that do NOT use a prefix on their databases tables to delete, create and setup a password with the login:
Login: Admin
Password: admin
The code in post #87 is to show where changes have to be made for sites that ARE using prefixes on their database tables ...
Both are made to delete ALL current Admin logins and create 1 valid login so that you can get into the Admin and add, edit etc. Admin logins ...
You can browse the admin table of your database first, to see what logins already exist so that you can re-create the ones that you need and see what email addresses are associated with them ...
If you just need to reset a password, that is what the Forgotten Password is for, and it will send a new password to the email address associated with the login and once logged in, you can reset the password to something else ...
I have setup a zencart 1.38a .it have be install the admin profiles 1.071, i reset password,I can enter admin control home,but i can'nt set any .enter :tool/ admin setting.(there is one user of admin)/permission, all item have be select.but i can'nt change it. how to get admin permission,in database admin permission set 1 ,but admin can't get permission,why.pl help!
Hi this is the info from the configure file on the server... I ahve been looking at the database with the user name starting wiht roc below.. what is the prefix 'zen_' ? Is that the regular one or something that is missing a word? I post another message saying there is a zen_admin section in the DB and also a admin section that shows the same as your post US= Admin admin@localhost password etc...
// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', 'p3nl50mysql9.secureserver.net');
define('DB_SERVER_USERNAME', 'roc....deleted to protect');
define('DB_SERVER_PASSWORD', ' deleted to protect cart ');
define('DB_DATABASE', 'roc0830703043489');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'db');
I am lost - thank you in advance..
Sheree
Gald that this helped ... be sure to edit your Admin login and set your username, email and password, now that this is working ... :smile:
Hi Ajeh,
Thanks for posting the code but I still am not having any success. I can open the database and notice that after running your first set of code the admin field and password is clear. Then I run the second set of code and Admin is filled in with the password when I browse my database. When I try and log in it still says incorrect password and username.
I have checked both Config.php files and the database settings all match.
Is the final option now to reload zen cart and then to try and import the database into the new installations? apart from this the site is upa nd running and I am processing orders.
Thanks in advance
Daniel
You are trying to login with:
Username: Admin
Password: admin
note upper and lower case.
Right?
Yep I am using the Admin and then admin but still giving me the incorrect login and password. :wacko: