Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1146 table Error


mblessed

Recommended Posts

I have posted this in the installation and configuration forum but I did not receive any responses so I thought I would try in this forum to see if I can get some help.

 

I am getting this error message when I go into the orders. When I try to open the invoice or packing slip. Can someone help me correct this?

 

 

1146 - Table 'simpl11_osc4.stores' doesn't exist

 

select o.customers_name, o.customers_company, o.customers_street_address, o.customers_suburb, o.customers_city, o.customers_postcode, o.customers_state, o.customers_country, o.customers_telephone, o.customers_email_address, o.customers_address_format_id, o.delivery_name, o.delivery_company, o.delivery_street_address, o.delivery_suburb, o.delivery_city, o.delivery_postcode, o.delivery_state, o.delivery_country, o.delivery_address_format_id, o.billing_name, o.billing_company, o.billing_street_address, o.billing_suburb, o.billing_city, o.billing_postcode, o.billing_state, o.billing_country, o.billing_address_format_id, o.payment_method, o.cc_type, o.cc_owner, o.cc_number, o.cc_expires, o.currency, o.currency_value, o.date_purchased, o.orders_status, o.last_modified, s.stores_name from orders o left join stores s on o.orders_stores_id = s.stores_id where o.orders_id = '4'

 

[TEP STOP]

Link to comment
Share on other sites

In the default osc version there is no table stores in the database. My guess is that you installed a contribution without modifying the database. Reread the install instructions from the contribution (if applies) and install the missing database information.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...