error message says database 'address book' doesn't exist

[Ken Joy]

this is the error I get, although when I do a complete check on the database, everything says it's ok. But now here's the error:

1146 Table 'hojpub.address_book' doesn't exist

What am I missing?

Thanks for your help.

[kobra]

Do all of the tables have the prefix "hojpub." ??

[Ken Joy]

I don't think so. When installing zencart i left the field blank where it asked for a prefix. how would I check that and fix it?

Thanks for helping a newbie :)

[kobra]

If you have phpmyadmin or equivalent, you can view the tables and table names for this DB. They should all either have a prefix or all not have one.

Then based upon wht you find you can rename the least # of them so that they match.

It appears that your configure.php file is set to look for a prefix owing to the error stating:

1146 Table 'hojpub.address_book' doesn't exist

This can be edited to what ever you found and corrected to in the DB in the configure.php files(includes and admin/includes):

// define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', 'zen_');

[Ken Joy]

Thanks so much, I'll give it a try!

[Ken Joy]

Well, I've done something to mess it up. Here's what I get when importing the database into the new one on the new server....

SQL query:

CREATE TABLE `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 ,
`entry_country_id` int( 11 ) NOT NULL default '0',
`entry_zone_id` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `address_book_id` ) ,
KEY `idx_address_book_customers_id_zen` ( `customers_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 17

****************************************
additionally, when using this database with zencart 3.1.7, I get this message when trying to create a customer account:


1146 Table 'hojpub.address_book' doesn't exist
in:
[INSERT INTO address_book (customers_id, entry_firstname, entry_lastname, entry_street_address, entry_postcode, entry_city, entry_country_id, entry_gender, entry_company, entry_suburb, entry_zone_id, entry_state) VALUES ('1', 'adfad', 'adsfadf', '13321 adfadf', '91306', 'aadsfad', '223', 'm', '', '', '12', '')]

I'm sure I've overlooked something very simply, although I followed all the directions for moving from one sever to another.