新建供应商失败
<p>记录日期：2018-1-31
客户提问日期：2018-1-13
提问人：与狼共舞—贵阳吴家厅
问题：不能新建供应商</p>
<p>查到log日志如下：
<img src="https://www.showdoc.cc/home/common/visitfile/sign/9704400f6062de71c8f5ca82c1887d4e?showdoc=.jpg" alt="" />
<img src="https://www.showdoc.cc/home/common/visitfile/sign/6283619835512ac95d0604c19db14c12?showdoc=.jpg" alt="" /></p>
<pre><code> select companyid from s_shopid where shopid=''
2018-01-31 15:37:17 - DEBUG --&gt; 183.195.178.134 custdb_q_q select companyid from s_company where companyid=''
2018-01-31 15:37:17 - DEBUG --&gt; 183.195.178.134 custdb_q_q select shopid from s_shopid where shopid=''
2018-01-31 15:37:17 - DEBUG --&gt; 183.195.178.134 custdb_q_q select max(shopid) as shopid from s_shopid where shopid like 'H%'
2018-01-31 15:37:17 - DEBUG --&gt; 183.195.178.134 custdb_e_e insert into s_shopid(shopid,companyid,shopname,f_sangcmj,c_jiajlx,manager,addr,tele,fax,tele2,tele3,postcode,notes,c_yingyzz,c_lianxr,c_fuzr,c_yinghzh1,c_yinghzh2,c_yinghzh3,n_leix,c_suiwdjzh1,c_suiwdjzh2,c_xinyjbbh,c_mobilephoto,c_msnhm,c_rtxhm,c_email,c_qqhm,notes2,notes3,c_hez,c_shangc,b_using,f_baozj,c_hethm,d_qianyrq,d_kaiyrq,c_dengj,c_jiesfsbh,c_rtxmm,b_dayzk,b_peihck,item4,n_diqbh,ratio,item3,item1,item2,c_id,c_upid,d_upid,shopqym) values('H0001','CY001','测试2',0,'','','','','','','','','','','','','','','',8,'','','','','','','','','','','','','1',0,'',null,null,'','','','0','0','',0,0,'','','','系统管理员','系统管理员','2018-01-31 15:30:47','test');
</code></pre>
<p>解决办法
<img src="https://www.showdoc.cc/home/common/visitfile/sign/e6de04365ad85341ecaf5a532c14bb99?showdoc=.jpg" alt="" />
这里最大的的shopid为 HMH0002
select max(shopid) as shopid from s_shopid where shopid like 'H%'</p>
<p>修改线上hongmei.upyuan.cn/upyuan/zgs80/shop.php代码array("type"=>'SU',"prefix"=>'H'), 把这里的 H 换成W
<img src="https://www.showdoc.cc/home/common/visitfile/sign/7f8e814cd89d23b28227ae0943da7b4f?showdoc=.jpg" alt="" /></p>