(Zen-Cart 1.5.6) Fehlermeldung bei Sonderangebot

[hanseattica]

Hallo, ich habe mein Shop von 1.5.5f auf 1.5.6e upgedatet und winchester_teplate-1.7.1 neu installiert. Alles ist gut. Nur wenn man den Button von Sonderangebote anklickt, bekommt man eine Fehlermeldung wie folgend.

Sonderangebote

FEHLER:
Datenbankabfragen oder Datenbankeinträge schlagen fehl.

Unter Admin-> Webshop-> Sonderangebote sind drei Angebote vorhanden.

in Logfile sieht die Fehlerbeschreibung so aus:

[LEFT][FONT=Verdana]#1  trigger_error() called at [/homepages/**/dxxxxxxx/htdocs/meinshop.de/shop/includes/classes/db/mysql/query_factory.php:171][/FONT]
[FONT=Verdana]#2  queryFactory->show_error() called at [/homepages/[COLOR=#333333][FONT=Verdana]**[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]/dxxxxxxx[/FONT][/COLOR]/htdocs/[COLOR=#001000]m[FONT=Verdana]einshop[/FONT][/COLOR].de/shop/includes/classes/db/mysql/query_factory.php:143][/FONT]
[FONT=Verdana]#3  queryFactory->set_error() called at [/homepages/[COLOR=#333333][FONT=Verdana]**[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]/dxxxxxxx[/FONT][/COLOR]/htdocs/[COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR].de/shop/includes/classes/db/mysql/query_factory.php:270][/FONT]
[FONT=Verdana]#4  queryFactory->Execute() called at [/homepages/[COLOR=#333333][FONT=Verdana]**[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]/dxxxxxxx[/FONT][/COLOR]/htdocs/[COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR].de/shop/includes/classes/split_page_results.php:86][/FONT]
[FONT=Verdana]#5  splitPageResults->__construct() called at [/FONT][FONT=Verdana][/homepages/[COLOR=#333333][FONT=Verdana]**[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]/dxxxxxxx[/FONT][/COLOR]/htdocs/[COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR].de/shop/includes/modules/winchester_responsive/product_listing.php:30][/FONT]
[FONT=Verdana]#6  include(/homepages/[COLOR=#333333][FONT=Verdana]**[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]/dxxxxxxx[/FONT][/COLOR]/htdocs/[COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR].de/shop/includes/modules/winchester_responsive/product_listing.php) called at [/homepages/[COLOR=#333333][FONT=Verdana]**[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]/dxxxxxxx[/FONT][/COLOR]/htdocs/[COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR].de/shop/includes/templates/winchester_responsive/templates/tpl_modules_product_listing.php:11][/FONT]
[FONT=Verdana]#7 require(/homepages/[COLOR=#333333][FONT=Verdana]**[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]/dxxxxxxx[/FONT][/COLOR]/htdocs/[COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR].de/shop/includes/templates/winchester_responsive/templates/tpl_modules_product_listing.php) called at [COLOR=#3e3e3e][FONT=Verdana][[/FONT][/COLOR]/homepages/[COLOR=#333333][FONT=Verdana]**[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]/dxxxxxxx[/FONT][/COLOR]/htdocs/[COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR].de/shop/includes/templates/winchester_responsive/templates/tpl_specials_default.php:15][/FONT]
[FONT=Verdana]#8  require(/homepages/[COLOR=#333333][FONT=Verdana]**[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]/dxxxxxxx[/FONT][/COLOR]/htdocs/[COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR].de/shop/includes/templates/winchester_responsive/templates/tpl_specials_default.php) called at [/homepages/[COLOR=#333333][FONT=Verdana]**[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]/dxxxxxxx[/FONT][/COLOR]/htdocs/[COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR].de/shop/includes/modules/pages/specials/main_template_vars.php:91][/FONT]
[FONT=Verdana]#9  require(/homepages/[COLOR=#333333][FONT=Verdana]**[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]/dxxxxxxx[/FONT][/COLOR]/htdocs/[COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR].de/shop/includes/modules/pages/specials/main_template_vars.php) called at [/homepages/[COLOR=#333333][FONT=Verdana]**[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]/dxxxxxxx[/FONT][/COLOR]/htdocs/[COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR].de/shop/includes/templates/winchester_responsive/common/tpl_main_page.php:259][/FONT]
[FONT=Verdana]#10 require(/homepages/[COLOR=#333333][FONT=Verdana]**[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]/dxxxxxxx[/FONT][/COLOR]/htdocs/[COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR].de/shop/includes/templates/winchester_responsive/common/tpl_main_page.php) called at [/homepages/[COLOR=#333333][FONT=Verdana]**[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]/dxxxxxxx[/FONT][/COLOR]/htdocs/[COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR].de/shop/index.php:97][/FONT][/LEFT]

Kann mir jemand bitte helfen?

Beste Grüße

Hanseattica

[webchills]

Der obere Teil des Logfiles ist relativ uninteressant, er zeigt, welche Dateien in welcher Reihenfolge am Aufruf beteiligt sind.
Es fehlen die wirklich relevanten letzten Zeilen, die anzeigen, was genau zum Fehler führt.
Bitte poste das komplette Logfile oder die fehlenden Zeilen.
Ohne das kann niemand etwas dazu sagen.

[hanseattica]

Hallo Webchills,

vielen Dank für die schnelle Reaktion!
Das klomplette Logfile ist so:

XxxxxxxxxEurope/Berlin] Request URI: /shop/specials.html, IP address: xxxxxx

[COLOR=#3e3e3e][FONT=Verdana]#1 trigger_error() called at [/homepages/**/dxxxxxxx/htdocs/meinshop.de/shop/includes/classes/db/mysql/query_factory.php:171][/FONT][/COLOR][COLOR=#3e3e3e][FONT=&quot]
[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]#2 queryFactory->show_error() calledat [/homepages/[/FONT][/COLOR][COLOR=#333333][FONT=&amp]**/dxxxxxxx[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]/htdocs/[/FONT][/COLOR][COLOR=#001000][FONT=Verdana]meinshop[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana].de/shop/includes/classes/db/mysql/query_factory.php:143][/FONT][/COLOR][COLOR=#3e3e3e][FONT=&quot]
[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]#3 queryFactory->set_error() calledat [/homepages/[/FONT][/COLOR][COLOR=#333333][FONT=&amp]**/dxxxxxxx[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]/htdocs/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana].de/shop/includes/classes/db/mysql/query_factory.php:270][/FONT][/COLOR][COLOR=#3e3e3e][FONT=&quot]
[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]#4 queryFactory->Execute() called at[/homepages/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]**/dxxxxxxx[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]/htdocs/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana].de/shop/includes/classes/split_page_results.php:86][/FONT][/COLOR][COLOR=#3e3e3e][FONT=&quot]
[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]#5 splitPageResults->__construct()called at [/homepages/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]**/dxxxxxxx[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]/htdocs/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana].de/shop/includes/modules/winchester_responsive/product_listing.php:30][/FONT][/COLOR][COLOR=#3e3e3e][FONT=&quot]
[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]#6 include(/homepages/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]**/dxxxxxxx[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]/htdocs/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana].de/shop/includes/modules/winchester_responsive/product_listing.php)called at [/homepages/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]**/dxxxxxxx[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]/htdocs/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana].de/shop/includes/templates/winchester_responsive/templates/tpl_modules_product_listing.php:11][/FONT][/COLOR][COLOR=#3e3e3e][FONT=&quot]
[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]#7 require(/homepages/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]**/dxxxxxxx[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]/htdocs/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana].de/shop/includes/templates/winchester_responsive/templates/tpl_modules_product_listing.php)called at [/homepages/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]**/dxxxxxxx[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]/htdocs/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana].de/shop/includes/templates/winchester_responsive/templates/tpl_specials_default.php:15][/FONT][/COLOR][COLOR=#3e3e3e][FONT=&quot]
[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]#8 require(/homepages/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]**/dxxxxxxx[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]/htdocs/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana].de/shop/includes/templates/winchester_responsive/templates/tpl_specials_default.php)called at [/homepages/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]**/dxxxxxxx[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]/htdocs/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana].de/shop/includes/modules/pages/specials/main_template_vars.php:91][/FONT][/COLOR][COLOR=#3e3e3e][FONT=&quot]
[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]#9 require(/homepages/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]**/dxxxxxxx[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]/htdocs/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana].de/shop/includes/modules/pages/specials/main_template_vars.php)called at [/homepages/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]**/dxxxxxxx[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]/htdocs/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana].de/shop/includes/templates/winchester_responsive/common/tpl_main_page.php:259][/FONT][/COLOR][COLOR=#3e3e3e][FONT=&quot]
[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]#10 require(/homepages/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]**/dxxxxxxx[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]/htdocs/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana].de/shop/includes/templates/winchester_responsive/common/tpl_main_page.php)called at [/homepages/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]**/dxxxxxxx[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana]/htdocs/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]meinshop[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Verdana].de/shop/index.php:97]

[COLOR=#3e3e3e][FONT=Arial]--> PHP Fatal error:1109: Unknown table 'p' in field list :: select count(p.products_id) as total==> (as called by) /homepages/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]**/dxxxxxxx[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Arial]/htdocs/meishop.de/shop/includes/classes/split_page_results.phpon line 86 <== in /homepages/[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]**/dxxxxxxx[/FONT][/COLOR][COLOR=#3e3e3e][FONT=Arial]/htdocs/meinshop.de/shop/includes/classes/db/mysql/query_factory.phpon line 171.[/FONT][/COLOR]
[/FONT][/COLOR]

[webchills]

Überprüfe folgende Datei:
includes/modules/pages/specials/header_php.php

Vergleiche sie mit der Originaldatei aus dem Winchester Template Download.

Hier hast Du vermutlich bei der Integration anderer Module die entsprechende bereits vom Winchester Template geänderte Datei ersetzt statt die Änderungen manuell vorzunehmen.

[hanseattica]

Hallo webchills,

vielen Dank für diene super Hilfe! Jetzt funktioniert alles!
Mein Fehler war, dass ich das sogenannte "Override System" genutzt und

alle geänderte Dateien aus dem Wichester Template

unter includes/modules/pages/wichester_respontive/ kopiert habe.

Nochmals einen herzlichen Dank!

Beste Grüße