Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

-3H-

Archived
  • Posts

    3
  • Joined

  • Last visited

Posts posted by -3H-

  1. Hi!

     

    I got a problem with the contribution. If I assign an attribute set to a product, I get an error message in the shop (product_info.php):

     

    1146 - Table 'sql11890.TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS' doesn't exist
    
    SELECT pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix , pase.sort_order FROM products_attributes pa, TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS pas2pa, TABLE_PRODUCTS_ATTRIBUTES_SETS pas, TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS pase, products_options_values pov WHERE pa.products_id = '103' AND pa.options_id = '1' AND pas2pa.products_id = pa.products_id AND pas.products_attributes_sets_id = pas2pa.products_attributes_sets_id AND pas.products_options_id = pa.options_id AND pase.products_attributes_sets_id = pas.products_attributes_sets_id AND pase.options_values_id = pa.options_values_id AND pov.products_options_values_id = pa.options_values_id AND pov.language_id = '2' ORDER BY pase.sort_order, pa.options_values_id
    
    [TEP STOP]

     

    But I executed the sql-file. The table do exist. I don't know what to do. Please help me.

×
×
  • Create New...