Admin USer & Password no loner work.
Hi Zenners,
For some reason my User and Password do not work to my Zencart Admin panel any more! I tried to resend a new password but this does not help. I tried to use the old User and Admin but I still can not get in.
I tried to use the resetting via phpMyAdmin with the code given in the lost password article, but this does not help. Any answers as to what I could do?
Thanks in Advance
Jamie
Down Under
Re: Admin USer & Password no loner work.
Using phpMyAdmin you can fix this by dropping and recreating the admin table and adding a default login and password:
PHP 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)
) TYPE=MyISAM;
Next run this to set the login to Admin/admin:
Reset login and password to: Admin admin
PHP Code:
INSERT INTO admin VALUES (1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);
WARNING: be sure to reset the Admin login as soon as you have access for the Admin password and email address ... in Tools ... Admin Settings ...
Re: Admin USer & Password no loner work.
NOTE: if using prefixes on your database table names such as:
zen_admin ... you will need to alter that fix for your specific prefix ...
Re: Admin USer & Password no loner work.
Hi Linda,
Unfortunatly this is what i have already done (as stated above)! But sayingthat I am most likely doing it wrong.
Here is the error.....
Fatal error: Call to a member function Execute() on a non-object in /home/ausjamuu/public_html/includes/functions/sessions.php on line 61
I log onto my servers cpanel, MySQL Account Maintenance, phpMyAdmin. Then I run the script in Run SQL query/queries on databsae(my databse is listed here). It then comes back with an error. If this is incorrect, what tab should I be looking for to run these scripts?
Thanks
jamie
Re: Admin USer & Password no loner work.
That is a php 5.2.0 bug ...
The fix for the sessions.php files are at:
http://www.zen-cart.com/forum/showpo...7&postcount=26
Note: this php bug has been addressed in the current Zen Cart v1.3.7 until php fixes the bug themselves ...
Re: Admin USer & Password no loner work.
Ok Great.
I have done the above mod to the file. Now do I apply the php code again as I tried previously? Now I know nothing about php so be gental!
Or would I be better of applying the latest Zen-Cart upgrade?
I also have a complete backup I can reload, or will my problem still exist?
Thanks for your time
Re: Admin USer & Password no loner work.
Personally I would upgrade ...
Upgrades contain bugfixes, security fixes, new features, etc. ...
Backup both your database and site ... and go for the upgrade ... take your time and you will be glad that you did in the end ... :smile:
Re: Admin USer & Password no loner work.
Hi Everyone.
I can't login to my admin either. Very disturbing considering I was just about to launch the site. I've tried every thing on this thread and several other with no success. My database has no prefixes, so I used the appropriate SQL code. I still not get response from Admin/admin.
I recently fowarded the domain thesiteguys.com, to siteguys.com. Could that be part of the issue? I made the URL change in the configure.php file so the browser points to the correct place. There must be a way to fix this issue. Does anyone have any advice or point me in another direction?
Thanks in advance.
Re: Admin USer & Password no loner work.
please post your admin/includes/configure.php without your password.
Re: Admin USer & Password no loner work.
Kim,
Here's the config file:
<?php
/**
*
* @package Configuration Settings
* @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
*/
/*************** NOTE: This file is similar, but DIFFERENT from the "admin" version of configure.php. ***********/
/*************** The 2 files should be kept separate and not used to overwrite each other. ***********/
// Define the webserver and path parameters
// HTTP_SERVER is your Main webserver: eg, http://www.yourdomain.com
// HTTPS_SERVER is your Secure webserver: eg, https://www.yourdomain.com
define('HTTP_SERVER', 'http://www.siteguys.com');
define('HTTPS_SERVER', 'https://www.siteguys.com');
// Use secure webserver for checkout procedure?
define('ENABLE_SSL', 'true');
// 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_CATALOG', '/cart/');
define('DIR_WS_HTTPS_CATALOG', '/cart/');
define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_INCLUDES', 'includes/');
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_DOWNLOAD_PUBLIC', DIR_WS_CATALOG . 'pub/');
define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/');
define('DIR_WS_PHPBB', '/');
// * 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_CATALOG', '/kunden/homepages/40/d207247386/htdocs/cart/');
define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/');
define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS);
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');
// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'db987.perfora.net');
define('DB_SERVER_USERNAME', 'dbo207323645');
define('DB_SERVER_PASSWORD', '');
define('DB_DATABASE', 'db207323645');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // 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', 'none');
define('DIR_FS_SQL_CACHE', '/kunden/homepages/40/d207247386/htdocs/cart/cache');
?>