Antwort #3 am: 22. Juni 2011, 08:26:00
Hallo buerospezial,
wie kann es brennen wenn Du es "testweise" eingebaut hast?
Versuche mal in der admin/includes/modules/export/billiger.php in Z.76 - 110 das:
$export_query = xtc_db_query("SELECT
p.products_id,
p.products_model,
p.products_ean,
p.products_image,
p.products_price,
p.products_status,
p.products_date_available,
p.products_shippingtime,
p.products_discount_allowed,
p.products_tax_class_id,
p.products_date_added,
p.products_weight,
pd.products_name,
pd.products_description,
pd.products_short_description,
pd.products_meta_keywords,
m.manufacturers_name,
lng.code
FROM
" . TABLE_PRODUCTS . " p LEFT JOIN
" . TABLE_MANUFACTURERS . " m
ON p.manufacturers_id = m.manufacturers_id LEFT JOIN
" . TABLE_PRODUCTS_DESCRIPTION . " pd
ON p.products_id = pd.products_id LEFT JOIN
" . TABLE_SPECIALS . " s
ON p.products_id = s.products_id LEFT JOIN
" . TABLE_LANGUAGES . " as lng
ON lng.languages_id = '" . (int) $_POST['languages_id'] . "'
WHERE
p.products_status = 1 AND
lng.languages_id = pd.language_id
ORDER BY
p.products_date_added DESC,
pd.products_name");
auszutauschen gegen das:
$export_query =xtc_db_query("SELECT
p.products_id,
pd.products_name,
pd.products_description,pd.products_short_description,
p.products_model,p.products_ean,
p.products_image,
p.products_price,
p.products_status,
p.products_date_available,
p.products_shippingtime,
p.products_discount_allowed,
pd.products_meta_keywords,
p.products_tax_class_id,
p.products_date_added,
p.products_weight,
m.manufacturers_name
FROM
" . TABLE_PRODUCTS . " p LEFT JOIN
" . TABLE_MANUFACTURERS . " m
ON p.manufacturers_id = m.manufacturers_id LEFT JOIN
" . TABLE_PRODUCTS_DESCRIPTION . " pd
ON p.products_id = pd.products_id AND
pd.language_id = '".$_SESSION['languages_id']."' LEFT JOIN
" . TABLE_SPECIALS . " s
ON p.products_id = s.products_id
WHERE
p.products_status = 1
ORDER BY
p.products_date_added DESC,
pd.products_name");
aus der idealo.php... denn ich denke, dass dann höchstens der Query fehlerhaft sein könnte.
Viele Grüße
Franky