NoID
d3bb05f846545254294166a846906df9
20131230172606
2
/home/labellusso/lib/myFuncMS.inc
424
mssql_query() [function.mssql-query]: message: Incorrect syntax near '301'. (severity 15) [query]
#PansyErrorContents#
NoID
d3bb05f846545254294166a846906df9
20131230172606
2
/home/labellusso/lib/myFuncMS.inc
424
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 15) [query]
#PansyErrorContents#
NoID
d3bb05f846545254294166a846906df9
20131230172606
2
/home/labellusso/lib/myFuncMS.inc
424
mssql_query() [function.mssql-query]: Query failed [query]
#PansyErrorContents#
NoID
d3bb05f846545254294166a846906df9
20131230172606
2
/home/labellusso/lib/myFuncMS.inc
425
mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [query]
#PansyErrorContents#
NoID
d3bb05f846545254294166a846906df9
20131230172606
2
/home/labellusso/data/ProdMain.inc
496
mssql_query() [function.mssql-query]: message: Incorrect syntax near '301'. (severity 15) [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 0 PMInc from psProdMain where DeleteYes=0 and Srprice <= 32139029 301 and ( ( 1=1 and replace(Pname,' ','') like '%32139029%' and replace(Pname,' ','') like '%301%' ) or ( replace(SearchKey,' ','') like '%32139029301%' ) or ( replace(BrandID,' ','') like '%32139029301%' or replace(BrandKor,' ','') like '%32139029301%' ) or ProdKind+convert(varchar,ProdInc)='32139029 301' or convert(varchar,ProdInc)='32139029 301' ) 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 Srprice <= 32139029 301 and ( ( 1=1 and replace(Pname,' ','') like '%32139029%' and replace(Pname,' ','') like '%301%' ) or ( replace(SearchKey,' ','') like '%32139029301%' ) or ( replace(BrandID,' ','') like '%32139029301%' or replace(BrandKor,' ','') like '%32139029301%' ) or ProdKind+convert(varchar,ProdInc)='32139029 301' or convert(varchar,ProdInc)='32139029 301' ) 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
d3bb05f846545254294166a846906df9
20131230172606
2
/home/labellusso/data/ProdMain.inc
496
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 15) [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 0 PMInc from psProdMain where DeleteYes=0 and Srprice <= 32139029 301 and ( ( 1=1 and replace(Pname,' ','') like '%32139029%' and replace(Pname,' ','') like '%301%' ) or ( replace(SearchKey,' ','') like '%32139029301%' ) or ( replace(BrandID,' ','') like '%32139029301%' or replace(BrandKor,' ','') like '%32139029301%' ) or ProdKind+convert(varchar,ProdInc)='32139029 301' or convert(varchar,ProdInc)='32139029 301' ) 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 Srprice <= 32139029 301 and ( ( 1=1 and replace(Pname,' ','') like '%32139029%' and replace(Pname,' ','') like '%301%' ) or ( replace(SearchKey,' ','') like '%32139029301%' ) or ( replace(BrandID,' ','') like '%32139029301%' or replace(BrandKor,' ','') like '%32139029301%' ) or ProdKind+convert(varchar,ProdInc)='32139029 301' or convert(varchar,ProdInc)='32139029 301' ) 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
d3bb05f846545254294166a846906df9
20131230172606
2
/home/labellusso/data/ProdMain.inc
496
mssql_query() [function.mssql-query]: Query failed [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 0 PMInc from psProdMain where DeleteYes=0 and Srprice <= 32139029 301 and ( ( 1=1 and replace(Pname,' ','') like '%32139029%' and replace(Pname,' ','') like '%301%' ) or ( replace(SearchKey,' ','') like '%32139029301%' ) or ( replace(BrandID,' ','') like '%32139029301%' or replace(BrandKor,' ','') like '%32139029301%' ) or ProdKind+convert(varchar,ProdInc)='32139029 301' or convert(varchar,ProdInc)='32139029 301' ) 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 Srprice <= 32139029 301 and ( ( 1=1 and replace(Pname,' ','') like '%32139029%' and replace(Pname,' ','') like '%301%' ) or ( replace(SearchKey,' ','') like '%32139029301%' ) or ( replace(BrandID,' ','') like '%32139029301%' or replace(BrandKor,' ','') like '%32139029301%' ) or ProdKind+convert(varchar,ProdInc)='32139029 301' or convert(varchar,ProdInc)='32139029 301' ) 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
d3bb05f846545254294166a846906df9
20131230172606
2
/home/labellusso/data/ProdMain.inc
537
mssql_num_rows(): supplied argument is not a valid MS SQL-result resource [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 0 PMInc from psProdMain where DeleteYes=0 and Srprice <= 32139029 301 and ( ( 1=1 and replace(Pname,' ','') like '%32139029%' and replace(Pname,' ','') like '%301%' ) or ( replace(SearchKey,' ','') like '%32139029301%' ) or ( replace(BrandID,' ','') like '%32139029301%' or replace(BrandKor,' ','') like '%32139029301%' ) or ProdKind+convert(varchar,ProdInc)='32139029 301' or convert(varchar,ProdInc)='32139029 301' ) 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 Srprice <= 32139029 301 and ( ( 1=1 and replace(Pname,' ','') like '%32139029%' and replace(Pname,' ','') like '%301%' ) or ( replace(SearchKey,' ','') like '%32139029301%' ) or ( replace(BrandID,' ','') like '%32139029301%' or replace(BrandKor,' ','') like '%32139029301%' ) or ProdKind+convert(varchar,ProdInc)='32139029 301' or convert(varchar,ProdInc)='32139029 301' ) 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
d3bb05f846545254294166a846906df9
20131230172606
2
/home/labellusso/data/ProdMain.inc
538
mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [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 0 PMInc from psProdMain where DeleteYes=0 and Srprice <= 32139029 301 and ( ( 1=1 and replace(Pname,' ','') like '%32139029%' and replace(Pname,' ','') like '%301%' ) or ( replace(SearchKey,' ','') like '%32139029301%' ) or ( replace(BrandID,' ','') like '%32139029301%' or replace(BrandKor,' ','') like '%32139029301%' ) or ProdKind+convert(varchar,ProdInc)='32139029 301' or convert(varchar,ProdInc)='32139029 301' ) 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 Srprice <= 32139029 301 and ( ( 1=1 and replace(Pname,' ','') like '%32139029%' and replace(Pname,' ','') like '%301%' ) or ( replace(SearchKey,' ','') like '%32139029301%' ) or ( replace(BrandID,' ','') like '%32139029301%' or replace(BrandKor,' ','') like '%32139029301%' ) or ProdKind+convert(varchar,ProdInc)='32139029 301' or convert(varchar,ProdInc)='32139029 301' ) 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
d3bb05f846545254294166a846906df9
20131230172606
2
/home/labellusso/data/ProdMain.inc
496
mssql_query() [function.mssql-query]: message: Incorrect syntax near '301'. (severity 15) [query]
select
count(1) as count , Ccode1
from
psProdMain
where
DeleteYes=0 and Srprice <= 32139029 301 and ( ( 1=1 and replace(Pname,' ','') like '%32139029%' and replace(Pname,' ','') like '%301%' ) or ( replace(SearchKey,' ','') like '%32139029301%' ) or ( replace(BrandID,' ','') like '%32139029301%' or replace(BrandKor,' ','') like '%32139029301%' ) or ProdKind+convert(varchar,ProdInc)='32139029 301' or convert(varchar,ProdInc)='32139029 301' ) 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
group by
Ccode1
#PansyErrorContents#
NoID
d3bb05f846545254294166a846906df9
20131230172606
2
/home/labellusso/data/ProdMain.inc
496
mssql_query() [function.mssql-query]: General SQL Server error: Check messages from the SQL Server (severity 15) [query]
select
count(1) as count , Ccode1
from
psProdMain
where
DeleteYes=0 and Srprice <= 32139029 301 and ( ( 1=1 and replace(Pname,' ','') like '%32139029%' and replace(Pname,' ','') like '%301%' ) or ( replace(SearchKey,' ','') like '%32139029301%' ) or ( replace(BrandID,' ','') like '%32139029301%' or replace(BrandKor,' ','') like '%32139029301%' ) or ProdKind+convert(varchar,ProdInc)='32139029 301' or convert(varchar,ProdInc)='32139029 301' ) 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
group by
Ccode1
#PansyErrorContents#
NoID
d3bb05f846545254294166a846906df9
20131230172606
2
/home/labellusso/data/ProdMain.inc
496
mssql_query() [function.mssql-query]: Query failed [query]
select
count(1) as count , Ccode1
from
psProdMain
where
DeleteYes=0 and Srprice <= 32139029 301 and ( ( 1=1 and replace(Pname,' ','') like '%32139029%' and replace(Pname,' ','') like '%301%' ) or ( replace(SearchKey,' ','') like '%32139029301%' ) or ( replace(BrandID,' ','') like '%32139029301%' or replace(BrandKor,' ','') like '%32139029301%' ) or ProdKind+convert(varchar,ProdInc)='32139029 301' or convert(varchar,ProdInc)='32139029 301' ) 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
group by
Ccode1
#PansyErrorContents#
NoID
d3bb05f846545254294166a846906df9
20131230172606
2
/home/labellusso/data/ProdMain.inc
537
mssql_num_rows(): supplied argument is not a valid MS SQL-result resource [query]
select
count(1) as count , Ccode1
from
psProdMain
where
DeleteYes=0 and Srprice <= 32139029 301 and ( ( 1=1 and replace(Pname,' ','') like '%32139029%' and replace(Pname,' ','') like '%301%' ) or ( replace(SearchKey,' ','') like '%32139029301%' ) or ( replace(BrandID,' ','') like '%32139029301%' or replace(BrandKor,' ','') like '%32139029301%' ) or ProdKind+convert(varchar,ProdInc)='32139029 301' or convert(varchar,ProdInc)='32139029 301' ) 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
group by
Ccode1
#PansyErrorContents#
NoID
d3bb05f846545254294166a846906df9
20131230172606
2
/home/labellusso/data/ProdMain.inc
538
mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource [query]
select
count(1) as count , Ccode1
from
psProdMain
where
DeleteYes=0 and Srprice <= 32139029 301 and ( ( 1=1 and replace(Pname,' ','') like '%32139029%' and replace(Pname,' ','') like '%301%' ) or ( replace(SearchKey,' ','') like '%32139029301%' ) or ( replace(BrandID,' ','') like '%32139029301%' or replace(BrandKor,' ','') like '%32139029301%' ) or ProdKind+convert(varchar,ProdInc)='32139029 301' or convert(varchar,ProdInc)='32139029 301' ) 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
group by
Ccode1
#PansyErrorContents#