Antwort #4 am: 24. Januar 2011, 11:27:54
Alles klar, danke für die Rückmeldung, dann müssen wir hier nochmal schauen.
Nachtrag: Siche in der "/includes/modules/upcoming_products.php"
$expected_query = xtDBquery("select p.products_id,
pd.products_name,
p.products_date_available as date_expected
from ".TABLE_PRODUCTS." p
join ".TABLE_PRODUCTS_DESCRIPTION." pd on pd.products_id = p.products_id
where to_days(p.products_date_available)>= to_days(now())
".$group_check."
".$fsk_lock."
and pd.language_id = '".(int) $_SESSION['languages_id']."'
order by ".EXPECTED_PRODUCTS_FIELD." ".EXPECTED_PRODUCTS_SORT."
limit ".MAX_DISPLAY_UPCOMING_PRODUCTS);
und ersetze mit:
$expected_query = xtDBquery("select p.products_id,
pd.products_name,
p.products_date_available as date_expected
from ".TABLE_PRODUCTS." p
join ".TABLE_PRODUCTS_DESCRIPTION." pd on pd.products_id = p.products_id
where to_days(p.products_date_available)>= to_days(now())
".$group_check."
".$fsk_lock."
and pd.language_id = '".(int) $_SESSION['languages_id']."'
and p.products_status = '1'
order by ".EXPECTED_PRODUCTS_FIELD." ".EXPECTED_PRODUCTS_SORT."
limit ".MAX_DISPLAY_UPCOMING_PRODUCTS);
Der Fehler wurde in
r1694 behoben.
Grüße
Torsten