Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2007
    Posts
    73
    Plugin Contributions
    2

    Default cannot update database

    I installed on localhost my upgraded store w/o products. Then I went into myphpadmin and imported my database. My store says I need to upgrade the database (expected) so I run the update. But I get stumped at entering my admin name and password. It says it is not correct! Both the local install and the live store database I imported are the same admin and password. Any idea why I cannot log in?

  2. #2
    Join Date
    Feb 2006
    Location
    Chicago
    Posts
    1,162
    Plugin Contributions
    0

    Default Re: cannot update database

    What error message you are getting
    Also did you overwrite the login.php in the template directory?
    Tutorials on Zen Cart
    http://tutorials.zen-cart.com/index.php
    ---------------
    advanced.programmer at gmail dot com
    In love with Zen Cart!!

  3. #3
    Join Date
    Sep 2007
    Posts
    73
    Plugin Contributions
    2

    Default Re: cannot update database

    I get this error: ATTENTION: Problems Found

    * Admin Password required to proceed with upgrade more info...

    Now it is like my passwords won't work. Obviously I won't take this to a live site until I can get the database to upgrade. Also, I cannot log into the admin area after the database is merged.

  4. #4
    Join Date
    Feb 2006
    Location
    Chicago
    Posts
    1,162
    Plugin Contributions
    0

    Default Re: cannot update database

    Login to phpmyadmin and run the update sql
    and then try this
    https://www.zen-cart.com/tutorials/index.php?article=2
    Tutorials on Zen Cart
    http://tutorials.zen-cart.com/index.php
    ---------------
    advanced.programmer at gmail dot com
    In love with Zen Cart!!

  5. #5
    Join Date
    Sep 2007
    Posts
    73
    Plugin Contributions
    2

    Default Re: cannot update database

    Thank you. That worked. Any idea why it would have 'lost' my admin password?

  6. #6
    Join Date
    Feb 2006
    Location
    Chicago
    Posts
    1,162
    Plugin Contributions
    0

    Default Re: cannot update database

    Not really sure but sometimes it does happens during the upgrade!
    Tutorials on Zen Cart
    http://tutorials.zen-cart.com/index.php
    ---------------
    advanced.programmer at gmail dot com
    In love with Zen Cart!!

  7. #7
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: cannot update database

    Quote Originally Posted by superprg View Post
    Not really sure but sometimes it does happens during the upgrade!
    It only "happens during the upgrade" if you somehow break the data during an export/import or if you are pointing to the wrong database in your configure.php files.
    The upgrade itself will not "lose" your admin details.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  8. #8
    Join Date
    Sep 2007
    Posts
    73
    Plugin Contributions
    2

    Default Re: cannot update database

    ah, that makes sense. In my myphpadmin in the import section has the 'break up' checked by default.

    ---->
    Partial import
    Allow interrupt of import in case script detects it is close to time limit. This might be good way to import large files, however it can break transactions. <----

 

 

Similar Threads

  1. Replies: 3
    Last Post: 4 Mar 2013, 04:46 AM
  2. cannot create session when trying to update database
    By brad_at_foreverybody in forum Upgrading from 1.3.x to 1.3.9
    Replies: 12
    Last Post: 27 Oct 2010, 09:07 PM
  3. Update to 1.3.8a Probblems after Database Update
    By wirnsperger in forum Installing on a Linux/Unix Server
    Replies: 0
    Last Post: 4 Feb 2010, 06:41 PM
  4. 1217 Cannot delete or update
    By tsweany in forum Installing on a Windows Server
    Replies: 3
    Last Post: 27 Apr 2009, 10:10 AM
  5. Cannot Update Database
    By f_raze1 in forum Installing on a Linux/Unix Server
    Replies: 3
    Last Post: 22 Mar 2007, 02:59 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