赵勋

微信机器人提示数据库错误

赵勋 - 6月24号

[Table 'wp_weixin_messages' doesn't exist]
SELECT Event as label, count(*) as count FROM `wp_weixin_messages` WHERE `appid` = 'wxc61234567890a2ca' AND `CreateTime` > 1592928000 AND `CreateTime` < 1592929570 AND `MsgType` = 'event' AND `Event` IN ('subscribe','unsubscribe') GROUP BY `Event` ORDER BY `count` DESC 可能是权限不足?有没有手动创建表的SQL? 谢谢!

1条回复

赵勋
赵勋 - 6月24号

手动创建了全部表,但是提示:Unknown column 'appid' in 'where clause']

我要回复

暂时不支持网页回复,请安装 WPJAM-Basic 插件,然后在 WordPress 后台即可参与讨论。