目前客服人员值日紧张,可以自助操作下,
后台——站长——数据——升级:
(
需要将 config/config_global.php 当中的 $_config[admincp][runquery] 设置修改为 1。)
CREATE TABLE IF NOT EXISTS `pre_xigua_pt_good` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`crts` int(11) NOT NULL,
`displayorder` int(11) NOT NULL,
`uid` int(11) NOT NULL,
`shid` varchar(1000) NOT NULL,
`title` varchar(200) NOT NULL,
`usetime` int(11) NOT NULL,
`shname` varchar(80) NOT NULL,
`hy` varchar(200) NOT NULL,
`hangye_id1` int(11) NOT NULL,
`hangye_id2` int(11) NOT NULL,
`stock` int(11) NOT NULL,
`sellnum` int(11) NOT NULL,
`fee_type` int(11) NOT NULL,
`tprice` decimal(10,2) NOT NULL,
`dprice` decimal(10,2) NOT NULL,
`disprice` decimal(10,2) NOT NULL,
`danci` int(11) NOT NULL,
`zong` int(11) NOT NULL,
`ptmin` int(11) NOT NULL,
`ptshixian` int(11) NOT NULL,
`upts` int(11) NOT NULL,
`jieshao` text NOT NULL,
`append_img` text NOT NULL,
`append_text` text NOT NULL,
`album` text NOT NULL,
`status` int(11) NOT NULL,
`stid` int(11) NOT NULL,
`srange` varchar(512) NOT NULL,
`jtt` varchar(2000) NOT NULL,
`spgg` text NOT NULL,
`stat` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `displayorder` (`displayorder`),
KEY `stat` (`stat`),
KEY `shid` (`shid`(255)),
KEY `uid` (`uid`),
KEY `title` (`title`),
KEY `hangye_id1` (`hangye_id1`),
KEY `hangye_id2` (`hangye_id2`),
KEY `status` (`status`)
) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS `pre_xigua_pt_good_price` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`gid` int(11) NOT NULL,
`name` varchar(200) NOT NULL,
`crts` int(11) NOT NULL,
`upts` int(11) NOT NULL,
`displayorder` int(11) NOT NULL,
`stock` int(11) NOT NULL,
`price_pt` decimal(10,2) NOT NULL,
`price_dm` decimal(10,2) NOT NULL,
`price_sc` decimal(10,2) NOT NULL,
`sellnum` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `gid_2` (`gid`,`name`),
KEY `displayorder` (`displayorder`),
KEY `gid` (`gid`)
) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS `pre_xigua_pt_hangye` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL,
`name` varchar(80) NOT NULL,
`icon` varchar(200) NOT NULL,
`adimage` varchar(200) NOT NULL,
`adlink` varchar(200) NOT NULL,
`ts` int(11) unsigned NOT NULL,
`o` int(11) unsigned NOT NULL,
`pushtype` varchar(20) NOT NULL DEFAULT '',
`price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
`tag` varchar(5000) NOT NULL,
`placehoder` varchar(800) NOT NULL,
`endtime` int(11) NOT NULL,
`cat_ids` varchar(500) NOT NULL,
`miao` int(11) NOT NULL DEFAULT '0',
`qiang` int(11) NOT NULL DEFAULT '0',
`goodindex` int(11) NOT NULL,
`telprice` decimal(10,2) NOT NULL,
`stids` varchar(2000) NOT NULL,
`aprice` decimal(10,2) NOT NULL,
PRIMARY KEY (`id`),
KEY `o` (`o`),
KEY `pid` (`pid`),
KEY `cat_ids` (`cat_ids`(255)),
KEY `goodindex` (`goodindex`),
KEY `miao` (`miao`),
KEY `stids` (`stids`(255))
) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS `pre_xigua_pt_index` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL,
`name` varchar(80) NOT NULL,
`icon` varchar(200) NOT NULL,
`adimage` varchar(200) NOT NULL,
`adlink` varchar(200) NOT NULL,
`ts` int(11) unsigned NOT NULL,
`o` int(11) unsigned NOT NULL,
`pushtype` varchar(20) NOT NULL DEFAULT '',
`price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
`tag` varchar(5000) NOT NULL,
`placehoder` varchar(800) NOT NULL,
`endtime` int(11) NOT NULL,
`cat_ids` varchar(500) NOT NULL,
`miao` int(11) NOT NULL DEFAULT '0',
`qiang` int(11) NOT NULL DEFAULT '0',
`goodindex` int(11) NOT NULL,
`telprice` decimal(10,2) NOT NULL,
`stids` varchar(2000) NOT NULL,
`aprice` decimal(10,2) NOT NULL,
PRIMARY KEY (`id`),
KEY `o` (`o`),
KEY `pid` (`pid`),
KEY `cat_ids` (`cat_ids`(255)),
KEY `goodindex` (`goodindex`),
KEY `miao` (`miao`),
KEY `stids` (`stids`(255))
) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS `pre_xigua_pt_order` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`crts` int(11) NOT NULL,
`uid` int(11) NOT NULL,
`order_id` varchar(200) NOT NULL,
`buy_type` int(11) NOT NULL,
`tuan_id` int(11) NOT NULL,
`gnum` int(11) NOT NULL,
`tuan_num` int(11) NOT NULL,
`pay_money` decimal(10,2) NOT NULL,
`addrid` int(11) NOT NULL,
`addr` varchar(500) NOT NULL,
`pay_ts` int(11) NOT NULL,
`fa_ts` int(11) NOT NULL DEFAULT '-1',
`shou_ts` int(11) DEFAULT '-1',
`tui_ts` int(11) NOT NULL,
`tuicfm_ts` int(11) NOT NULL,
`gid` int(11) NOT NULL,
`priceid` int(11) NOT NULL,
`priceinfo` varchar(2000) NOT NULL,
`goodinfo` text NOT NULL,
`note` varchar(500) NOT NULL,
`yunfee` decimal(10,2) NOT NULL,
`title` varchar(200) NOT NULL,
`pay_endts` int(11) NOT NULL,
`mobile` varchar(200) NOT NULL,
`realname` varchar(200) NOT NULL,
`status` int(11) NOT NULL,
`pt_success_ts` int(11) NOT NULL,
`cmtid` int(11) NOT NULL DEFAULT '-1',
`shid` int(11) NOT NULL,
`unit_price` decimal(10,2) NOT NULL,
`shixian` int(11) NOT NULL,
`yundan` varchar(200) NOT NULL,
`yundan_gs` varchar(200) NOT NULL,
`upts` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `tuan_id` (`tuan_id`),
KEY `order_id` (`order_id`),
KEY `pay_endts` (`pay_endts`),
KEY `cmtid` (`cmtid`),
KEY `shid` (`shid`),
KEY `buy_type` (`buy_type`),
KEY `crts` (`crts`),
KEY `pay_ts` (`pay_ts`),
KEY `fa_ts` (`fa_ts`),
KEY `shou_ts` (`shou_ts`),
KEY `gid` (`gid`),
KEY `status` (`status`),
KEY `shid_2` (`shid`)
) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS `pre_xigua_pt_yf` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`dist1` varchar(80) NOT NULL,
`dist2` varchar(80) NOT NULL,
`yunfei` decimal(10,2) NOT NULL,
`crts` int(11) NOT NULL,
`displayorder` int(11) NOT NULL,
`uid` int(11) NOT NULL,
`shids` varchar(1000) NOT NULL,
`stid` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `displayorder` (`displayorder`)
) ENGINE=InnoDB;
提交升级。
如果不行,使用更新包,覆盖后,上传更新:
下载地址(点击数字即可下载)→:
36488
如果还不行,下一个轮值客服站长在21:00左右上线,因为都是需要付费轮值的,所以暂时客服QQ不太稳定。