Hi,
I updated from 4.8.5 to 4.8.6 as usual running updateApp and applying all changes. Now I tried to do a test order, but after pressing the final checkout button there comes the message “shop offline”. This is my exeption. It seems like something with DB is not okay. Any tipps?
oxConnectionException-oxException (time: 2014-06-20 15:43:38): [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`.`oxparentid`, `oxv_oxarticles_de`.`oxvarstock`, `oxv_oxarticles_de`.`oxvarcount`, `oxv_oxarticles_de`.`oxstock`, `oxv_oxarticles_de`.`oxshopid`, `oxv_oxarticles_de`.`oxvat`, `oxv_oxarticles_de`.`oxactive`, `oxv_oxarticles_de`.`oxbundleid`, `oxv_oxarticles_de`.`oxprice`, `oxv_oxarticles_de`.`oxskipdiscounts`, `oxv_oxarticles_de`.`oxfreeshipping`, `oxv_oxarticles_de`.`oxnonmaterial`, `oxv_oxarticles_de`.`oxartnum`, `oxv_oxarticles_de`.`oxactivefrom`, `oxv_oxarticles_de`.`oxactiveto`, `oxv_oxarticles_de`.`oxean`, `oxv_oxarticles_de`.`oxdistean`, `oxv_oxarticles_de`.`oxmpn`, `oxv_oxarticles_de`.`oxtitle`, `oxv_oxarticles_de`.`oxshortdesc`, `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`.`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`.`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`.`oxvarselect`, `oxv_oxarticles_de`.`oxvarminprice`, `oxv_oxarticles_de`.`oxvarmaxprice`, `oxv_oxarticles_de`.`oxfolder`, `oxv_oxarticles_de`.`oxsubclass`, `oxv_oxarticles_de`.`oxsort`, `oxv_oxarticles_de`.`oxsoldamount`, `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`.`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` from oxv_oxarticles_de where 1 and oxv_oxarticles_de.oxid = '5a8dd9ce44446bf09e8045d835428577', for user db_oxidshop
Stack Trace: #0 /httpdocs/web/core/adodblite/adodbSQL_drivers/mysql/mysql_driver.inc(369): adodb_throw('mysql', 'EXECUTE', 1054, 'Unknown column ...', 'select `oxv_oxa...', false, Object(object_ADOConnection))
#1 /httpdocs/web/core/adodblite/generic_modules/pear_module.inc(70): mysql_driver_ADOConnection->do_query('select `oxv_oxa...', -1, -1, false)
#2 /httpdocs/web/core/oxlegacydb.php(115): pear_ADOConnection->GetRow('select `oxv_oxa...', false)
#3 /httpdocs/web/application/models/oxarticle.php(891): oxLegacyDb->getRow('select `oxv_oxa...')
#4 /httpdocs/web/application/models/oxarticle.php(913): oxArticle->_loadFromDb('5a8dd9ce44446bf...')
#5 /httpdocs/web/application/models/oxbasketitem.php(467): oxArticle->load('5a8dd9ce44446bf...')
#6 /httpdocs/web/modules/oe/oepaypal/models/oepaypaloxbasketitem.php(49): oxBasketItem->getArticle(true, NULL, true)
#7 /httpdocs/web/application/models/oxorder.php(856): oePayPalOxBasketItem->getArticle(true, NULL, true)
#8 /httpdocs/web/application/models/oxorder.php(731): oxOrder->_setOrderArticles(Array)
#9 /httpdocs/web/application/models/oxorder.php(510): oxOrder->_loadFromBasket(Object(oePayPalOxBasket))
#10 /httpdocs/web/application/controllers/order.php(234): oxOrder->finalizeOrder(Object(oePayPalOxBasket), Object(oePayPalOxUser))
#11 /httpdocs/web/core/oxview.php(539): order->execute()
#12 /httpdocs/web/core/oxshopcontrol.php(344): oxView->executeFunction('execute')
#13 /httpdocs/web/core/oxshopcontrol.php(123): oxShopControl->_process('order', 'execute', NULL, NULL)
#14 /httpdocs/web/core/oxid.php(38): oxShopControl->start()
#15 /httpdocs/web/index.php(27): Oxid::run()
#16 {main}
Connection Adress -->
Connection Error -->
---------------------------------------------
Thank you