NoID
63d1ecbf28c4967e116d311fe556c085
20130602230145
2
/home/labellusso/data/ProdMain.inc
468
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: message: Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (severity 13) [query]select   top 8   PMInc,CustKind,CustID,ServiceID,VenID,ProdKind,ProdInc,MallKind,MallID,AWInc,SellerID,Brand,BrandID,BrandKor,Ccode1,Ccode2,Ccode3,Ccode4,Pname,ShortStory,Nation,Maker,Purl,Pimg=convert(text,Pimg),LogoImg,Lprice,Sprice,Lrprice,Srprice,Lbprice,Sbprice,Amount,AmountB,StockCntOptYes,StockCnt,StockCntB,MinCntB,Profit,StoryKor,FPMInc,ViewYes,ValidYes,DeleteYes,B2BYes,SetYes,Stock,ColorCnt,ClickCnt,SellCnt,State,RepayOathYes,CMInc,ProtPimg,ProtLrprice,ProtSrprice,ProtStock,ProtColorImg,ProtStillImg,BigImgRYes,GongGuYes,JoinOnlyYes,MagicViewYes,KeepSrpriceYes,ProdCouponDcYes,ProdCouponDcKind,ProdCouponDcValue,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,CustIco6Yes,CustIco7Yes,CustIco8Yes,CustIco9Yes,CustIco10Yes,OptColorTxt,VideoYes,TypeCode,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psProdMain  
					p 
				left join
					(select ClickCntByLog=count(PCInc),PMIncByLog=PMInc from psProdClickLog where CreateDate8 > '20130526' group by PMInc) pcc
				on
					p.PMInc = pcc.PMIncByLog
				 where DeleteYes=0   and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD'  and Sprice > 0) )  and ProdKind not in ('SELF' ,'AGTR' ,'ACSELF' ,'ACAGTR' )  and JoinOnlyYes = 0  and GongGuYes=0   and ProdKind <> 'SELF'   and Ccode1='14'  and Ccode2='17'  order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#
NoID
63d1ecbf28c4967e116d311fe556c085
20130602230145
2
/home/labellusso/data/ProdMain.inc
468
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: General SQL Server error: Check messages from the SQL Server (severity 13) [query]select   top 8   PMInc,CustKind,CustID,ServiceID,VenID,ProdKind,ProdInc,MallKind,MallID,AWInc,SellerID,Brand,BrandID,BrandKor,Ccode1,Ccode2,Ccode3,Ccode4,Pname,ShortStory,Nation,Maker,Purl,Pimg=convert(text,Pimg),LogoImg,Lprice,Sprice,Lrprice,Srprice,Lbprice,Sbprice,Amount,AmountB,StockCntOptYes,StockCnt,StockCntB,MinCntB,Profit,StoryKor,FPMInc,ViewYes,ValidYes,DeleteYes,B2BYes,SetYes,Stock,ColorCnt,ClickCnt,SellCnt,State,RepayOathYes,CMInc,ProtPimg,ProtLrprice,ProtSrprice,ProtStock,ProtColorImg,ProtStillImg,BigImgRYes,GongGuYes,JoinOnlyYes,MagicViewYes,KeepSrpriceYes,ProdCouponDcYes,ProdCouponDcKind,ProdCouponDcValue,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,CustIco6Yes,CustIco7Yes,CustIco8Yes,CustIco9Yes,CustIco10Yes,OptColorTxt,VideoYes,TypeCode,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psProdMain  
					p 
				left join
					(select ClickCntByLog=count(PCInc),PMIncByLog=PMInc from psProdClickLog where CreateDate8 > '20130526' group by PMInc) pcc
				on
					p.PMInc = pcc.PMIncByLog
				 where DeleteYes=0   and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD'  and Sprice > 0) )  and ProdKind not in ('SELF' ,'AGTR' ,'ACSELF' ,'ACAGTR' )  and JoinOnlyYes = 0  and GongGuYes=0   and ProdKind <> 'SELF'   and Ccode1='14'  and Ccode2='17'  order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#