NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220092449
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: message: Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. (severity 17) [query]select top 10 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 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='3' order by SellCnt desc ,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220092449
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 17) [query]select top 10 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 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='3' order by SellCnt desc ,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220092715
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: message: Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. (severity 17) [query]select top 10 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 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='3' order by SellCnt desc ,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220092715
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 17) [query]select top 10 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 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='3' order by SellCnt desc ,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220092739
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: message: Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. (severity 17) [query]select top 4 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 > '20130213' 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 BrandID='MARC JACOBS' order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220092739
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 17) [query]select top 4 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 > '20130213' 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 BrandID='MARC JACOBS' order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220092806
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: message: Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. (severity 17) [query]select top 40 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,OptColorTxt,VideoYes,TypeCode,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,CustIco6Yes,CustIco7Yes,CustIco8Yes,CustIco9Yes,CustIco10Yes from psProdMain where PMInc not in (select top 40 PMInc from psProdMain where DeleteYes=0 and BrandID='MARC JACOBS' 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 order by PMInc desc ) and DeleteYes=0 and BrandID='MARC JACOBS' 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 order by PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220092806
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 17) [query]select top 40 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,OptColorTxt,VideoYes,TypeCode,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,CustIco6Yes,CustIco7Yes,CustIco8Yes,CustIco9Yes,CustIco10Yes from psProdMain where PMInc not in (select top 40 PMInc from psProdMain where DeleteYes=0 and BrandID='MARC JACOBS' 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 order by PMInc desc ) and DeleteYes=0 and BrandID='MARC JACOBS' 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 order by PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220092806
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: message: Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. (severity 17) [query]select top 4 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 > '20130213' 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 BrandID='MARC JACOBS' order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220092806
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 17) [query]select top 4 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 > '20130213' 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 BrandID='MARC JACOBS' order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093252
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: message: Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. (severity 17) [query]select top 40 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,OptColorTxt,VideoYes,TypeCode,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,CustIco6Yes,CustIco7Yes,CustIco8Yes,CustIco9Yes,CustIco10Yes from psProdMain where PMInc not in (select top 80 PMInc from psProdMain where DeleteYes=0 and BrandID='MARC JACOBS' 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 order by PMInc desc ) and DeleteYes=0 and BrandID='MARC JACOBS' 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 order by PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093252
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 17) [query]select top 40 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,OptColorTxt,VideoYes,TypeCode,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,CustIco6Yes,CustIco7Yes,CustIco8Yes,CustIco9Yes,CustIco10Yes from psProdMain where PMInc not in (select top 80 PMInc from psProdMain where DeleteYes=0 and BrandID='MARC JACOBS' 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 order by PMInc desc ) and DeleteYes=0 and BrandID='MARC JACOBS' 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 order by PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093252
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: message: Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. (severity 17) [query]select top 4 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 > '20130213' 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 BrandID='MARC JACOBS' order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093252
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 17) [query]select top 4 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 > '20130213' 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 BrandID='MARC JACOBS' order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093258
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: message: Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. (severity 17) [query]select top 4 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 > '20130213' 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 BrandID='MARC JACOBS' order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093258
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 17) [query]select top 4 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 > '20130213' 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 BrandID='MARC JACOBS' order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093307
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: message: Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. (severity 17) [query]select top 40 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,OptColorTxt,VideoYes,TypeCode,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,CustIco6Yes,CustIco7Yes,CustIco8Yes,CustIco9Yes,CustIco10Yes from psProdMain where PMInc not in (select top 40 PMInc from psProdMain where DeleteYes=0 and BrandID='MARC JACOBS' 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 order by PMInc desc ) and DeleteYes=0 and BrandID='MARC JACOBS' 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 order by PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093307
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 17) [query]select top 40 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,OptColorTxt,VideoYes,TypeCode,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,CustIco6Yes,CustIco7Yes,CustIco8Yes,CustIco9Yes,CustIco10Yes from psProdMain where PMInc not in (select top 40 PMInc from psProdMain where DeleteYes=0 and BrandID='MARC JACOBS' 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 order by PMInc desc ) and DeleteYes=0 and BrandID='MARC JACOBS' 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 order by PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093307
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: message: Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. (severity 17) [query]select top 4 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 > '20130213' 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 BrandID='MARC JACOBS' order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093307
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 17) [query]select top 4 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 > '20130213' 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 BrandID='MARC JACOBS' order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093312
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: message: Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. (severity 17) [query]select top 40 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,OptColorTxt,VideoYes,TypeCode,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,CustIco6Yes,CustIco7Yes,CustIco8Yes,CustIco9Yes,CustIco10Yes from psProdMain where PMInc not in (select top 160 PMInc from psProdMain where DeleteYes=0 and BrandID='MARC JACOBS' 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 order by PMInc desc ) and DeleteYes=0 and BrandID='MARC JACOBS' 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 order by PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093312
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 17) [query]select top 40 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,OptColorTxt,VideoYes,TypeCode,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,CustIco1Yes,CustIco2Yes,CustIco3Yes,CustIco4Yes,CustIco5Yes,CustIco6Yes,CustIco7Yes,CustIco8Yes,CustIco9Yes,CustIco10Yes from psProdMain where PMInc not in (select top 160 PMInc from psProdMain where DeleteYes=0 and BrandID='MARC JACOBS' 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 order by PMInc desc ) and DeleteYes=0 and BrandID='MARC JACOBS' 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 order by PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093312
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: message: Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. (severity 17) [query]select top 4 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 > '20130213' 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 BrandID='MARC JACOBS' order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093312
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 17) [query]select top 4 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 > '20130213' 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 BrandID='MARC JACOBS' order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093315
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: message: Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. (severity 17) [query]select top 4 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 > '20130213' 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 BrandID='MARC JACOBS' order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093315
2
/home/labellusso/data/ProdMain.inc
458
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 17) [query]select top 4 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 > '20130213' 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 BrandID='MARC JACOBS' order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093321
2
/home/labellusso/data/ProdMain.inc
979
mssql_query() [function.mssql-query]: message: Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. (severity 17) [query]select top 50 p.PMInc,CustKind,CustID,ServiceID,VenID,p.ProdKind,p.ProdInc,MallKind,MallID,AWInc,SellerID,Brand,BrandID,BrandKor,Ccode1,Ccode2,Ccode3,Ccode4,Pname,ShortStory,Nation,Maker,Purl,Pimg=convert(text,Pimg),LogoImg,DeliveryFee,Lprice,Sprice,Lrprice,Srprice,Lbprice,Sbprice,Amount,AmountB,StockCntOptYes,StockCnt,StockCntB,MinCntB,Profit,StoryKor,FPMInc,ViewYes,ValidYes,DeleteYes,B2BYes,SetYes,Stock,ColorCnt,ClickCnt,SellCnt,Score,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 >= '20130213' 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) ) order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#
NoID
e0142e39e833fc8d10a67e9a574b72f6
20130220093321
2
/home/labellusso/data/ProdMain.inc
979
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 17) [query]select top 50 p.PMInc,CustKind,CustID,ServiceID,VenID,p.ProdKind,p.ProdInc,MallKind,MallID,AWInc,SellerID,Brand,BrandID,BrandKor,Ccode1,Ccode2,Ccode3,Ccode4,Pname,ShortStory,Nation,Maker,Purl,Pimg=convert(text,Pimg),LogoImg,DeliveryFee,Lprice,Sprice,Lrprice,Srprice,Lbprice,Sbprice,Amount,AmountB,StockCntOptYes,StockCnt,StockCntB,MinCntB,Profit,StoryKor,FPMInc,ViewYes,ValidYes,DeleteYes,B2BYes,SetYes,Stock,ColorCnt,ClickCnt,SellCnt,Score,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 >= '20130213' 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) ) order by pcc.ClickCntByLog desc ,ClickCnt desc,PMInc desc
#PansyErrorContents#