File:cn/search.html
Function Code:300
Method Code:6
事务(进程 ID 72)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。
insert into shopiprecord(status,ip) values(1,replace('3.144.235.141','.',''))
数据库执行错误
class/product.xmlc
...place('{@userIP}','.','') %});
$write(<div class="alert">Access permission denied! Please try again later.</div>);
$end;
}
$else{
//$write(继续1);
}
}
$elseif(@searchip[status]==0){
//检查有没有超过封印时间
$if($datetime.compare(@searchip[stoptime],$datetime.now())<0){
$db.transaction({%#&:update shopiprecord set status=1,stoptime=null where ip=replace('{@userIP}','.','') %});
}
$else{
$write(<div class="alert">Access permission denied! Please try again later.</div>);
$end;
}
}
}
$else{
$db.transaction({%#&:insert into shopiprecord(status,ip) values(1,replace('{@userIP}','.',''))%});
}
@sql={%#&:insert into searchHistory(searchText,ddate,act,userip,userid) values('{@keyword}',getdate(),'搜索','{@userIP}','{@UserID}')%};
$db.transaction(@sql);
////在此处判断输入内容是否是CAS,可优化查询速度
$if($regex.isMatch(@keyword,^\\d+\\-\\d{2}\\-\\d{1}$)==1){
@where={% Status=1 and CatalogID=0{=} and CAS='{@keyword}' and (yxUser<>1{=} or yxUser={@yxUser}{=}){@SelectSpecial} %};
}
//在此处判断输入内容是否是SY号,可优化...