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.

[kobra]

Table 'hojpub.address_book' - still seeing some prefix
'hojpub.address_book'

Your SQL is creating: CREATE TABLE `address_book` with no prefix

What did the others look like?

Looks like your sql query is a bit skinny if you posted all of it.

when making this in phpmyadmin - additionally check the Add DROP TABLE,
Add IF NOT EXISTS boxes and the Complete inserts and Extended inserts - boxes - do not uncheck anything and the export type should be the default "Insert"

[Ken Joy]

Thanks for all of your help. I think I'm making progress, the old error message is gone, but here's a new one:

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

From what I've read in posts here, deleting DEFAULT CHARSET=latin1 makes this go away. Question is, do I delete ALL of the refrences to DEFAULT CHARSET=latin1? Or just the first one that's near line 17?

I also read I should be replacing ENGINE=MyISAM with TYPE=MyISAM.

Thank again, so much, for helping this newbie :) We're dangerous, aren't we? LOL

[Ken Joy]

Hi... back again. Since my last post to you, I started over with the database:

1. I reinstalled zencart into the database
2. I selected the entire table, and then chose DROP table
3. I imported my database file with the 'default char' info removed and changed ENGINE= to TYPE=

with that done, my new error message is:

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 'Database hojpub running on localhost

DROP TABLE IF EXISTS

am I getting any closer, or just making it worse?