1. 论坛系统升级为Xenforo,欢迎大家测试!
    排除公告

终于找到插件错误的原因了!

本帖由 stone42006-12-03 发布。版面名称:源码讨论

  1. stone4

    stone4 New Member

    注册:
    2006-04-08
    帖子:
    48
    赞:
    2
    用了Mozine for WordPress出现错误

    --------------------------------------------------------------------------------
    最新主题

    WordPress 数据库错误: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE post_status = 'publish' AND post_password ='' ORDER BY po]
    SELECT ID, post_title, post_date, post_content FROM WHERE post_status = 'publish' AND post_password ='' ORDER BY post_date DESC LIMIT 0, 10

    最新评论
    WordPress 数据库错误: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' WHERE .ID=.comment_post_ID AND (post_status = 'publish' OR po]
    SELECT ID, comment_ID, comment_content, comment_author FROM , WHERE .ID=.comment_post_ID AND (post_status = 'publish' OR post_status = 'static')AND post_password ='' AND comment_approved = '1' ORDER BY .comment_date DESC LIMIT 10

    热门主题
    WordPress 数据库错误: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'as ID, post_title, post_name, COUNT(.comment_post_ID) AS 'comme]
    SELECT .ID as ID, post_title, post_name, COUNT(.comment_post_ID) AS 'comment_total' FROM LEFT JOIN ON .ID = .comment_post_ID WHERE comment_approved = '1' AND post_date < '2006-12-01 14:49:25' AND post_status = 'publish' AND post_password = '' GROUP BY .comment_post_ID ORDER BY comment_total DESC LIMIT 10

    原因就一句话:自己使用的版本太高了

    解决办法:http://h.thec.cn/free4u/wordpress/?p=31
     
  2. xyf

    xyf New Member

    注册:
    2005-11-12
    帖子:
    66
    赞:
    0
    这样呀~!