Hallo,
nach dem Update habe ich mehrere Probleme_
- Nachdem ich beim Testen beim Checkout einen “Shop Offline” und auch merkwürdige (PHP/SQL) rote Fehlermeldungen bin ich auf die Suche gegangen und in der “EXCEPTION_LOG.txt” fündig gewurden. So, wie ich das sehe, wurde in der “updateApp” -spl-Datei vergessen, das DB-feld “oxshowcustomagreement” an zu legen.
Nachdem ich das per Hand (aus einer 4.8.6) kopiert hatte, funktionierte es.
Der 2. Fehler - bei der Thankyou- Seite fehlen irgendwie die Sprach-Variablen:
PAGE_CHECKOUT_THANKYOU_THANKYOU1 PAGE_CHECKOUT_THANKYOU_THANKYOU2 Shop.
PAGE_CHECKOUT_THANKYOU_REGISTEREDYOUORDERNO1 20144106 PAGE_CHECKOUT_THANKYOU_REGISTEREDYOUORDERNO2
PAGE_CHECKOUT_THANKYOU_YOURECEIVEDORDERCONFIRM PAGE_CHECKOUT_THANKYOU_WEWILLINFORMYOU
Ich habe mal geschaut. Vorhanden sind sie, allerdings nur in der lang.php oder map.php des mobile-Templates???
Ich habe sie vorerst in der cust_lang.php angelegt…
- Die “EXCEPTION_LOG.txt” bringt außerdem noch:
Connection Adress -->
Connection Error -->
---------------------------------------------
oxConnectionException-oxException (time: 2014-06-10 18:20:36): [1054]: mysql:EXECUTE error: [1054: Unknown column 'oxv_oxarticles_de.oxshowcustomagreement' in 'field list'] in EXECUTE with parameters select `oxv_oxarticles_de`.`oxid`, `oxv_oxarticles_de`.`oxshopid`, `oxv_oxarticles_de`.`oxparentid`, `oxv_oxarticles_de`.`oxactive`, `oxv_oxarticles_de`.`oxactivefrom`, `oxv_oxarticles_de`.`oxactiveto`, `oxv_oxarticles_de`.`oxartnum`, `oxv_oxarticles_de`.`oxean`, `oxv_oxarticles_de`.`oxdistean`, `oxv_oxarticles_de`.`oxmpn`, `oxv_oxarticles_de`.`oxtitle`, `oxv_oxarticles_de`.`oxshortdesc`, `oxv_oxarticles_de`.`oxprice`, `oxv_oxarticles_de`.`oxblfixedprice`, `oxv_oxarticles_de`.`oxpricea`, `oxv_oxarticles_de`.`oxpriceb`, `oxv_oxarticles_de`.`oxpricec`, `oxv_oxarticles_de`.`oxbprice`, `oxv_oxarticles_de`.`oxtprice`, `oxv_oxarticles_de`.`oxunitname`, `oxv_oxarticles_de`.`oxunitquantity`, `oxv_oxarticles_de`.`oxexturl`, `oxv_oxarticles_de`.`oxurldesc`, `oxv_oxarticles_de`.`oxurlimg`, `oxv_oxarticles_de`.`oxvat`, `oxv_oxarticles_de`.`oxthumb`, `oxv_oxarticles_de`.`oxicon`, `oxv_oxarticles_de`.`oxpic1`, `oxv_oxarticles_de`.`oxpic2`, `oxv_oxarticles_de`.`oxpic3`, `oxv_oxarticles_de`.`oxpic4`, `oxv_oxarticles_de`.`oxpic5`, `oxv_oxarticles_de`.`oxpic6`, `oxv_oxarticles_de`.`oxpic7`, `oxv_oxarticles_de`.`oxpic8`, `oxv_oxarticles_de`.`oxpic9`, `oxv_oxarticles_de`.`oxpic10`, `oxv_oxarticles_de`.`oxpic11`, `oxv_oxarticles_de`.`oxpic12`, `oxv_oxarticles_de`.`oxweight`, `oxv_oxarticles_de`.`oxstock`, `oxv_oxarticles_de`.`oxstockflag`, `oxv_oxarticles_de`.`oxstocktext`, `oxv_oxarticles_de`.`oxnostocktext`, `oxv_oxarticles_de`.`oxdelivery`, `oxv_oxarticles_de`.`oxinsert`, `oxv_oxarticles_de`.`oxtimestamp`, `oxv_oxarticles_de`.`oxlength`, `oxv_oxarticles_de`.`oxwidth`, `oxv_oxarticles_de`.`oxheight`, `oxv_oxarticles_de`.`oxfile`, `oxv_oxarticles_de`.`oxsearchkeys`, `oxv_oxarticles_de`.`oxtemplate`, `oxv_oxarticles_de`.`oxquestionemail`, `oxv_oxarticles_de`.`oxissearch`, `oxv_oxarticles_de`.`oxisconfigurable`, `oxv_oxarticles_de`.`oxvarname`, `oxv_oxarticles_de`.`oxvarstock`, `oxv_oxarticles_de`.`oxvarcount`, `oxv_oxarticles_de`.`oxvarselect`, `oxv_oxarticles_de`.`oxvarminprice`, `oxv_oxarticles_de`.`oxvarmaxprice`, `oxv_oxarticles_de`.`oxbundleid`, `oxv_oxarticles_de`.`oxfolder`, `oxv_oxarticles_de`.`oxsubclass`, `oxv_oxarticles_de`.`oxsort`, `oxv_oxarticles_de`.`oxsoldamount`, `oxv_oxarticles_de`.`oxnonmaterial`, `oxv_oxarticles_de`.`oxfreeshipping`, `oxv_oxarticles_de`.`oxremindactive`, `oxv_oxarticles_de`.`oxremindamount`, `oxv_oxarticles_de`.`oxamitemid`, `oxv_oxarticles_de`.`oxamtaskid`, `oxv_oxarticles_de`.`oxvendorid`, `oxv_oxarticles_de`.`oxmanufacturerid`, `oxv_oxarticles_de`.`oxskipdiscounts`, `oxv_oxarticles_de`.`oxrating`, `oxv_oxarticles_de`.`oxratingcnt`, `oxv_oxarticles_de`.`oxmindeltime`, `oxv_oxarticles_de`.`oxmaxdeltime`, `oxv_oxarticles_de`.`oxdeltimeunit`, `oxv_oxarticles_de`.`oxupdateprice`, `oxv_oxarticles_de`.`oxupdatepricea`, `oxv_oxarticles_de`.`oxupdatepriceb`, `oxv_oxarticles_de`.`oxupdatepricec`, `oxv_oxarticles_de`.`oxupdatepricetime`, `oxv_oxarticles_de`.`oxisdownloadable`, `oxv_oxarticles_de`.`oxshowcustomagreement`, `oxv_oxarticles_de`.`oxefichecksum`, `oxv_oxarticles_de`.`oxeficschecksum`, `oxv_oxarticles_de`.`oxeficatchecksum`, `oxv_oxarticles_de`.`oxefivendorchecksum`, `oxv_oxarticles_de`.`oxefiattribchecksum`, `oxv_oxarticles_de`.`oxefiartextchecksum`, `oxv_oxarticles_de`.`oxefimanufactchecksum`, `oxv_oxarticles_de`.`oxaddparams`, `oxv_oxarticles_de`.`asy_seotitle`, `oxv_oxarticles_de`.`d3importflag`, `oxv_oxarticles_de`.`d3importprofileid`, `oxv_oxarticles_de`.`d3importpic1`, `oxv_oxarticles_de`.`d3importpic2`, `oxv_oxarticles_de`.`d3importpic3`, `oxv_oxarticles_de`.`d3importpic4`, `oxv_oxarticles_de`.`d3importpic5`, `oxv_oxarticles_de`.`d3importpic6`, `oxv_oxarticles_de`.`d3importpic7`, `oxv_oxarticles_de`.`d3importpic8`, `oxv_oxarticles_de`.`d3importpic9`, `oxv_oxarticles_de`.`d3importpic10` from oxv_oxarticles_de where 1 and oxv_oxarticles_de.oxparentid = '' LIMIT 0, 17, for user DB192808_7SER
Stack Trace: #0 /srv/www/shop_url/core/adodblite/adodbSQL_drivers/mysql/mysql_driver.inc(369): adodb_throw('mysql', 'EXECUTE', 1054, 'Unknown column ...', 'select `oxv_oxa...', false, Object(object_ADOConnection))
#1 /srv/www/shop_url/core/adodblite/adodb.inc.php(334): mysql_driver_ADOConnection->do_query('select `oxv_oxa...', 0, 17, false)
#2 /srv/www/shop_url/core/oxlegacydb.php(188): ADOConnection->SelectLimit('select `oxv_oxa...', 17, 0, false)
#3 /srv/www/shop_url/core/oxlist.php(389): oxLegacyDb->selectLimit('select `oxv_oxa...', 17, 0)
#4 /srv/www/shop_url/application/models/oxarticlelist.php(83): oxList->selectString('select `oxv_oxa...')
#5 /srv/www/shop_url/application/controllers/admin/oxadminlist.php(813): oxArticleList->selectString('select `oxv_oxa...')
#6 /srv/www/shop_url/application/controllers/admin/article_list.php(59): oxAdminList->getItemList()
#7 /srv/www/shop_url/core/oxshopcontrol.php(465): Article_List->render()
#8 /srv/www/shop_url/core/oxshopcontrol.php(350): oxShopControl->_render(Object(Article_List))
#9 /srv/www/shop_url/modules/_d3modcfg/modules/controllers/d3_oxshopcontrol_modcfg_extension.php(0): oxShopControl->_process('article_list', NULL, NULL, NULL)
#10 /srv/www/shop_url/core/oxshopcontrol.php(123): d3_oxshopcontrol_modcfg_extension->_process('article_list', NULL, NULL, NULL)
#11 /srv/www/shop_url/modules/_d3modcfg/modules/controllers/d3_oxshopcontrol_modcfg_extension.php(0): oxShopControl->start(NULL, NULL, NULL, NULL)
#12 /srv/www/shop_url/modules/NfqBanklink/SkrilloxShopControl.php(53): d3_oxshopcontrol_modcfg_extension->start()
#13 /srv/www/shop_url/core/oxid.php(38): SkrilloxShopControl->start()
#14 /srv/www/shop_url/index.php(28): Oxid::run()
#15 /srv/www/shop_url/admin/index.php(27): require_once('/srv/www/gertpa...')
#16 {main}
Connection Adress -->
Connection Error -->
---------------------------------------------
PS: Das temp-Verzeichnis wurde mehrmals gelöscht und auch die Views neu angelegt.
mfg
Gert