Cannot log into admin

[bigt]

When I try to get to admin I type in www.nutsfortrucks.com/store/admin this is what I get...

1146 Table 'myusernamehere_zc1.zen_admin' doesn't exist
in:
[select * from zen_admin where admin_name='demo' or admin_name='Admin']
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've found and checked out my Database in my includes/configure file, I cannot find another configure file, it's just not there I've looked for it for 2 days now. I finally found where I can get to my phpmyadmin from my cpanel... But I'm not sure what it is I'm supposed to look for in there.

Any suggestions on how to fix this? Thanks!

This is the configure file that I've found...

<?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
*/


// Define the webserver and path parameters
// Main webserver: eg, http://localhost - should not be empty for productive servers
// HTTP_SERVER is your Main webserver: eg, http://www.yourdomain.com
// HTTPS_SERVER is your Secure webserver: eg, https://www.yourdomain.com
// HTTP_CATALOG_SERVER is your Main webserver: eg, http://www.yourdomain.com
// HTTPS_CATALOG_SERVER is your Secure webserver: eg, https://www.yourdomain.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
*/
define('HTTP_SERVER', 'http://www.nutsfortrucks.com');
define('HTTPS_SERVER', 'https://www.nutsfortrucks.com');
define('HTTP_CATALOG_SERVER', 'http://www.nutsfortrucks.com');
define('HTTPS_CATALOG_SERVER', 'https://www.nutsfortrucks.com');

// Use secure webserver for catalog module and/or admin areas?
define('ENABLE_SSL_CATALOG', 'true');
define('ENABLE_SSL_ADMIN', '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_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', '/home/nixnutz/public_html/store/admin/');
define('DIR_FS_CATALOG', '/home/nixnutz/public_html/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', 'zen_');
define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty
define('DB_SERVER_USERNAME', 'xxxxxxxxx');
define('DB_SERVER_PASSWORD', 'xxxxxxxx');
define('DB_DATABASE', 'nixnutz_zc1');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // leave empty '' for default handler or set to 'db'

// 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', 'database');
define('DIR_FS_SQL_CACHE', '/home/nixnutz/public_html/store/cache');

?>

[Ajeh]

In phpMyAdmin when you look at the table names of that database nixnutz_zc1 do you see a table called:
zen_admin

or a table called
admin

Do you see a table called:
zen_products

or a table called:
products

[bigt]

I see one called zen_admin_activity_log but that's the only admin one I can see. Yes I can see one called zen_products.

[Ajeh]

Somewherre along the way you trashed the admin table ...

Run this in your phpMyAdmin SQL for that database ...

DROP TABLE IF EXISTS zen_admin;
CREATE TABLE zen_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; 

Then run this:

INSERT INTO zen_admin VALUES (1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1); 

This will make the login:
Admin
admin

Then go to Tools ... Admin Settings ... and change the email and login information to your own ...

[bigt]

Hey Your the best!! I got the php codes to run. The only thing I cannot get and don't understand is where I get to the tools... admin settings...

[bigt]

Ok... I figured it out!! Thanks you've made my day! I've been stressing about this for 2 days now. I can enjoy the weekend!!! I really appreciate your help!!!

[Ajeh]

No need to send flowers ... just throw money ...

Glad you are back on track again ...

[krizzle]

Ajeh, thanks for that tip. I did the very same thing and it worked in PHPadmin, but i still can't get in.

This site has gone through lots of changes since Feb. I'm literally just trying to get into admin to get my client all of the customer data that he needs.

A few things that are happening when I plug in username: admin password: admin


It redirects me to the /denied.php page. This page was part of the module I added for admin_profiles 1.0.4. I'm wondering if that is the issue.....

or that I went from a Dedicated IP to a Shared IP. I don't think so though, because I was careful to change the IP addresses in the configure.php file.

I just need to get this data to them right away...

any thoughts?

Thank you so much.

[krizzle]

also, the collation is set to latin1_swedish_ci. could that have something to do with it?

[krizzle]

Ah!! Capital "A" in Admin!!! Yikes. Lack of sleep will do that to you.

Thanks. I owe you that coffee. how do i send it?