22-05-2012 23:56:56

Fehler 256 1054 - Unknown column 'p.manufacturers_id' in 'on clause' select distinct p.products_id, p.products_fsk18, pd.products_name, pd.products_short_description, p.products_image, p.products_price, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from products p, categories c, products_to_categories p2c left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '2' where c.categories_status=1 and p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' and p.products_date_added > '2012.02.12' order by p.products_date_added DESC

Error-Backtrace

  xtc_db_error ("select distinct
                                    p.products_id,
                                    p.products_fsk18,
                                    pd.products_name,
                                    pd.products_short_description,
                                    p.products_image,
                                    p.products_price,
                               	    p.products_vpe,
                               	    p.products_vpe_status,
                                    p.products_vpe_value,
                                    p.products_tax_class_id,
                                    p.products_date_added,
                                    m.manufacturers_name
                                    from products p,
                                    categories c,
                                    products_to_categories p2c
                                    left join manufacturers m
                                    on p.manufacturers_id = m.manufacturers_...", "1054", "unknown column 'p.manufacturers_id' in 'on clause'")
  # Zeile/Line 36, Datei/File: .../inc/xtc_db_query.inc.php
  xtc_db_query ("select distinct
                                    p.products_id,
                                    p.products_fsk18,
                                    pd.products_name,
                                    pd.products_short_description,
                                    p.products_image,
                                    p.products_price,
                               	    p.products_vpe,
                               	    p.products_vpe_status,
                                    p.products_vpe_value,
                                    p.products_tax_class_id,
                                    p.products_date_added,
                                    m.manufacturers_name
                                    from products p,
                                    categories c,
                                    products_to_categories p2c
                                    left join manufacturers m
                                    on p.manufacturers_id = m.manufacturers_...")
  # Zeile/Line 104, Datei/File: .../includes/application_top.php
  xtDBquery ("select distinct
                                    p.products_id,
                                    p.products_fsk18,
                                    pd.products_name,
                                    pd.products_short_description,
                                    p.products_image,
                                    p.products_price,
                               	    p.products_vpe,
                               	    p.products_vpe_status,
                                    p.products_vpe_value,
                                    p.products_tax_class_id,
                                    p.products_date_added,
                                    m.manufacturers_name
                                    from products p,
                                    categories c,
                                    products_to_categories p2c
                                    left join manufacturers m
                                    on p.manufacturers_id = m.manufacturers_...")
  # Zeile/Line 33, Datei/File: .../includes/classes/split_page_results.php
  splitPageResults.splitPageResults ("select distinct
                                    p.products_id,
                                    p.products_fsk18,
                                    pd.products_name,
                                    pd.products_short_description,
                                    p.products_image,
                                    p.products_price,
                               	    p.products_vpe,
                               	    p.products_vpe_status,
                                    p.products_vpe_value,
                                    p.products_tax_class_id,
                                    p.products_date_added,
                                    m.manufacturers_name
                                    from products p,
                                    categories c,
                                    products_to_categories p2c
                                    left join manufacturers m
                                    on p.manufacturers_id = m.manufacturers_...", null, "10", "p.products_id")
  # Zeile/Line 64, Datei/File: .../products_new_rss.php