开启“网页分享”功能后，网站无法访问“此站点有致命错误”
问题1：微信公众号机器人开启“网页分享”功能后，网站无法访问“此站点有致命错误”，关掉网页分享功能，就正常了。请问大佬怎么回事？
问题2： wpjam basic后台报错“公众号秘钥错误，请到公众号后台获取重新输入”，但basic和公众号机器人两个插件，都可以正常使用。
4条回复
Denis | 邓鸿华 - 2 年前
参考置顶帖，提供 log
天津孙立 - 2 年前
[code]
[07-Nov-2021 16:05:16 UTC] WordPress数据库查询SELECT Event as label, count(*) as count FROM `wp_weixin_messages` WHERE `appid` = \'wxcf526b71b2b32b8e\' AND `CreateTime` > 1636300800 AND `CreateTime` < 1636301116 AND `MsgType` = \'event\' AND `Event` IN (\'subscribe\',\'unsubscribe\') GROUP BY `Event` ORDER BY `count` DESC 时发生Unknown column \'appid\' in \'where clause\'错误，这是由do_action(\'toplevel_page_weixin\'), WP_Hook->do_action, WP_Hook->apply_filters, WPJAM_Menu_Page::admin_page, WPJAM_Menu_Page::plugin_page, WPJAM_Dashboard_Setting->page, wp_dashboard, do_meta_boxes, WEIXIN_Stats::overview_widget, WEIXIN_Stats::get_user_subscribe_counts, WPJAM_DB->get_results查询的
[07-Nov-2021 16:05:16 UTC] WordPress数据库查询SELECT Event as label, count(*) as count FROM `wp_weixin_messages` WHERE `appid` = \'wxcf526b71b2b32b8e\' AND `CreateTime` > 1636214400 AND `CreateTime` < 1636300799 AND `MsgType` = \'event\' AND `Event` IN (\'subscribe\',\'unsubscribe\') GROUP BY `Event` ORDER BY `count` DESC 时发生Unknown column \'appid\' in \'where clause\'错误，这是由do_action(\'toplevel_page_weixin\'), WP_Hook->do_action, WP_Hook->apply_filters, WPJAM_Menu_Page::admin_page, WPJAM_Menu_Page::plugin_page, WPJAM_Dashboard_Setting->page, wp_dashboard, do_meta_boxes, WEIXIN_Stats::overview_widget, WEIXIN_Stats::get_user_subscribe_counts, WPJAM_DB->get_results查询的
[07-Nov-2021 16:05:16 UTC] WordPress数据库查询SELECT Event as label, count(*) as count FROM `wp_weixin_messages` WHERE `appid` = \'wxcf526b71b2b32b8e\' AND `CreateTime` > 1636214400 AND `CreateTime` < 1636214716 AND `MsgType` = \'event\' AND `Event` IN (\'subscribe\',\'unsubscribe\') GROUP BY `Event` ORDER BY `count` DESC 时发生Unknown column \'appid\' in \'where clause\'错误，这是由do_action(\'toplevel_page_weixin\'), WP_Hook->do_action, WP_Hook->apply_filters, WPJAM_Menu_Page::admin_page, WPJAM_Menu_Page::plugin_page, WPJAM_Dashboard_Setting->page, wp_dashboard, do_meta_boxes, WEIXIN_Stats::overview_widget, WEIXIN_Stats::get_user_subscribe_counts, WPJAM_DB->get_results查询的
[07-Nov-2021 16:05:16 UTC] WordPress数据库查询SELECT count(id) as total FROM `wp_weixin_messages` WHERE `appid` = \'wxcf526b71b2b32b8e\' AND `CreateTime` > 1636300800 AND `CreateTime` < 1636301116 ORDER BY `id` DESC 时发生Unknown column \'appid\' in \'where clause\'错误，这是由do_action(\'toplevel_page_weixin\'), WP_Hook->do_action, WP_Hook->apply_filters, WPJAM_Menu_Page::admin_page, WPJAM_Menu_Page::plugin_page, WPJAM_Dashboard_Setting->page, wp_dashboard, do_meta_boxes, WEIXIN_Stats::overview_widget, WEIXIN_Stats::get_message_counts, WPJAM_DB->get_var查询的
[07-Nov-2021 16:05:16 UTC] WordPress数据库查询SELECT count(DISTINCT FromUserName) as people FROM `wp_weixin_messages` WHERE `appid` = \'wxcf526b71b2b32b8e\' AND `CreateTime` > 1636300800 AND `CreateTime` < 1636301116 ORDER BY `id` DESC 时发生Unknown column \'appid\' in \'where clause\'错误，这是由do_action(\'toplevel_page_weixin\'), WP_Hook->do_action, WP_Hook->apply_filters, WPJAM_Menu_Page::admin_page, WPJAM_Menu_Page::plugin_page, WPJAM_Dashboard_Setting->page, wp_dashboard, do_meta_boxes, WEIXIN_Stats::overview_widget, WEIXIN_Stats::get_message_counts, WPJAM_DB->get_var查询的
[07-Nov-2021 16:05:16 UTC] WordPress数据库查询SELECT count(id) as total FROM `wp_weixin_messages` WHERE `appid` = \'wxcf526b71b2b32b8e\' AND `CreateTime` > 1636214400 AND `CreateTime` < 1636300799 ORDER BY `id` DESC 时发生Unknown column \'appid\' in \'where clause\'错误，这是由do_action(\'toplevel_page_weixin\'), WP_Hook->do_action, WP_Hook->apply_filters, WPJAM_Menu_Page::admin_page, WPJAM_Menu_Page::plugin_page, WPJAM_Dashboard_Setting->page, wp_dashboard, do_meta_boxes, WEIXIN_Stats::overview_widget, WEIXIN_Stats::get_message_counts, WPJAM_DB->get_var查询的
[07-Nov-2021 16:05:16 UTC] WordPress数据库查询SELECT count(DISTINCT FromUserName) as people FROM `wp_weixin_messages` WHERE `appid` = \'wxcf526b71b2b32b8e\' AND `CreateTime` > 1636214400 AND `CreateTime` < 1636300799 ORDER BY `id` DESC 时发生Unknown column \'appid\' in \'where clause\'错误，这是由do_action(\'toplevel_page_weixin\'), WP_Hook->do_action, WP_Hook->apply_filters, WPJAM_Menu_Page::admin_page, WPJAM_Menu_Page::plugin_page, WPJAM_Dashboard_Setting->page, wp_dashboard, do_meta_boxes, WEIXIN_Stats::overview_widget, WEIXIN_Stats::get_message_counts, WPJAM_DB->get_var查询的
[07-Nov-2021 16:05:16 UTC] WordPress数据库查询SELECT count(id) as total FROM `wp_weixin_messages` WHERE `appid` = \'wxcf526b71b2b32b8e\' AND `CreateTime` > 1636214400 AND `CreateTime` < 1636214716 ORDER BY `id` DESC 时发生Unknown column \'appid\' in \'where clause\'错误，这是由do_action(\'toplevel_page_weixin\'), WP_Hook->do_action, WP_Hook->apply_filters, WPJAM_Menu_Page::admin_page, WPJAM_Menu_Page::plugin_page, WPJAM_Dashboard_Setting->page, wp_dashboard, do_meta_boxes, WEIXIN_Stats::overview_widget, WEIXIN_Stats::get_message_counts, WPJAM_DB->get_var查询的
[07-Nov-2021 16:05:16 UTC] WordPress数据库查询SELECT count(DISTINCT FromUserName) as people FROM `wp_weixin_messages` WHERE `appid` = \'wxcf526b71b2b32b8e\' AND `CreateTime` > 1636214400 AND `CreateTime` < 1636214716 ORDER BY `id` DESC 时发生Unknown column \'appid\' in \'where clause\'错误，这是由do_action(\'toplevel_page_weixin\'), WP_Hook->do_action, WP_Hook->apply_filters, WPJAM_Menu_Page::admin_page, WPJAM_Menu_Page::plugin_page, WPJAM_Dashboard_Setting->page, wp_dashboard, do_meta_boxes, WEIXIN_Stats::overview_widget, WEIXIN_Stats::get_message_counts, WPJAM_DB->get_var查询的
[07-Nov-2021 16:05:16 UTC] WordPress数据库查询SELECT COUNT( * ) AS count, Response, MsgType, LOWER(Content) as Content FROM `wp_weixin_messages` WHERE `appid` = \'wxcf526b71b2b32b8e\' AND `CreateTime` > 1636214716 AND `CreateTime` < 1636301116 AND `MsgType` = \'text\' AND `Content` != \'\' GROUP BY Content, Response ORDER BY `count` DESC LIMIT 10时发生Unknown column \'appid\' in \'where clause\'错误，这是由do_action(\'toplevel_page_weixin\'), WP_Hook->do_action, WP_Hook->apply_filters, WPJAM_Menu_Page::admin_page, WPJAM_Menu_Page::plugin_page, WPJAM_Dashboard_Setting->page, wp_dashboard, do_meta_boxes, WEIXIN_Stats::hot_keyword_widget, WPJAM_DB->get_results查询的
[/code]
天津孙立 - 2 年前
[code]test[/code]
天津孙立 - 2 年前
log您能看到吗？ 非常感谢
我要回复
暂时不支持网页回复，请安装 WPJAM-Basic 插件，然后在 WordPress 后台即可参与讨论。