1146 address_book doesn't exist

[wingdzell]

So I'm setting up a store for a client. It's temporarily hosted on my site while I test, etc. so she's able to view the changes. I was coming through stuff earlier when I got this error when I tried to create a test costumer account.

 

http://zelljeff.com/client/celeb_everything/store/

 

Do I need to reinstall?

 

Any help is appreciated. Thanks. :)

[Guest]

So I'm setting up a store for a client. It's temporarily hosted on my site while I test, etc. so she's able to view the changes. I was coming through stuff earlier when I got this error when I tried to create a test costumer account.

 

http://zelljeff.com/client/celeb_everything/store/

 

Do I need to reinstall?

 

Any help is appreciated. Thanks. :)

 

I would say so Yes. Simply becuase you do not know what other tables may be missing. I guess you could fix them as you get your errors tho.

 

Run this and it will fix your current error anyway :

DROP TABLE IF EXISTS `address_book`;
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` (`customers_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2;

-- --------------------------------------------------------

-- 
-- Table structure for table `address_format`
-- 

DROP TABLE IF EXISTS `address_format`;
CREATE TABLE `address_format` (
 `address_format_id` int(11) NOT NULL auto_increment,
 `address_format` varchar(128) NOT NULL default '',
 `address_summary` varchar(48) NOT NULL default '',
 PRIMARY KEY  (`address_format_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6;

 

Corrina