1. 论坛系统升级为Xenforo,欢迎大家测试!
    Dismiss Notice

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

Discussion in '源码讨论' started by stone4, Dec 3, 2006.

  1. stone4

    stone4 New Member

    Joined:
    Apr 8, 2006
    Messages:
    48
    Likes Received:
    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

    Joined:
    Nov 12, 2005
    Messages:
    66
    Likes Received:
    0
    这样呀~!