Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1146 - Table Problem


i2tech

Recommended Posts

Hello,

 

I just installed and received this problem under the admin - customers section:

 

1146 - Table 'databasename.address_book' doesn't exist

select count(*) as total from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id

 

I have looked in phpMyAdmin and found that there is no address_book table. These are the tables that have been created:

 

address_format

banners

banners_history

categories

categories_description

configuration

configuration_group

counter

counter_history

countries

currencies

customers

customers_basket

customers_basket_attributes

customers_info

geo_zones

languages

manufacturers

manufacturers_info

newsletters

orders

orders_products

orders_products_attributes

orders_products_download

orders_status

orders_status_history

orders_total

products

products_attributes

products_attributes_download

products_description

products_notifications

products_options

products_options_values

products_options_values_to_products_options

products_to_categories

reviews

reviews_description

sessions

specials

tax_class

tax_rates

whos_online

zones

zones_to_geo_zon

 

Any help would greatly be apperciated. Thanks!

Link to comment
Share on other sites

Default table RC2.2a

 

-- phpMyAdmin SQL Dump

-- version 2.8.2.4

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Feb 17, 2008 at 12:04 PM

-- Server version: 5.0.24

-- PHP Version: 5.1.6

--

-- Database: `rs_osc`

--

 

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

 

--

-- Table structure for table `address_book`

--

 

CREATE TABLE `address_book` (

`address_book_id` int(11) NOT NULL auto_increment,

`customers_id` int(11) NOT NULL,

`entry_gender` char(1) NOT NULL,

`entry_company` varchar(32) default NULL,

`entry_firstname` varchar(32) NOT NULL,

`entry_lastname` varchar(32) NOT NULL,

`entry_street_address` varchar(64) NOT NULL,

`entry_suburb` varchar(32) default NULL,

`entry_postcode` varchar(10) NOT NULL,

`entry_city` varchar(32) NOT NULL,

`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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

 

--

-- Dumping data for table `address_book`

--

 

INSERT INTO `address_book` (`address_book_id`, `customers_id`, `entry_gender`, `entry_company`, `entry_firstname`, `entry_lastname`, `entry_street_address`, `entry_suburb`, `entry_postcode`, `entry_city`, `entry_state`, `entry_country_id`, `entry_zone_id`) VALUES (1, 1, 'm', 'ACME Inc.', 'John', 'Doe', '1 Way Street', '', '12345', 'NeverNever', '', 223, 12);

Link to comment
Share on other sites

  • 1 month later...

Thanks! This fixed my problem!

 

 

Default table RC2.2a

 

-- phpMyAdmin SQL Dump

-- version 2.8.2.4

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Feb 17, 2008 at 12:04 PM

-- Server version: 5.0.24

-- PHP Version: 5.1.6

--

-- Database: `rs_osc`

--

 

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

 

--

-- Table structure for table `address_book`

--

 

CREATE TABLE `address_book` (

`address_book_id` int(11) NOT NULL auto_increment,

`customers_id` int(11) NOT NULL,

`entry_gender` char(1) NOT NULL,

`entry_company` varchar(32) default NULL,

`entry_firstname` varchar(32) NOT NULL,

`entry_lastname` varchar(32) NOT NULL,

`entry_street_address` varchar(64) NOT NULL,

`entry_suburb` varchar(32) default NULL,

`entry_postcode` varchar(10) NOT NULL,

`entry_city` varchar(32) NOT NULL,

`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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

 

--

-- Dumping data for table `address_book`

--

 

INSERT INTO `address_book` (`address_book_id`, `customers_id`, `entry_gender`, `entry_company`, `entry_firstname`, `entry_lastname`, `entry_street_address`, `entry_suburb`, `entry_postcode`, `entry_city`, `entry_state`, `entry_country_id`, `entry_zone_id`) VALUES (1, 1, 'm', 'ACME Inc.', 'John', 'Doe', '1 Way Street', '', '12345', 'NeverNever', '', 223, 12);

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...