解决最新discuz内置的实名认证接口运营里面短信服务列表报错缺失pre_common_smsgw表
解决最新discuz内置的实名认证接口运营里面短信服务列表报错缺失pre_common_smsgw表的解决办法:如图所示:
解决办法:
后台——站长——数据库——升级:
(需要将 config/config_global.php 当中的 $_config['admincp']['runquery'] 设置修改为 1。)CREATE TABLE pre_common_smsgw (
`smsgwid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`available` tinyint(1) NOT NULL DEFAULT '0',
`type` int(10) NOT NULL DEFAULT '0',
`order` int(10) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`class` varchar(255) NOT NULL DEFAULT '0',
`sendrule` text NOT NULL DEFAULT '',
`parameters` text NOT NULL DEFAULT '',
PRIMARY KEY (smsgwid)
) ENGINE=InnoDB;
CREATE TABLE pre_common_smslog (
`smslogid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL,
`type` int(10) NOT NULL DEFAULT '0',
`smsgw` int(10) NOT NULL DEFAULT '0',
`status` int(10) NOT NULL DEFAULT '0',
`verify` int(10) NOT NULL DEFAULT '0',
`secmobicc` varchar(3) NOT NULL DEFAULT '',
`secmobile` varchar(12) NOT NULL DEFAULT '',
`sendtime` int(10) unsigned NOT NULL DEFAULT '0',
`content` text NOT NULL DEFAULT '',
PRIMARY KEY (smslogid),
KEY lastsent (secmobicc,secmobile,sendtime)
) ENGINE=InnoDB;
INSERT INTO pre_common_setting VALUES ('smsstatus','0');
INSERT INTO pre_common_setting VALUES ('smsdefaultcc','86');
INSERT INTO pre_common_setting VALUES ('smstimelimit','86400');
INSERT INTO pre_common_setting VALUES ('smsnumlimit','5');
INSERT INTO pre_common_setting VALUES ('smsinterval','300');
INSERT INTO pre_common_setting VALUES ('smsmillimit','20');
INSERT INTO pre_common_setting VALUES ('smsglblimit','1000');
短信服务图示:
页:
[1]