进到会员中心点资金管理就出现问题！求救！

2016-07-07 15:20 来源：www.chinab4c.com 作者：ecshop专家

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT SUM(user_money) FROM `liwenbin`.`ecs_account_log` WHERE user_id = '2' ) [2] => Array ( [error] => Table 'liwenbin.ecs_account_log' doesn't exist ) [3] => Array ( [errno] => 1146 ) )

总是出现这些文字怎么办？

回答：
CREATE TABLE IF NOT EXISTS `ecs_account_log` (
`log_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`user_id` mediumint(8) unsigned NOT NULL,
`user_money` decimal(10,2) NOT NULL,
`frozen_money` decimal(10,2) NOT NULL,
`rank_points` mediumint(9) NOT NULL,
`pay_points` mediumint(9) NOT NULL,
`change_time` int(10) unsigned NOT NULL,
`change_desc` varchar(255) NOT NULL,
`change_type` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`log_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
到后台sql执行下

2# myareaway



您好，我怎么在ECSHOP后台找不到SQL呀，怎么执行上面的代码呀，，，，请告知下，谢谢了啊

如何解決呢? 我也有同樣的問題