NoID
a4eef95e574f12235c5a6b07dc1984a5
20130220092652
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
a4eef95e574f12235c5a6b07dc1984a5
20130220092652
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
a4eef95e574f12235c5a6b07dc1984a5
20130220092725
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
a4eef95e574f12235c5a6b07dc1984a5
20130220092725
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
a4eef95e574f12235c5a6b07dc1984a5
20130220092948
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 5
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,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,OptColorTxt,VideoYes,TypeCode,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,
PnameCompare= case Pname when '[付农力捞倪胶/扼骇风筋/教臂]C3123017 80992/3110114' then 1 else 0 end,
PnameCompare2= case Charindex( '[付农力捞倪胶/扼骇风筋/教臂]C3123017 80992/3110114', Pname) when 0 then 1000 else Charindex( '[付农力捞倪胶/扼骇风筋/教臂]C3123017 80992/3110114', Pname) end
from
psProdMain
where
DeleteYes=0
and Ccode1='14'
and Ccode2='3'
and Ccode3='1'
and Ccode4='0'
and BrandID='MARC JACOBS'
and PMInc <> 20466
and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) )
order by
PnameCompare desc ,
PnameCompare2 asc ,
newid()
#PansyErrorContents#
NoID
a4eef95e574f12235c5a6b07dc1984a5
20130220092948
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 5
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,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,OptColorTxt,VideoYes,TypeCode,StockDate,StockDate8,StockOper,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,
PnameCompare= case Pname when '[付农力捞倪胶/扼骇风筋/教臂]C3123017 80992/3110114' then 1 else 0 end,
PnameCompare2= case Charindex( '[付农力捞倪胶/扼骇风筋/教臂]C3123017 80992/3110114', Pname) when 0 then 1000 else Charindex( '[付农力捞倪胶/扼骇风筋/教臂]C3123017 80992/3110114', Pname) end
from
psProdMain
where
DeleteYes=0
and Ccode1='14'
and Ccode2='3'
and Ccode3='1'
and Ccode4='0'
and BrandID='MARC JACOBS'
and PMInc <> 20466
and ViewYes=1 and Srprice > 0 and Stock=1 and (ProdKind<>'PROD' or (ProdKind='PROD' and Sprice > 0) )
order by
PnameCompare desc ,
PnameCompare2 asc ,
newid()
#PansyErrorContents#
NoID
a4eef95e574f12235c5a6b07dc1984a5
20130220093024
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
a4eef95e574f12235c5a6b07dc1984a5
20130220093024
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
a4eef95e574f12235c5a6b07dc1984a5
20130220093051
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
a4eef95e574f12235c5a6b07dc1984a5
20130220093051
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
a4eef95e574f12235c5a6b07dc1984a5
20130220093121
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
a4eef95e574f12235c5a6b07dc1984a5
20130220093121
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
a4eef95e574f12235c5a6b07dc1984a5
20130220093122
2
/home/labellusso/lib/MagicView_func.inc
693
fsockopen() [function.fsockopen]: unable to connect to 1:80 (Invalid argument) [query]
#PansyErrorContents#
NoID
a4eef95e574f12235c5a6b07dc1984a5
20130220093218
2
/home/labellusso/data/QnAProd.inc
345
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
QPInc,CustKind,CustID,ServiceID,VenID,MemID,Kname,MallID,ProdKind,ProdInc,Ccode1,Ccode2,Ccode3,Ccode4,BrandID,Pname,Pimg=convert(text,Pimg),Lrprice,Srprice,Qkind,Title,Question=convert(text,Question),Answer=convert(text,Answer),ClickCnt,SMSYes,SecretYes,Stock,AnswerYes,AnswerDate,AnswerDate8,File1,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper
from
psQnAProd
where
QPInc not in (select top 0 QPInc from psQnAProd where DeleteYes=0 and ProdKind='MAN' and ProdInc='3420' order by QPInc Desc )
and DeleteYes=0
and ProdKind='MAN' and ProdInc='3420'
order by
QPInc Desc
#PansyErrorContents#
NoID
a4eef95e574f12235c5a6b07dc1984a5
20130220093218
2
/home/labellusso/data/QnAProd.inc
345
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 17) [query]
select top 10
QPInc,CustKind,CustID,ServiceID,VenID,MemID,Kname,MallID,ProdKind,ProdInc,Ccode1,Ccode2,Ccode3,Ccode4,BrandID,Pname,Pimg=convert(text,Pimg),Lrprice,Srprice,Qkind,Title,Question=convert(text,Question),Answer=convert(text,Answer),ClickCnt,SMSYes,SecretYes,Stock,AnswerYes,AnswerDate,AnswerDate8,File1,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper
from
psQnAProd
where
QPInc not in (select top 0 QPInc from psQnAProd where DeleteYes=0 and ProdKind='MAN' and ProdInc='3420' order by QPInc Desc )
and DeleteYes=0
and ProdKind='MAN' and ProdInc='3420'
order by
QPInc Desc
#PansyErrorContents#
NoID
a4eef95e574f12235c5a6b07dc1984a5
20130220093244
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
a4eef95e574f12235c5a6b07dc1984a5
20130220093244
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#