Error

File:cn/productview.html

Function Code:510

Method Code:11

事务(进程 ID 65)与另一个进程被死锁在锁资源上，并且已被选作死锁牺牲品。请重新运行该事务。
select count(*) from [shopitem] where goodsid='1200568' and status=1 and WeightValue is not null and Weight<>'' and Price is not null

数据库执行错误

class/product.xmlc

...<a href="{*last}" class="aa">末页</a>
</li><li>
<span class="ipaget" style="display:inline;">第{*page}页共{*pages}页共:{*total}个</span>
</li>
%};
@queryitem=$query(item,goods);
@goodsid=$get.number(goodsid);
@maxunit=0;
@unit=g;
@goods=$db.dataTable({% select goodscode,goodsid,brandid from shopgoods with(nolock) where status=1 and goodsid={@goodsid} ; %});
$if($or($iif(@goods==$null),$iif(@goods.count()==0))){
$write(您查看的产品已下架！);
$end();
}
@brandid=@goods[0][brandid];
@distj=;

@data=@queryitem.pager(@format,*,goodsid='{@goodsid}' and status=1 and WeightValue is not null and Weight<>'' and Price is not null ,{%Grade asc,weightvalue asc%},10,$get.number(page,1),10){
$if($session[UserID]<>$null){
@dis=;
}
$else{
@dis=display:none\;;
}
//此处限制PMS才能显示个别产品
$if($and($iif(@PMS==0),$iif($or($iif(@queryitem[Goodscode]==SYH00156),$iif(@queryitem[Goodscode]==SYH00155))),$iif(@queryitem[Weight]==1盒))){
$continue;
}
//合全没价格的不显示
$if($and($iif($or($iif(@UserID==1111111),$ii...