October 6th, 2007

2.3数据库问题还没解决

Category: wordpress, Author: 阿七, Popularity: 12% [?]

升级到wordpress 2.3 ,数据库的问题现在还存在:

原来是wp_post2cat 的问题,现在在分类列表文章的地方出现出题:

WordPress database error: [Unknown column 'wp_posts.ID' in 'group statement']
SELECT ID, post_title FROM wp_posts p LEFT JOIN wp_term_relationships tr ON p.ID = tr.object_id LEFT JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN wp_ak_popularity pop ON p.ID = pop.post_id WHERE tt.term_id = '25' AND tt.taxonomy = 'category' AND post_status = 'publish' AND post_type = 'post' AND post_date < NOW() GROUP BY wp_posts.ID ORDER BY pop.total DESC LIMIT 10 

关于wp_post2cat 的问题 :

            1. The sky of Daemon!这么解决的:
用了一个土办法来解决此问题,那就是在数据库中手工恢复这两个表格,代码在下面链接里面。到目前为止还没出现任何问题,但这也只是临时的,我们还要等待官方的解决方案。具体: http://blog.bsdos.cn/archives/940

         2. wordpress.org 论坛这么讨论的:
 http://wordpress.org/support/topic/135564

什么?上面的文章不过瘾?我还特意准备了这些:

Tags:, .
评论数量(1) | Add Comments
本文网址:http://blog.designlinks.cn/wordpress/wp_post2cat.html

One Comments so far

» You can leave a response or Trackback .

  1. Gravatar Icon keith Says:

    你把所有的plugin都禁用了看看。

    Beach回复:
    嗯,这个我试过,除了停用这个皮肤那些必须的插件。好像不起作用…

leave a reply