NoID
f125485c1e81f38937e68f79b06c8f0a
20130220093005
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='4110' order by QPInc Desc )
and DeleteYes=0
and ProdKind='MAN' and ProdInc='4110'
order by
QPInc Desc
#PansyErrorContents#
NoID
f125485c1e81f38937e68f79b06c8f0a
20130220093005
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='4110' order by QPInc Desc )
and DeleteYes=0
and ProdKind='MAN' and ProdInc='4110'
order by
QPInc Desc
#PansyErrorContents#
NoID
f125485c1e81f38937e68f79b06c8f0a
20130220093038
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 '[Æä¶ó°¡¸ð/¶óº§·ç½î/¿©¼º±¸µÎ]VARA 3CM NERO/2120618' then 1 else 0 end,
PnameCompare2= case Charindex( '[Æä¶ó°¡¸ð/¶óº§·ç½î/¿©¼º±¸µÎ]VARA 3CM NERO/2120618', Pname) when 0 then 1000 else Charindex( '[Æä¶ó°¡¸ð/¶óº§·ç½î/¿©¼º±¸µÎ]VARA 3CM NERO/2120618', Pname) end
from
psProdMain
where
DeleteYes=0
and Ccode1='14'
and Ccode2='15'
and Ccode3='2'
and Ccode4='2'
and BrandID='Ferragamo'
and PMInc <> 8477
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
f125485c1e81f38937e68f79b06c8f0a
20130220093038
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 '[Æä¶ó°¡¸ð/¶óº§·ç½î/¿©¼º±¸µÎ]VARA 3CM NERO/2120618' then 1 else 0 end,
PnameCompare2= case Charindex( '[Æä¶ó°¡¸ð/¶óº§·ç½î/¿©¼º±¸µÎ]VARA 3CM NERO/2120618', Pname) when 0 then 1000 else Charindex( '[Æä¶ó°¡¸ð/¶óº§·ç½î/¿©¼º±¸µÎ]VARA 3CM NERO/2120618', Pname) end
from
psProdMain
where
DeleteYes=0
and Ccode1='14'
and Ccode2='15'
and Ccode3='2'
and Ccode4='2'
and BrandID='Ferragamo'
and PMInc <> 8477
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
f125485c1e81f38937e68f79b06c8f0a
20130220093038
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='1959' order by QPInc Desc )
and DeleteYes=0
and ProdKind='MAN' and ProdInc='1959'
order by
QPInc Desc
#PansyErrorContents#
NoID
f125485c1e81f38937e68f79b06c8f0a
20130220093038
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='1959' order by QPInc Desc )
and DeleteYes=0
and ProdKind='MAN' and ProdInc='1959'
order by
QPInc Desc
#PansyErrorContents#