Thread: Empty database?

Page 1 of 3 123 LastLast
Results 1 to 10 of 22
  1. #1
    Join Date
    Sep 2006
    Location
    Suffolk, UK
    Posts
    73
    Plugin Contributions
    0

    red flag Empty database?

    Hi

    I would like to download my stock database. When going to phpmyadmin in the cpanel the stock database shows as containing 0 products.
    Where do I find my stock?
    Have I gone loopy?

    Thanks, Tina

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Empty database?

    Check your /includes/configure.php and make sure that you are using the right database, server, path etc.
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Nov 2004
    Location
    Norfolk, United Kingdom
    Posts
    3,036
    Plugin Contributions
    2

    Default Re: Empty database?

    If the products still show up on your website then they're in some database somewhere.

    Vger

  4. #4
    Join Date
    Sep 2006
    Location
    Suffolk, UK
    Posts
    73
    Plugin Contributions
    0

    Default Re: Empty database?

    Check your /includes/configure.php and make sure that you are using the right database, server, path etc.
    Ajeh
    I wouldn't have a clue where to look. The shop was originally installed by rentacart.co.uk
    Tina

  5. #5
    Join Date
    Nov 2004
    Location
    Norfolk, United Kingdom
    Posts
    3,036
    Plugin Contributions
    2

    Default Re: Empty database?

    FTP to your website, then go to the 'includes' folder, highlight the configure.php file and click View. The contents of the file should appear in a text programme for you to view. You can see the database name near the bottom of the file.

    Vger

  6. #6
    Join Date
    Sep 2006
    Location
    Suffolk, UK
    Posts
    73
    Plugin Contributions
    0

    Default Re: Empty database?

    This is what I've got (sorry, but no idea what it means)

    // define our database connection
    define('DB_TYPE', 'mysql');
    define('DB_PREFIX', '');
    define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty
    define('DB_SERVER_USERNAME', '****');
    define('DB_SERVER_PASSWORD', '****');
    define('DB_DATABASE', 'waveneyb_shop');
    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', 'none');
    define('DIR_FS_SQL_CACHE', '/home/waveneyb/public_html/shop/cache');

    ?>
    Last edited by Ajeh; 4 Nov 2006 at 04:27 PM. Reason: edited for security

  7. #7
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Empty database?

    Next peek at the file:
    /admin/includes/configure.php

    Are they both set to the same database?

    Are you looking that the correct database in phpMyAdmin?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  8. #8
    Join Date
    Sep 2006
    Location
    Suffolk, UK
    Posts
    73
    Plugin Contributions
    0

    Default Re: Empty database?

    Ajeh

    Thanks for taking out my personal details (smacks self hard & blushes)

    This is in admin/configure

    // define our database connection
    define('DB_TYPE', 'mysql');
    define('DB_PREFIX', '');
    define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty
    define('DB_SERVER_USERNAME', '****');
    define('DB_SERVER_PASSWORD', '****');
    define('DB_DATABASE', 'waveneyb_shop');
    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', 'none');
    define('DIR_FS_SQL_CACHE', '/home/waveneyb/public_html/shop/cache');

    ?>

  9. #9
    Join Date
    Sep 2006
    Location
    Suffolk, UK
    Posts
    73
    Plugin Contributions
    0

    Default Re: Empty database?

    This is what I see in phpmyadmin



    Tina

  10. #10
    Join Date
    Jun 2003
    Posts
    33,715
    Plugin Contributions
    0

    Default Re: Empty database?

    Perhaps you need to ask your host where the database *really* is?
    Please do not PM for support issues: a private solution doesn't benefit the community.

    Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

 

 
Page 1 of 3 123 LastLast

Similar Threads

  1. v139h Customer Database Empty - Cant Send Newsletters
    By vintagenyc in forum General Questions
    Replies: 1
    Last Post: 17 Sep 2012, 01:58 AM
  2. v1371 MySQL says my database is empty?
    By awhfy99 in forum Upgrading from 1.3.x to 1.3.9
    Replies: 0
    Last Post: 23 Mar 2012, 12:31 AM
  3. Category page empty after import products database
    By clonlala in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 18 Jan 2010, 12:20 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