2核1G3M服务器88一季度

腾讯云,阿里云百度云等 折扣价→点我←

升级到微赞WZ_V75.0商业会员版添加卡券'ims_coupon_store' doesn't exist解决办法 微擎

游客1 游客组

升级到微赞WZ_V75.0商业会员版'ims_coupon_store' doesn't exist:
SQL:
SELECT * FROM `ims_coupon_store` WHERE `uniacid` = :__uniacid AND `couponid` = :__couponid

Params:
array ( ':__uniacid' => 2, ':__couponid' => '1', )
SQL Error:
Table 'we7.ims_coupon_store' doesn't exist
Traces:
file: /framework/class/db.class.php; line: 158;
file: /framework/class/db.class.php; line: 230;
file: /framework/function/pdo.func.php; line: 53;
file: /framework/model/activity.mod.php; line: 180;
file: /source/activity/exchange.ctrl.php; line: 82;
file: /index.php; line: 248;


报错如图所示:


解决办法:

phpmyadmin在微赞/微擎数据库执行SQL语句如下:

CREATE TABLE IF NOT EXISTS `ims_coupon_store` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(10) unsigned NOT NULL,
`business_name` varchar(50) NOT NULL,
`branch_name` varchar(50) NOT NULL,
`category` varchar(255) NOT NULL,
`province` varchar(15) NOT NULL,
`city` varchar(15) NOT NULL,
`district` varchar(15) NOT NULL,
`address` varchar(50) NOT NULL,
`longitude` varchar(15) NOT NULL,
`latitude` varchar(15) NOT NULL,
`telephone` varchar(20) NOT NULL,
`photo_list` varchar(10000) NOT NULL,
`avg_price` int(10) unsigned NOT NULL,
`opentime` varchar(50) NOT NULL,
`recommend` varchar(255) NOT NULL,
`special` varchar(255) NOT NULL,
`introduction` varchar(255) NOT NULL,
`open_time` varchar(50) NOT NULL,
`sid` int(10) unsigned NOT NULL,
`location_id` int(10) unsigned NOT NULL,
`status` tinyint(3) unsigned NOT NULL,
`offset_type` tinyint(3) unsigned NOT NULL,
`type` tinyint(3) unsigned NOT NULL,
`message` varchar(500) NOT NULL,
`couponid` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `uniacid` (`uniacid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;



站长窝论坛版权声明 1、本帖标题:升级到微赞WZ_V75.0商业会员版添加卡券'ims_coupon_store' doesn't exist解决办法
2、论坛网址:站长窝论坛
3、站长窝论坛的资源部分来源于网络,如有侵权,请联系站长进行删除处理。
4、会员发帖仅代表会员个人观点,并不代表本站赞同其观点和对其真实性负责。
5、站长窝论坛一律禁止以任何方式发布或转载任何违法的相关信息,访客发现请向站长举报
6、本帖由游客1在站长窝论坛《程序综合区》版块原创发布, 转载请注明出处!
评论
最新回复 (65)
返回
发新帖