Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How many tables should be in the DB?


rhythin

Recommended Posts

Posted

Brand new installation with the latest version, first encounted the default language problem, after hacking that, admin panel complains table "orders_status" not found. and the catalog panel complains table "banner" not found. Checked DB, I have 26 tables in the DB, but no table with such names.

 

Could you anybody check your DB to verify this? Thx.

Posted

46

 

address_book

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_zones

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Posted

Thanks!

 

I checked the sql file under install, and it does include 46 tables, but I tried reinstalling several times, still only 26 tables created. Thus I use phpMyAdmin to run the sql instead, this time 46 tables were created. After that, the system installed without any problem, the default language problem is gone too.

 

46

 

address_book

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_zones

Archived

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

×
×
  • Create New...