Ich habe den Shop v1.5.5.f auf einen anderen Server umgezogen.
Daten mit rsync rübergeschoben mit aktueller Datenbank.
Identische PHP (7.1.26) Version und sämtliche PHP Limits reichlich (wie auf dem alten Server) angehoben.
Von mysql 5.5 auf 5.7
Datenbankabfragen schlagen fehl
Wie empfohlen der aktuelle error log:
Daten mit rsync rübergeschoben mit aktueller Datenbank.
Identische PHP (7.1.26) Version und sämtliche PHP Limits reichlich (wie auf dem alten Server) angehoben.
Von mysql 5.5 auf 5.7
Datenbankabfragen schlagen fehl
Wie empfohlen der aktuelle error log:
[14-Feb-2019 17:27:47 UTC] Request URI: /ersatzeile-fur-vespa-pk-und-v50/lenkkopf-hebel-tacho/lenkerhebel-spitz-vespa-v50-pv, IP address: 66.249.76.86#1 trigger_error() called at [/var/www/vhosts/roller-aus-blech.de/httpdocs/includes/classes/db/mysql/query_factory.php:170]
#2 queryFactory->show_error() called at [/var/www/vhosts/roller-aus-blech.de/httpdocs/includes/classes/db/mysql/query_factory.php:142]
#3 queryFactory->set_error() called at [/var/www/vhosts/roller-aus-blech.de/httpdocs/includes/classes/db/mysql/query_factory.php:269]
#4 queryFactory->Execute() called at [/var/www/vhosts/roller-aus-blech.de/httpdocs/includes/modules/responsive_classic/xsell_products.php:34]
#5 include(/var/www/vhosts/roller-aus-blech.de/httpdocs/includes/modules/responsive_classic/xsell_products.php) called at [/var/www/vhosts/roller-aus-blech.de/httpdocs/in$
#6 require(/var/www/vhosts/roller-aus-blech.de/httpdocs/includes/templates/responsive_classic/templates/tpl_modules_xsell_products.php) called at [/var/www/vhosts/roller-$
#7 require(/var/www/vhosts/roller-aus-blech.de/httpdocs/includes/templates/responsive_classic/templates/tpl_product_info_display.php) called at [/var/www/vhosts/roller-au$
#8 require(/var/www/vhosts/roller-aus-blech.de/httpdocs/includes/modules/pages/product_info/main_template_vars.php) called at [/var/www/vhosts/roller-aus-blech.de/httpdoc$
#9 require(/var/www/vhosts/roller-aus-blech.de/httpdocs/includes/templates/responsive_classic/common/tpl_main_page.php) called at [/var/www/vhosts/roller-aus-blech.de/htt$
[14-Feb-2019 17:27:47 UTC] PHP Fatal error: 3065:Expression #1 of ORDER BY clause is not in SELECT list, references column 'roller.xp.sort_order' which is not in SELECT l$
from products_xsell xp, products p, products_description pd
where xp.products_id = '938'
and xp.xsell_id = p.products_id
and p.products_id = pd.products_id
and pd.language_id = '43'
$des/modules/responsive_classic/xsell_products.php on line 34 <== in /var/www/vhosts/roller-aus-blech.de/httpdocs/includes/classes/db/mysql/query_factory.php on line 170
#2 queryFactory->show_error() called at [/var/www/vhosts/roller-aus-blech.de/httpdocs/includes/classes/db/mysql/query_factory.php:142]
#3 queryFactory->set_error() called at [/var/www/vhosts/roller-aus-blech.de/httpdocs/includes/classes/db/mysql/query_factory.php:269]
#4 queryFactory->Execute() called at [/var/www/vhosts/roller-aus-blech.de/httpdocs/includes/modules/responsive_classic/xsell_products.php:34]
#5 include(/var/www/vhosts/roller-aus-blech.de/httpdocs/includes/modules/responsive_classic/xsell_products.php) called at [/var/www/vhosts/roller-aus-blech.de/httpdocs/in$
#6 require(/var/www/vhosts/roller-aus-blech.de/httpdocs/includes/templates/responsive_classic/templates/tpl_modules_xsell_products.php) called at [/var/www/vhosts/roller-$
#7 require(/var/www/vhosts/roller-aus-blech.de/httpdocs/includes/templates/responsive_classic/templates/tpl_product_info_display.php) called at [/var/www/vhosts/roller-au$
#8 require(/var/www/vhosts/roller-aus-blech.de/httpdocs/includes/modules/pages/product_info/main_template_vars.php) called at [/var/www/vhosts/roller-aus-blech.de/httpdoc$
#9 require(/var/www/vhosts/roller-aus-blech.de/httpdocs/includes/templates/responsive_classic/common/tpl_main_page.php) called at [/var/www/vhosts/roller-aus-blech.de/htt$
[14-Feb-2019 17:27:47 UTC] PHP Fatal error: 3065:Expression #1 of ORDER BY clause is not in SELECT list, references column 'roller.xp.sort_order' which is not in SELECT l$
from products_xsell xp, products p, products_description pd
where xp.products_id = '938'
and xp.xsell_id = p.products_id
and p.products_id = pd.products_id
and pd.language_id = '43'
$des/modules/responsive_classic/xsell_products.php on line 34 <== in /var/www/vhosts/roller-aus-blech.de/httpdocs/includes/classes/db/mysql/query_factory.php on line 170
Kommentar