Guest Posted July 8, 2009 Share Posted July 8, 2009 Here are the details on the error! osCommerce 2.2-MS2 1146 - Table 'db291141933.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 Here are the tables in SQL db291141933 (46) address_format administrators 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_zones Thanks for the help in advance! Link to comment Share on other sites More sharing options...
Pektsekye Posted July 8, 2009 Share Posted July 8, 2009 Here are the details on the error! osCommerce 2.2-MS2 1146 - Table 'db291141933.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 Here are the tables in SQL db291141933 (46) address_format administrators 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_zones Thanks for the help in advance! Hello, try to create it CREATE TABLE address_book ( address_book_id int NOT NULL auto_increment, customers_id int NOT NULL, entry_gender char(1) NOT NULL, entry_company varchar(32), entry_firstname varchar(32) NOT NULL, entry_lastname varchar(32) NOT NULL, entry_street_address varchar(64) NOT NULL, entry_suburb varchar(32), entry_postcode varchar(10) NOT NULL, entry_city varchar(32) NOT NULL, entry_state varchar(32), entry_country_id int DEFAULT '0' NOT NULL, entry_zone_id int DEFAULT '0' NOT NULL, PRIMARY KEY (address_book_id), KEY idx_address_book_customers_id (customers_id) ); Stanislav Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.