前台付款方式选择会员付款后,按埋脚报错 如下图所示:
经分析原因: 是由于会员模块缺少会员扣款规则
解决方法:在查询分析器执行下面脚本:
declare @ShopID intselect @ShopID=FShopID from PSM_Coms where FShopLocal=1if not exists(select 1 from Sys_TableMaxID where serial_id=101054)Insert Into Sys_TableMaxID(serial_id,tablename,fieldname,prefix,isdate,maxid,suffix,fieldtype,fieldlen,fielddesc,FShopID ) Values( 101054,'CRM_PayRule','FRuleID','','0',1,'','2', 5,'',lTrim(Str(@ShopID)))if not exists(select 1 from Sys_logType where LogType=101054)Insert Into Sys_logtype(LogType,TypeName,NID_TypeName,Note,SysTag ) Values( 101054,'会员消费扣款规则', 11195,'会员消费扣款规则', 101)if not exists(select 1 from CRM_PayRule where FShopID=@ShopID)Insert Into CRM_PayRule(FRuleID,FShopID,FPayRule,FModifier,FModifyDate,FNote,FSwitchFlag,FIsRevoked ) Values( @ShopID*10+1,@ShopID, 1, 0,GetDate(),'', 0, 0)Go