Fehler: /index.jsp

Date:		Mon Sep 25 17:13:42 CEST 2017
URI:		/index.jsp
URL:		http://www.mybauer.de/index.jsp
RemoteHost:		54.198.28.114
RemoteAddr:		54.198.28.114
RemoteUser:		null
Path:		/index.jsp
Query:		action=2&action2=2&productname=siemens&searchCat=14771571&searchCat=14771369
Method:		GET
ContentType:	null

Exception:

multex.Exc: SQLException: Duplicate key or integrity constraint violation message from server: "Column 'category_oid_fk' in where clause is ambiguous" SELECT p.`name`, p.`vendor_id`, p.`asin`, p.`ean`, p.`aval_type`, p.`system`, p.`language`, p.`category_oid_fk`, p.`type`, p.`access`, p.`status`, p.`tax_pro`, p.`weight`, p.`purchase_price1`, p.`purchase_price2`, p.`purchase_price3`, p.`purchase_price4`, p.`purchase_price5`, p.`selling_price`, p.`uvp`, p.`vendor_oid_fk`, p.`price_date`, p.`creation_date`, p.`offer_date`, p.`eol_date`, p.`listout_date`, p.`delivery_date`, p.`followup_product_oid_fk`, p.`template_oid_fk`, p.`discountable`, p.`usk`, p.`stock_real`, p.`stock_all`, p.`stock_extern`, p.`stock_ordered`, p.`stock_reserved`, p.`search_name`, p.`palette`, p.`productcondition`, p.`moq`, p.`min_stock`, p.`tax_rate`, p.`modifications`, p.`mainsupplier_oid_fk`, p.`number`, p.`ve`, p.`lba`, p.`lba_cur`, p.`adminuser_oid_fk`, p.`adminuser2_oid_fk`, p.`relevanz`, p.`salesrank`, p.`oid` FROM `product` p inner join productcategory pc on p.oid = pc.product_oid_fk inner join productpricegroupprice ppgp on p.oid = ppgp.product_oid_fk WHERE category_oid_fk IN (14771573,14771699,14771707,14771727,14771575,18715646,18502607,14771587,14771597,14771605,14771615,14771629,14771639,14771643,14771657,43335648,14771675,14771677,14771679,14771687,14771693,14771577,14771579,14771581,14771583,14771585,18715653,18715655,18502729,18502733,14771589,14771591,14771593,14771595,14771599,14771601,14771603,14771607,14771609,14771611,14771613,14771617,14771619,14771621,14771623,14771625,14771627,14771631,14771633,14771635,14771637,14771641,14771645,14771647,14771649,14771651,14771653,14771655,14771661,14771659,14771663,14771665,14771667,14771669,14771671,14771673,14771681,14771683,18504925,14771685,14771689,14771691,14771695,14771697,14771701,14771703,14771705,14771709,14771711,14771723,14771725,14771713,14771715,14771717,14771719,14771721,14771571,14771371,18619907,14771373,14771375,14771383,14771407,14771425,14771427,14771429,14771437,14771463,14771465,14771377,14771379,14771381,14771385,14771387,14771389,14771391,14771393,14771395,14771397,14771399,14771401,14771403,14771405,14771409,14771411,14771413,14771415,14771417,14771419,14771421,14771423,14771431,14771433,14771435,14771441,14771443,14771445,14771447,14771449,14771451,14771453,14771439,14771455,14771457,14771459,14771461,14771369) AND ppgp.productpricegroup_oid_fk=1 AND ppgp.price > 5.0 AND p.oid in (18926557,18926493,18845811,26151567,48753694,48753601,48752313,48752221,48731047,48730956,48730865,48730774,48730144,48730053,48729961,48730683,48702333,48693135,48702153,48675681,48675591,48702840,48674984,48661770,48662451,48688164,48675078,48702423,48688073,48662709,48661985,48662080,48661873,46603287,46602136,43319522,43319461,43319405,43319348,43319292,43318556,43318500,43314999,43314943,43314887,43294590,43292563,42057067,35347129,34913745,34913682,34913620,34913494,34913432,34913370,34913245,34913058,34911789,34911746,34905560,26157912,26157806,26147921,26147708,26147660,26144587,26144539,18846250,18846203,18846152,18845954,18845906,18845839,18845680,18845631,18845581,18845531,18845481,18845331,18845281,18845181,18845080,18845019,18844965,18844915,18844865,18844815,18844763,18844713,18844613,18844563,18844512,18842605,18842546,18842482,18842113,18842062,18842009,18830875,18830824,18828858,18255477,17457859,17457805,17457911,16994063,16993837,16993815,16993751,16993719,16993697,16993551,16993529,16993498,16993467,16993405,16993311,16991983,16991926,16991862,14942975,14942953,14942931,14942887,14942865,14942843,14937164,8637935,8637911,8579711,8579619,10054708,44305959,43328531,34913558,34913308,18846102,18842165,16991768,14942909,48706800,48706706,48706612,48706518,48692431,48729395,48687014,48675771,48675481,48662623,48729489,48706330,48706046,48687105,48692337,48689586,48689680,48706140,46605470,46605376,46605094,46604409,46604302,46604197,46602710,43328169,43327658,43327371,43327307,43327243,43327174,43324498,43324426,43324204,43324129,43323910,43323767,43323695,43323621,43323119,43321886,43321814,43321668,43321595,43321523,43321449,43321093,43320807,43320735,43320518,43320447,43320230,43319179,43319123,43319067,43318839,43318726,43318367,43318296,43318231,43318166,43318097,43317961,43317894,43317824,43317757,43317694,43317561,43317494,43317290,43317226,43317149,43316998,43316934,43316803,43316734,43316601,43316537,43316470,43316406,43316207,43316070,43315938,43315867,43315736,43315604,43315476,43315235,43315114,43315055,43314342,43314267,43314110,43313733,43313433,43313319,43313217,43312298,43312096,43311975,43311900,43311745,43311515,43311451,43311212,43311126,43310393,43310323,43307957,43307199,43303916,43300206,43299842,43306778,43299469,43299315,43298194,43296610,43296443,43296117,43294505,43294355,43294254,43294108,43293120,43292765,43292638,43292438,43291996,43291894,43291061,43290679,43290284,43290134,43289930,43289786,43288956,43285330,43276604,43292374,43258669,43348514,43195894,43307792,43293866,42351386,42417927,43107664,34919524,34919117,34915197,34915145,34913182,34912932,34912870,34912808,34912746,34912681,34912618,34912556,34912494,34912426,34912360,34912292,34912224,34909071,34909010,26144894,26144844,26143883,26138300,18867271,18867194,18867109,18867047,18866974,18843845,18843680,18843595,18843264,18842916,18842836,18842765,18838087,18838038,18837971,18837922,18837872,18837819,18837768,18837715,18837664,18837613,18837562,18837511,18837460,18837409,18837358,18837305,18837252,18837201,18837150,18837099,18837048,18836997,18836945,18836894,18836846,18836796,18836696,18836161,18836061,18835959,18835259,18835158,18835006,18834946,18834694,18834642,18822789,18822503,18808598,18808498,18808549,18501525,17495927,17495899,17495853,17495825,17495776,17495727,17495482,17495216,17495151,17494869,17494747,17494704,17494413,17494364,17494321,17494277,17494233,17494182,17494118,16994243,16993604,16993573,16993374,16993342,16991895,16077132,14946103,14946082,14946045,14946009,14945937,14945915,14945893,14945827,14939695,14939673,14939651,14939629,14939585,14939564,14939542,14939520,14939477,14939455,14939433,14939412,14939391,14939346,14939301,14939218,14939196,14939174,14939152,14939131,14939067,14939024,14938303,14938270,14938198,14938125,14938088,14938051,14937939,14937900,14937514,14937475,14937436,14937359,14937320,14937279,14937241,14937203,9150558,8637957,8637695,4014528,4014279,1224009,1223520,1223564,1223475,1113721,832638,657000,656954,415755,303844,197103,109206,100962,100930,100885,100620,45270310,43322113,43320590,43318431,43316867,43316140,43315803,43314647,43314492,43314417,43314187,43313961,43313813,43313577,43313358,43313156,43313098,43312600,43312154,43312035,43311835,43299643,43288828,43293604,34919443,34918848,34918766,34918689,34911938,30703729,18843527,18843396,18836646,18825369,18825310,17495699,16993973,14945973,14939006,14937823,8578982,6447080,1223590,48716196,48716102,48716655,48706234,48728725,48728819,46603877,46603661,46603560,46603449,46601824,46601743,46601662,46601506,46601427,43328095,43328021,43327949,43327877,43327805,43327731,43327584,43327512,43327046,43326848,43326716,43326452,43324353,43324058,43323985,43323547,43323474,43323334,43323189,43322944,43322183,43322041,43321966,43321233,43321163,43321024,43320303,43320158,43320085,43319940,43319863,43319722,43319649,43319578,43315542,43312979,43312835,43311383,43310975,43310901,43310829,43310752,43310683,43310546,43310468,43306611,43306461,43306153,43305885,43305746,43305493,43301169,43300362,43306934,43303083,43304908,43302937,43303496,43305064,43306283,43305625,43305221,43307343,43306015,43302012,43295863,43295756,43295652,43295242,43295035,43291766,43289987,43289504,43289394,43289278,43289169,43289055,43287078,43286835,43285207,43285074,43284952,43284796,43284675,43284527,43284355,43307062,43348684,39139787,36958398,35347320,34932244,34932133,34932018,34931798,34931425,34931356,34931266,34918115,34917637,34917536,34917441,34917224,34916673,34916483,34915938,34915730,34910181,34907035,34903680,34903429,34917759,31818319,31315540,31315449,31315277,31315115,31315032,31314068,31314907,31315720,31313972,31309904,26153307,26152720,26144089,26142375,18900931,18900642,18866740,18866500,18866129,18865935,18865646,18865445,18836263,18836212,18836111,18836010,18835764,18835562,18835210,18835089,18834815,18834098,18833752,18833634,18833403,18833291,18833181,18833007,18832602,18832483,18832323,18833519,18825856,18823527,18823453,18823377,18823298,18823222,18823143,18822561,18817336,18690995,18130490,17569457,17495370,17495326,17495282,17495039,16654157,15577225,15576592,14943486,14943440,10210729,9789133,10038707,9241252,8928857,8905682,8905667,8905652,8905623,8905114,8905097,8905076,8904983,8904966,8697078,8696778,8377952,8467516,8905055,7465695,5188791,4629377,4674925,4539360,4027511,3366471,3099708,3099627,1224029,1039779,1017688,303855,43327439,43323838,43322250,43321740,43321376,43320375,43314035,43312748,43311041,43310614,43302747,43288450,43348821,38684316,35347711,35347416,34931945,34916769,34909956,31477432,26144042,18834744,18831155,18826940,18825503,18824661,16655788,15576277,14945849,4014565,117418,46601980,46601905,46601585,43326056,43325653,43323031,43320951,43320881,43318783,43315171,43295967,43295546,43291496,43291270,43288695,43288565,43288338,43287984,43287871,43287710,43287562,43286952,43286588,43286473,43286351,43286084,43285925,35347939,35347510,34932575,34932345,34931030,34930866,34930105,34929386,34929224,34929153,34929057,34927955,34926394,34926070,34925965,34925724,34925610,34925506,34925206,34924982,34924759,34924640,34923974,34923852,34923397,34923024,34922909,34922800,34922683,34922543,34922426,34922302,34926969,34918048,34916027,34915640,34914462,34914033,34911672,34910969,34910438,34908679,34908593,34908500,34908401,34907507,34907418,34907340,34907142,34906348,34905899,34905616,34905047,34904842,34904706,34904438,34904212,34904105,34925851,34821142,34821017,34903335,31478487,31478325,31478015,31478119,26162469,26159595,26159503,26158815,26158545,26153474,26147375,26146660,26146423,26146334,26146254,26146174,26146031,26144954,26144735,26144648,18906044,18905936,18905836,18905579,18905479,18905324,18905224,18905123,18841720,18841637,18841556,18841471,18841301,18841219,18841136,18840927,18840843,18840721,18840575,18840493,18840398,18840313,18840232,18839465,18839363,18839302,18839208,18838314,18838229,18836746,18834295,18834231,18832804,18831321,18830731,18830542,18830276,18829803,18829667,18825126,18824591,18824510,18824430,18823731,18823667,18815647,18815381,18815296,18815030,18814935,18814850,18814762,18814676,18814161,18814083,18813516,18813361,18905026,18815200,18834503,18505010,18130386,17493586,17493478,17487972,17487300,17486017,17485873,17485647,17485167,17499288,16655342,16655260,16655220,16655140,16655059,16654935,16654853,16654813,16654324,16654283,16654178,15576727,14946803,14946779,14946733,14946710,14946501,14946400,14945628,14944297,14944275,14944252,14944230,14944208,14944186,14944142,14944097,14944074,14944052,14943922,14943899,14943832,14943717,14943463,14943302,14941350,14941277,14939369,14939324,14938014,14635709,14630554,14522541,13568322,13568208,13547134,11801780,11582290,11548600,12092713,11657311,10109286,8905597,8905584,8905571,8905038,8904949,8904932,8829822,8697105,8696727,8667511,8600842,8599817,8599796,8499719,8499684,8369473,8369446,8369422,8369348,8369323,8369275,8369226,8369197,8369178,8337304,8319566,8214263,7839696,6973233,6973196,6973173,6973102,6972965,6972925,4660683,4628831,4065402,3716067,3716045,3735821,3067768,3065341,3065318,43323403,43320664,43320012,43296043,43286722,35347802,35347608,34929573,34925310,34917981,34911309,34907245,34906977,34906819,34906760,34906568,34906505,34906008,34905806,34905712,34904639,34903827,34903738,34903512,34903246,34903182,34821223,34821082,18843985,18838157,18834169,18831683,18831591,18831510,18831234,18830155,18823601,17485319,16976614,17485574,16150488,14943945,14943694,14078921,11548575,5331361,4791852,34928235,34928165,34905386,34905317,34905250,34905183,34905114,34904980,34904911,34904572,34904505,34904371,34820808,26161253,18828482,18814238,34931872,34931494,34928305,34928035,34927526,26162398,18817211,18814317) AND access & 1 > 0 AND `aval_type` NOT IN (0,5,6) AND `aval_type` IN (1,2,3,4,7) AND discountable & 8194 = 0 AND (discountable & 32 = 0 OR (discountable & 32 > 0 AND vendor_oid_fk in (25181543,101049,103882,100676,103191))) AND (discountable & 512 = 0 OR (discountable & 512 > 0 AND vendor_oid_fk in (100676,25181543,103882,23378,100084,103826,103160,26312691))) ORDER BY category_oid_fk, name ASC,price ASC java.sql.SQLException: Duplicate key or integrity constraint violation message from server: "Column 'category_oid_fk' in where clause is ambiguous" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224) at com.mysql.jdbc.Connection.execSQL(Connection.java:2244) at com.mysql.jdbc.Connection.execSQL(Connection.java:2192) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1163) at tools.db.FSConnection.getDBResult(FSConnection.java:417) at tools.db.DbObjectHelper.doSelect(DbObjectHelper.java:98) at tools.db.DbObjectHelper.selectMatch(DbObjectHelper.java:551) at tools.db.DbCollection3.search(DbCollection3.java:410) at tools.db.DbCollection3.search(DbCollection3.java:359) at com.ipilum.cms.Products.search(Products.java:1936) at com.ipilum.cms.Products.genDetailSearch(Products.java:2318) at com.ipilum.cms.pages.DetailSearchNewView.genHtml(DetailSearchNewView.java:45) at com.ipilum.cms.ContentBuilder.buildContent(ContentBuilder.java:887) at com.ipilum.cms.ContentBuilder.build(ContentBuilder.java:684) at _jsp._index__jsp._jspService(_index__jsp.java:125) at _jsp._index__jsp._jspService(_index__jsp.java:70) at com.caucho.jsp.JavaPage.service(JavaPage.java:64) at com.caucho.jsp.Page.pageservice(Page.java:542) at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:194) at com.caucho.server.httpcache.ProxyCacheFilterChain.doRequestCacheable(ProxyCacheFilterChain.java:251) at com.caucho.server.httpcache.ProxyCacheFilterChain.doFilter(ProxyCacheFilterChain.java:192) at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:156) at com.caucho.server.webapp.AccessLogFilterChain.doFilter(AccessLogFilterChain.java:95) at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:289) at com.caucho.server.hmux.HmuxRequest.handleInvocation(HmuxRequest.java:468) at com.caucho.server.hmux.HmuxRequest.handleRequestImpl(HmuxRequest.java:369) at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:336) at com.caucho.network.listen.TcpSocketLink.dispatchRequest(TcpSocketLink.java:1301) at com.caucho.network.listen.TcpSocketLink.handleRequest(TcpSocketLink.java:1257) at com.caucho.network.listen.TcpSocketLink.handleRequestsImpl(TcpSocketLink.java:1241) at com.caucho.network.listen.TcpSocketLink.handleRequests(TcpSocketLink.java:1149) at com.caucho.network.listen.TcpSocketLink.handleAcceptTaskImpl(TcpSocketLink.java:950) at com.caucho.network.listen.ConnectionTask.runThread(ConnectionTask.java:117) at com.caucho.network.listen.ConnectionTask.run(ConnectionTask.java:93) at com.caucho.network.listen.SocketLinkThreadLauncher.handleTasks(SocketLinkThreadLauncher.java:169) at com.caucho.network.listen.TcpSocketAcceptThread.run(TcpSocketAcceptThread.java:61) at com.caucho.env.thread2.ResinThread2.runTasks(ResinThread2.java:173) at com.caucho.env.thread2.ResinThread2.run(ResinThread2.java:118) at tools.db.DbObjectHelper.doSelect(DbObjectHelper.java:181) at tools.db.DbObjectHelper.selectMatch(DbObjectHelper.java:551) at tools.db.DbCollection3.search(DbCollection3.java:410) at tools.db.DbCollection3.search(DbCollection3.java:359) at com.ipilum.cms.Products.search(Products.java:1936) at com.ipilum.cms.Products.genDetailSearch(Products.java:2318) at com.ipilum.cms.pages.DetailSearchNewView.genHtml(DetailSearchNewView.java:45) at com.ipilum.cms.ContentBuilder.buildContent(ContentBuilder.java:887) at com.ipilum.cms.ContentBuilder.build(ContentBuilder.java:684) at _jsp._index__jsp._jspService(_index__jsp.java:125) at _jsp._index__jsp._jspService(_index__jsp.java:70) at com.caucho.jsp.JavaPage.service(JavaPage.java:64) at com.caucho.jsp.Page.pageservice(Page.java:542) at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:194) at com.caucho.server.httpcache.ProxyCacheFilterChain.doRequestCacheable(ProxyCacheFilterChain.java:251) at com.caucho.server.httpcache.ProxyCacheFilterChain.doFilter(ProxyCacheFilterChain.java:192) at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:156) at com.caucho.server.webapp.AccessLogFilterChain.doFilter(AccessLogFilterChain.java:95) at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:289) at com.caucho.server.hmux.HmuxRequest.handleInvocation(HmuxRequest.java:468) at com.caucho.server.hmux.HmuxRequest.handleRequestImpl(HmuxRequest.java:369) at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:336) at com.caucho.network.listen.TcpSocketLink.dispatchRequest(TcpSocketLink.java:1301) at com.caucho.network.listen.TcpSocketLink.handleRequest(TcpSocketLink.java:1257) at com.caucho.network.listen.TcpSocketLink.handleRequestsImpl(TcpSocketLink.java:1241) at com.caucho.network.listen.TcpSocketLink.handleRequests(TcpSocketLink.java:1149) at com.caucho.network.listen.TcpSocketLink.handleAcceptTaskImpl(TcpSocketLink.java:950) at com.caucho.network.listen.ConnectionTask.runThread(ConnectionTask.java:117) at com.caucho.network.listen.ConnectionTask.run(ConnectionTask.java:93) at com.caucho.network.listen.SocketLinkThreadLauncher.handleTasks(SocketLinkThreadLauncher.java:169) at com.caucho.network.listen.TcpSocketAcceptThread.run(TcpSocketAcceptThread.java:61) at com.caucho.env.thread2.ResinThread2.runTasks(ResinThread2.java:173) at com.caucho.env.thread2.ResinThread2.run(ResinThread2.java:118)

Session Vars:

ClickCount: 1 accessmode2: 1 curDispatchCountry: Deutschland(10208) curOrderHead: Online-Bestellung 0(-1) curShopProducts: com.ipilum.cms.Products@74cba4b curUser: (-1) err: [] lang: 0 msg: [] remoteAddress: 54.198.28.114 start_date: Mon Sep 25 17:13:42 CEST 2017 user-agent: CCBot/2.0 (http://commoncrawl.org/faq/)

Parameter aus dem Request:

searchCat: 14771571 action: 2 productname: siemens action2: 2

Parameter aus dem Header:

If-Modified-Since: Sun, 23 Jul 2017 16:43:57 GMT SSL_CIPHER_EXPORT: Host: www.mybauer.de SSL_PROTOCOL: Accept-Encoding: x-gzip, gzip, deflate SSL_CLIENT_S_DN: User-Agent: CCBot/2.0 (http://commoncrawl.org/faq/) SSL_CIPHER_USEKEYSIZE: Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 SSL_CIPHER_ALGKEYSIZE: SSL_CIPHER:



Time:55ms
Nr.ConnectionNameQuerysCacheHitsCacheQuoteCacheTime
0db1824288 505669 443505 87.70658% 0.0

ConnectionNameQuerysCacheHitsCacheQuoteSpeicher
db1824288 505669 443505 87.70658% 1.85MB/150.kB
TabelleNutzungTreffer
dynamicaccessorystatic10025
pricegroup1115
bannertype1302
difference100126
adminusermenuitem10
matchsite2204
informationproperty165968
productpropertyname174703
featurename9926
dealercategory593141
productcategory991355
adminuserprivilege11
orderhead10029
matchartikel10031
status395775
languagecomponent100946
adminuserfavorite236
stockdealerproduct65108
productcostprofileproduct84
checklistprotokoll528
textcomponent51663
productproperty67
customer992275
speakpartner72
dispatchpayment81204
dynamicaccessory98763
productdescription100222
categoryimage1001
paymentcost10
orderproperty10
checklistitem15
senderexport7552
specialoffer271034
category9827
productean98393
featureunit611
information43577
orderexternstatus1515
productpricegroup615390
dispatchpaymentproperty106
pricerequest114
dealerproduct221
property100158
timeprofil110106
emailtemplatetext517
ordertype5164
orderhistory10
shoplayoutproperty10
outstandingitem991
productcoment98314
payment2117864
product40
categoryprovision1004758
dispatchcountry111239
adminuseraction215
productavailabilitystatus61648
featurevalue9983
customerproperty1319
htmlform1302
priceproperty7455
dealerproductfeaturename23219
holiday14
action830
template99321
banktransaction8079
productavailabilitystatusproperty4142
conditioncalculation13676
orderpos9979
dispatchprice19
setartikelpos59130
partorderpos20
protokoll20
productavailabilitystatusconfiguration161
emailaccount311
dealerproductfeature10014
languagetext21
accessory9811
vendor3798
channel555
topsellerproductlist129
emailtemplate56
productselectionproperty10
storedealerproduct62111
dispatchregioncountry43485
emailtemplateaction712
shoplayout111
productpricegroupprice99206
sender41358
senderselect10
senderselectproperty90
productaction14
htmlpage290
dispatchregion23483
rewriteurl11
conditionproperty13676
productpricestatus998
modul59255
questionartikel338
productindexkeyword3967
templatecomponent100166
store81070
partnerprogram6105
lexikon11
shiptoaddress98121
emailtemplateproperty9818823
pricelist223
condition152
directflow10
productimage98191
orderheadreference9838
dispatchpricegroup2319
errormessage224
dispatchcost99271
orderevent19
stockselect15
shoplayoutpage22270
categorydescription10043
categorytexttype261
productcondition123
excludeshop1204
topsellerproduct129
matchvendor1204
emailaction11
article100225
termin641
viewlistcolumn51270
configuratorproductconfiguration12
producttexttype76027
rma743
productfeature9914
emailfilter11
stock782673
wordblacklist13
stockselectproperty620
currency1308
checklist12
matchshop991942
component63200
bankaccount6853
language1554
productselection10
email413
checklistproperty390
contenttype20
partner312
DatabaseProductName MySQL
DatabaseURL jdbc:mysql://192.168.1.3:3306/db1824288?characterEncoding=UTF-8&autoReconnect=true
DatabaseProductVersion 5.5.33
DriverVersion 3 / 0
DriverName MySQL-AB JDBC Driver
DriverVersion:mysql-connector-java-3.0.15-ga ( $Date: 2004/08/09 22:15:11 $, $Revision: 1.27.2.43 $ )
TimeOut /Object-ID:9 / tools.db.FSConnection@1ed35670
Debuginfo:
TopPage: null SubPage: null   Action:
RequestURI: /index.jsp
Session: aaaud3xku14zI6V8DM56v New?true
Date:Mon Sep 25 17:13:42 CEST 2017
Path:/index.jsp
Query:action=2&action2=2&productname=siemens&searchCat=14771571&searchCat=14771369
Method:GET
ContentType:null
URI:/index.jsp
URL:http://www.mybauer.de/index.jsp
RemoteHost:54.198.28.114
RemoteAddr:54.198.28.114
RemoteUser:null
SessionVars
ClickCount: 1
accessmode2: 1
curDispatchCountry: Deutschland(10208)
curOrderHead: Online-Bestellung 0(-1)
curShopProducts: com.ipilum.cms.Products@74cba4b
curUser: (-1)
err: []
lang: 0
msg: []
remoteAddress: 54.198.28.114
start_date: Mon Sep 25 17:13:42 CEST 2017
user-agent: CCBot/2.0 (http://commoncrawl.org/faq/)

Parameter aus dem Request:

searchCat: 14771571
action: 2
productname: siemens
action2: 2

Parameter aus dem Header:

If-Modified-Since: Sun, 23 Jul 2017 16:43:57 GMT
SSL_CIPHER_EXPORT:
Host: www.mybauer.de
SSL_PROTOCOL:
Accept-Encoding: x-gzip, gzip, deflate
SSL_CLIENT_S_DN:
User-Agent: CCBot/2.0 (http://commoncrawl.org/faq/)
SSL_CIPHER_USEKEYSIZE:
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
SSL_CIPHER_ALGKEYSIZE:
SSL_CIPHER: