Results 1 to 6 of 6
  1. #1

    Default database problem

    Hi everyone,

    i upgraded my site to 1.3.7 from 1.3.5 i think using a fresh install

    when i looked at it after it was not showing any products etc, even though the database was showing on my server.

    i deleted the database and tried to restore it but get this error

    -- Table structure for table `zen_address_book`
    --
    CREATE TABLE `zen_address_book` (

    `address_book_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
    `customers_id` int( 11 ) NOT NULL default '0',
    `entry_gender` char( 1 ) NOT NULL default '',
    `entry_company` varchar( 32 ) default NULL ,
    `entry_firstname` varchar( 32 ) NOT NULL default '',
    `entry_lastname` varchar( 32 ) NOT NULL default '',
    `entry_street_address` varchar( 64 ) NOT NULL default '',
    `entry_suburb` varchar( 32 ) default NULL ,
    `entry_postcode` varchar( 10 ) NOT NULL default '',
    `entry_city` varchar( 32 ) NOT NULL default '',
    `entry_state` varchar( 32 ) default NULL

    at the bottom then showing
    MySQL said:

    #1046 - No Database Selected

    gratefull for any help

    Rgds
    Biggy

  2. #2

    Default Re: database problem

    got it to import now i had to create the database name to import it to DOH!

    but now cant access site at all get the following error

    1146 Table 'biggy_zc1.project_version' doesn't exist
    in:
    [select * from project_version WHERE project_version_key = 'Zen-Cart Database' ]
    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.

    think ive killed it

    the hole im digging is getting bigger hehe

  3. #3
    Join Date
    Jan 2004
    Posts
    65,410
    Blog Entries
    7
    Plugin Contributions
    232

    Default Re: database problem

    make sure your DB_PREFIX setting in your configure.php files matches the DB_PREFIX setting from the site your backup was created on.


    ie: if all your tables being imported start with 'zen_', then your DB_PREFIX needs to be set to 'zen_' in order for your tables to be identified by Zen Cart.
    .

    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.

  4. #4

    Default Re: database problem

    thank you that sorted the main issue all my products now show, next issue is i get this error when i try and access the admin menu

    1146 Table 'biggy_zc1.project_version' doesn't exist
    in:
    [select * from project_version WHERE project_version_key = 'Zen-Cart Database' ]
    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.

    thanks again for the help

  5. #5
    Join Date
    Jan 2004
    Posts
    65,410
    Blog Entries
    7
    Plugin Contributions
    232

    Default Re: database problem

    same issue.

    You have 2 configure.php files:

    /includes/configure.php
    /admin/includes/configure.php
    .

    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.

  6. #6

    Default Re: database problem

    ahhhh
    there we go, back on

    thanks for all the help Dr Byte

    Rgds
    BiGGy

 

 

Similar Threads

  1. v139h Problem Importing SQL database to new database ready for testing Zencart 1.5
    By gillpotsoffun in forum Upgrading to 1.5.x
    Replies: 8
    Last Post: 24 Aug 2015, 11:24 PM
  2. Database problem
    By Maynards in forum General Questions
    Replies: 4
    Last Post: 21 Feb 2011, 05:06 PM
  3. database problem?
    By clr in forum Upgrading from 1.3.x to 1.3.9
    Replies: 3
    Last Post: 10 Jul 2008, 11:49 PM
  4. Database Problem?
    By styleboy in forum General Questions
    Replies: 9
    Last Post: 27 Feb 2007, 11:55 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