Problem bei Variantenauswahl > Shop offline

icedoutbiz · March 27, 2015, 9:07pm

Hallo an alle,

sobald ich bei mir im Shop eine Variante auswähle kommt der Fehler “Shop offline”

In der Log erscheint dann diese Meldung:

oxConnectionException-oxException (time: 2015-03-27 21:03:45): [1064]: mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) order by rand()’ at line 1] in EXECUTE (select oxv_oxarticles_de.oxid, oxv_oxarticles_de.oxparentid, oxv_oxarticles_de.oxvarstock, oxv_oxarticles_de.oxstock, oxv_oxarticles_de.oxstockflag, oxv_oxarticles_de.oxvarcount, oxv_oxarticles_de.oxshopid, oxv_oxarticles_de.oxtitle, oxv_oxarticles_de.oxvarminprice, oxv_oxarticles_de.oxinsert, oxv_oxarticles_de.oxsoldamount, oxv_oxarticles_de.oxvarselect, oxv_oxarticles_de.oxvarname, oxv_oxarticles_de.oxactive, oxv_oxarticles_de.oxprice, oxv_oxarticles_de.oxpic1, oxv_oxarticles_de.oxpic2, oxv_oxarticles_de.oxicon, oxv_oxarticles_de.oxpic3, oxv_oxarticles_de.oxpic4, oxv_oxarticles_de.oxpic5, oxv_oxarticles_de.oxpic6, oxv_oxarticles_de.oxpic7, oxv_oxarticles_de.oxmanufacturerid, oxv_oxarticles_de.oxblfixedprice, oxv_oxarticles_de.oxquestionemail, oxv_oxarticles_de.oxartnum, oxv_oxarticles_de.oxshortdesc, oxv_oxarticles_de.oxskipdiscounts, oxv_oxarticles_de.oxvat, oxv_oxarticles_de.oxisconfigurable, oxv_oxarticles_de.oxtprice, oxv_oxarticles_de.oxunitquantity, oxv_oxarticles_de.oxstocktext, oxv_oxarticles_de.oxmindeltime, oxv_oxarticles_de.oxmaxdeltime, oxv_oxarticles_de.oxweight from oxv_oxarticles_de where ( oxv_oxarticles_de.oxactive = 1 and ( oxv_oxarticles_de.oxstockflag != 2 or ( oxv_oxarticles_de.oxstock + oxv_oxarticles_de.oxvarstock ) > 0 ) and IF( oxv_oxarticles_de.oxvarcount = 0, 1, ( select 1 from oxv_oxarticles_de as art where art.oxparentid=oxv_oxarticles_de.oxid and ( art.oxactive = 1 ) and ( art.oxstockflag != 2 or art.oxstock > 0 ) limit 1 ) ) ) and oxv_oxarticles_de.oxissearch = 1 and oxv_oxarticles_de.oxid in ( ) order by rand() , ) with user icekkjfo2

Stack Trace: #0 /icekkjfo/www.iced-out.biz/core/adodblite/adodbSQL_drivers/mysql/mysql_driver.inc(369): adodb_throw(‘mysql’, ‘EXECUTE’, 1064, ‘You have an err…’, ‘select oxv_oxa...', false, Object(object_ADOConnection)) #1 /icekkjfo/www.iced-out.biz/core/adodblite/adodb.inc.php(316): mysql_driver_ADOConnection->do_query('select oxv_oxa…’, -1, -1, false)
#2 /icekkjfo/www.iced-out.biz/core/oxlegacydb.php(140): ADOConnection->Execute(‘select oxv_oxa...', false) #3 /icekkjfo/www.iced-out.biz/core/oxlist.php(386): oxLegacyDb->select('select oxv_oxa…’)
#4 /icekkjfo/www.iced-out.biz/application/models/oxarticlelist.php(79): oxList->selectString(‘select oxv_oxa...') #5 /icekkjfo/www.iced-out.biz/application/models/oxarticle.php(1287): oxArticleList->selectString('select oxv_oxa…’)
#6 /icekkjfo/www.iced-out.biz/application/components/widgets/oxwarticledetails.php(706): oxArticle->getSimilarProducts()
#7 /icekkjfo/www.iced-out.biz/tmp/smarty/4fb6848dd20b83aa14daef6eea6d679b^%%1E^1E7^1E7B11A6%%related_products.tpl.php(19): oxwArticleDetails->getSimilarProducts()
#8 /icekkjfo/www.iced-out.biz/core/smarty/Smarty.class.php(1869): include(‘/icekkjfo/www.i…’)
#9 /icekkjfo/www.iced-out.biz/tmp/smarty/4fb6848dd20b83aa14daef6eea6d679b^%%5E^5E9^5E9B9D5B%%productmain.tpl.php(203): Smarty->_smarty_include(Array)
#10 /icekkjfo/www.iced-out.biz/core/smarty/Smarty.class.php(1869): include(‘/icekkjfo/www.i…’)
#11 /icekkjfo/www.iced-out.biz/tmp/smarty/4fb6848dd20b83aa14daef6eea6d679b^%%A5^A59^A595DDB8%%fullproductinfo.tpl.php(7): Smarty->_smarty_include(Array)
#12 /icekkjfo/www.iced-out.biz/core/smarty/Smarty.class.php(1869): include(‘/icekkjfo/www.i…’)
#13 /icekkjfo/www.iced-out.biz/tmp/smarty/4fb6848dd20b83aa14daef6eea6d679b^%%79^790^7907FF72%%details.tpl.php(88): Smarty->_smarty_include(Array)
#14 /icekkjfo/www.iced-out.biz/core/smarty/Smarty.class.php(1263): include(‘/icekkjfo/www.i…’)
#15 /icekkjfo/www.iced-out.biz/core/oxshopcontrol.php(508): Smarty->fetch(‘widget/product/…’, ‘ox|0|0|0|0’)
#16 /icekkjfo/www.iced-out.biz/core/oxshopcontrol.php(353): oxShopControl->_render(Object(oePayPalOxwArticleDetails))
#17 /icekkjfo/www.iced-out.biz/core/oxshopcontrol.php(126): oxShopControl->_process(‘oxwarticledetai…’, NULL, NULL, Array)
#18 /icekkjfo/www.iced-out.biz/core/oxwidgetcontrol.php(73): oxShopControl->start(NULL, NULL, NULL, Array)
#19 /icekkjfo/www.iced-out.biz/core/oxid.php(54): oxWidgetControl->start()
#20 /icekkjfo/www.iced-out.biz/widget.php(26): OXID::runWidget()
#21 {main}

Connection Adress –>
Connection Error –>

Hat jemand eine Idee?

OXID-Design · March 27, 2015, 9:23pm

Hallo,
schön das es geklappt hat mit der Filter und LazyLoad.

Er meckert über die sql query:

!!! have an error in your SQL syntax
!!! ‘You have an err…’, ‘select `oxv_oxa…’, false,

EDIT:

Du hast Produktdetailseite stark verändert und sehr viele Elemente entfernt. Dabei hast du vergessen dazugehörige javascripte zu entfernen. Einige abfragen wurden auch verändert.

[B] $(’#productTitle’).oxArticleActionLinksSelect();[/B] // wird nicht mehr benötigt
[B]jCarouselLite.js[/B] // erst laden wenn du Ihn brauchst
[B]MorePictureSlider [/B]// erst laden wenn du Ihn brauchst

Grüße
Rafig

yamahamoto22 · March 28, 2015, 4:52am

thank your post