Hey,
nach einem Update von 4.7.7 auf 4.8.3 habe ich folgendes Problem. Konfiguriert sind zwei Sprachen: de, en. Mit de funktioniert alles soweit. Bei en fliegt folgende Exception bei Wahl einer Kategorie:
oxConnectionException-oxException (time: 2014-03-12 12:05:56): [1054]: mysql:EXECUTE error: [1054: Unknown column 'oxv_oxarticles_de.OXTITLE' in 'order clause'] in EXECUTE with parameters SELECT `oxv_oxarticles_en`.`oxid`, oxv_oxarticles_en.oxtimestamp FROM oxobject2category as oc left join oxv_oxarticles_en ON oxv_oxarticles_en.oxid = oc.oxobjectid WHERE ( oxv_oxarticles_en.oxactive = 1 and ( oxv_oxarticles_en.oxstockflag != 2 or ( oxv_oxarticles_en.oxstock + oxv_oxarticles_en.oxvarstock ) > 0 ) and IF( oxv_oxarticles_en.oxvarcount = 0, 1, ( select 1 from oxv_oxarticles_en as art where art.oxparentid=oxv_oxarticles_en.oxid and ( art.oxactive = 1 ) and ( art.oxstockflag != 2 or art.oxstock > 0 ) limit 1 ) ) ) and oxv_oxarticles_en.oxparentid = '' and oc.oxcatnid = '8302c0744d8bebbbcd27b33d75598a5e' ORDER BY oxv_oxarticles_de.OXTITLE asc , oc.oxpos, oc.oxobjectid LIMIT 0, 12, for user root Stack Trace: #0 /home/cneumann/projekte/devshop/www/core/adodblite/adodbSQL_drivers/mysql/mysql_driver.inc(369): adodb_throw('mysql', 'EXECUTE', 1054, 'Unknown column ...', 'SELECT `oxv_oxa...', false, Object(object_ADOConnection)) #1 /home/cneumann/projekte/devshop/www/core/adodblite/adodb.inc.php(334): mysql_driver_ADOConnection->do_query('SELECT `oxv_oxa...', 0, 12, false) #2 /home/cneumann/projekte/devshop/www/core/oxlegacydb.php(190): ADOConnection->SelectLimit('SELECT `oxv_oxa...', 12, 0, false) #3 /home/cneumann/projekte/devshop/www/core/oxlist.php(390): oxLegacyDb->selectLimit('SELECT `oxv_oxa...', 12, 0) #4 /home/cneumann/projekte/devshop/www/application/models/oxarticlelist.php(85): oxList->selectString('SELECT `oxv_oxa...') #5 /home/cneumann/projekte/devshop/www/application/models/oxarticlelist.php(469): oxArticleList->selectString('SELECT `oxv_oxa...') #6 /home/cneumann/projekte/devshop/www/application/controllers/alist.php(365): oxArticleList->loadCategoryArticles('8302c0744d8bebb...', NULL) #7 /home/cneumann/projekte/devshop/www/application/controllers/alist.php(781): aList->_loadArticles(Object(oxCategory)) #8 /home/cneumann/projekte/devshop/www/application/controllers/alist.php(208): aList->getArticleList() #9 /home/cneumann/projekte/devshop/www/core/oxshopcontrol.php(466): aList->render() #10 /home/cneumann/projekte/devshop/www/core/oxshopcontrol.php(351): oxShopControl->_render(Object(aList)) #11 /home/cneumann/projekte/devshop/www/core/oxshopcontrol.php(124): oxShopControl->_process('alist', NULL, NULL, NULL) #12 /home/cneumann/projekte/devshop/www/core/oxid.php(40): oxShopControl->start() #13 /home/cneumann/projekte/devshop/www/index.php(28): Oxid::run() #14 /home/cneumann/projekte/devshop/www/oxseo.php(45): require('/home/cneumann/...') #15 {main} Connection Adress --> Connection Error -->
Der Shop versucht also nach dem deutschen Titel zu sortieren. Jemand eine Ahnung, warum er das macht?
Danke und Gruß,
Christian