Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2019
    Location
    UK
    Posts
    60
    Plugin Contributions
    0

    Default Database copy issue

    Hi, I copied the database from my live store into a fresh install of 1.5.7c so I could test a few things I want to try, but there seems to be a database issue,the admin page will not load.

    I've been reading about the fix_cache_key.php but that plugin says it is no longer required after 1.5.3 so is there something else I need to do?

    Thanks

  2. #2
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    8,095
    Plugin Contributions
    295

    Default Re: Database copy issue

    Are there log files in your /logs folder? If so, please post one.

    Take a look at

    https://docs.zen-cart.com/user/troub...not_connected/
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.

  3. #3
    Join Date
    Jan 2019
    Location
    UK
    Posts
    60
    Plugin Contributions
    0

    Default Re: Database copy issue

    Code:
    [29-Apr-2021 09:08:11 UTC] Request URI: /---ADMIN FOLDER---/index.php?cmd=login&camefrom=index.php, IP address: 195.162.105.81
    #1  mysqli_connect() called at [/home/thegluep/****.thegluepeople.co.uk/includes/classes/db/mysql/query_factory.php:63]
    #2  queryFactory->connect() called at [/home/thegluep/****.thegluepeople.co.uk/---ADMIN FOLDER---/includes/init_includes/init_database.php:18]
    #3  require(/home/thegluep/****.thegluepeople.co.uk/---ADMIN FOLDER---/includes/init_includes/init_database.php) called at [/home/thegluep/****.thegluepeople.co.uk/---ADMIN FOLDER---/includes/application_bootstrap.php:162]
    #4  require_once(/home/thegluep/****.thegluepeople.co.uk/---ADMIN FOLDER---/includes/application_bootstrap.php) called at [/home/thegluep/****.thegluepeople.co.uk/---ADMIN FOLDER---/index.php:5]
    --> PHP Warning: mysqli_connect(): (HY000/1044): Access denied for user 'thegluep_zc1'@'localhost' to database 'thegluep_zentest' in /home/thegluep/****.thegluepeople.co.uk/includes/classes/db/mysql/query_factory.php on line 63.
    Thanks. It does seem to be a DB connection error, but I reuploaded the zc_install folder to clean up my errors and get back into the admin backend. So I'll try again and pay closer attention to what I'm doing. The database and user seem to be correct, but I did just notice in myPhpAdmin that the copy of the database I made does not have zen_ table prefixes so that may possibly be where I went wrong.

    Is the 'repair database' in Cpanel performing the same function as the fix_cache_key plugin?

  4. #4
    Join Date
    Oct 2008
    Location
    Croatia
    Posts
    1,365
    Plugin Contributions
    15

    Default Re: Database copy issue

    A *copy* of a database would preserve prefixes...

    Are you sure you assigned the user to that database and granted all privileges in cPanel?

    Repair database is completely different and you only need it if your DB has crashed. And the "fix_cache_key" - you can forget about that, that was for olders Zen Cart versions and is no longer needed.
    Zen Cart Point of Sale? Sure: ZX POS - v2 released
    My site - Pro ZC Help | My portfolio | My plugins

  5. #5
    Join Date
    Jan 2019
    Location
    UK
    Posts
    60
    Plugin Contributions
    0

    Default Re: Database copy issue

    I think what I may have done is copied the database then run the zc_install, and during that process I forgot to put anything in the prefix field so the installer removed the prefixes while creating the zen cart data.

  6. #6
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    8,095
    Plugin Contributions
    295

    Default Re: Database copy issue

    Sounds like you're good to go then.

    Prefix problems are actually so common that I refactored the help page I linked above so that prefix issues are called out as the first item.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.

 

 

Similar Threads

  1. v156 database copy
    By donhorn in forum General Questions
    Replies: 0
    Last Post: 26 May 2019, 07:56 PM
  2. v152 How can copy some products from database to another database ?
    By dmagic in forum General Questions
    Replies: 5
    Last Post: 2 Jul 2018, 02:54 PM
  3. v150 Copy template issue
    By xionglonghui in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 22 Dec 2013, 05:20 PM
  4. v139h copy of database
    By Stevie-B in forum Upgrading to 1.5.x
    Replies: 1
    Last Post: 29 May 2012, 01:21 AM
  5. Database Copy
    By PortMan in forum General Questions
    Replies: 1
    Last Post: 15 Sep 2006, 04:52 AM

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