Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 33
  1. #21
    Join Date
    Oct 2007
    Posts
    134
    Plugin Contributions
    0

    Default Re: Admin USer & Password no loner work.

    Quote Originally Posted by barco57 View Post
    do you have a prefix on your database tables? (i.e. zen_)
    I think no. I am using the system as default.

  2. #22
    Join Date
    Apr 2006
    Location
    West Salem, IL
    Posts
    2,739
    Plugin Contributions
    0

    Default Re: Admin USer & Password no loner work.

    you'll need to confirm whether or not you are using prefixes on the database. Easy to do in phpmyadmin...does the admin table just say admin or does it say zen_admin or something like that.
    Mike
    GeekHost - Zen Cart Certified & PCI Compliant Hosting
    The Zen Cart Forum...Better than a monitor covered with post-it notes!

  3. #23
    Join Date
    Oct 2007
    Posts
    134
    Plugin Contributions
    0

    Default Re: Admin USer & Password no loner work.

    Posted via Mobile Device

  4. #24
    Join Date
    Oct 2007
    Posts
    134
    Plugin Contributions
    0

    Default Re: Admin USer & Password no loner work.

    When I run this command:

    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;

    then the message I receive is this:

    Your SQL query has been executed successfully

    SQL query:
    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).



    Now, you can see if the table consists of any prefix or not.

    I have not much knowledge about this php and all that.
    If you can help me, then i will be very thankful to you.

    regards and hoping to receive an answer early.

  5. #25
    Join Date
    Oct 2007
    Posts
    134
    Plugin Contributions
    0

    Default Re: Admin USer & Password no loner work.

    I found it ......

    it is zen_admin in the table.
    now what to do, please reply soon... thanks.

  6. #26
    Join Date
    Apr 2006
    Location
    West Salem, IL
    Posts
    2,739
    Plugin Contributions
    0

    Default Re: Admin USer & Password no loner work.

    These are the sql statements that you need. Notice the only thing I changed was to put the zen_ before the table name.
    Code:
     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)
    ) TYPE=MyISAM;
    then
    Code:
     INSERT INTO zen_admin VALUES (1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);
    take notice of the difference Admin (username), admin (password)
    Mike
    GeekHost - Zen Cart Certified & PCI Compliant Hosting
    The Zen Cart Forum...Better than a monitor covered with post-it notes!

  7. #27
    Join Date
    Oct 2007
    Posts
    134
    Plugin Contributions
    0

    Default Re: Admin USer & Password no loner work.

    I pasted the same codes given by you in SQL tab.

    the first code and then closed the run query window and then again opened it and pasted the second code.
    But I am still unable to login using username Admin and password admin.

    please suggest where am I wrong.

    thanks.

  8. #28
    Join Date
    Oct 2006
    Location
    Alberta, Canada
    Posts
    4,571
    Plugin Contributions
    1

    Default Re: Admin USer & Password no loner work.

    The Admin login page has a link to "Resend Password". Have you tried that?

    Note: you would have to verify that "zen_admin" TABLE is using one of your eMail addresses.

  9. #29
    Join Date
    Oct 2007
    Posts
    134
    Plugin Contributions
    0

    Default Re: Admin USer & Password no loner work.

    How can I check that the zen_admin table is using my email address : muteyaar######################

    please help me, I am in real trouble.

    or can you please check out my control panel and repair the thing?

  10. #30
    Join Date
    Oct 2007
    Posts
    134
    Plugin Contributions
    0

    Default Re: Admin USer & Password no loner work.

    I looked up at the zen_admin table and found that the admin name is muteyaar and the admin email is muteyaar###################### , which my own email address.

    now what should I do? please suggest.
    thanks.

 

 
Page 3 of 4 FirstFirst 1234 LastLast

Similar Threads

  1. Admin User Name and password
    By asherr6 in forum Basic Configuration
    Replies: 5
    Last Post: 20 Jan 2010, 11:06 PM
  2. ADMIN user does not work! can resend PW but admin name wrong?
    By catalinabydesign in forum General Questions
    Replies: 3
    Last Post: 23 May 2009, 11:47 AM
  3. Admin User Groups & User Permissions
    By haleyjo in forum Customization from the Admin
    Replies: 4
    Last Post: 20 Nov 2007, 08:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR