database problem

[biggy]

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

[biggy]

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

[DrByte]

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.

[biggy]

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

[DrByte]

same issue.

You have 2 configure.php files:

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

[biggy]

ahhhh
there we go, back on

thanks for all the help Dr Byte

Rgds
BiGGy