mysql - 升级到wordpress 3.5.1后出错

Question

升级到 WordPress 3.5.1 后。我有一些与此类似的数据库错误。怎么解决这个问题呢？

2013/04/27 18:43:32 [error] 1361#0: *1161766 FastCGI sent in stderr: "WordPress database error Duplicate column name 'hsa_link' for query ALTER TABLEwp_hsa_pluginADDhsa_linkVARCHAR( 1024 ) NOT NULL made by activate_plugin, do_action('activate_horizontal-scrolling-announcement/horizontal-scrolling-announcement.php'), call_user_func_array, HSA_activation, W3_Db->query" while reading response header from upstream, client: , server: example.com, request: "GET /wp-admin/plugins.php?action=activate&plugin=horizontal-scrolling-announcement%2Fhorizontal-scrolling-announcement.php&plugin_status=all&paged=1&s&_wpnonce=e0c9f7a949 HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "example.com", referrer: "http://example.com/wp-admin/plugins.php?activate=true&plugin_status=all&paged=1&s="

Answer 1

首先尝试禁用水平滚动公告插件，看看是否可以恢复该网站。如果是这样，您应该能够在文件中名为 activate_plugin 的函数中找到问题:

wp-content/plugins/activate_horizo​​ntal-scrolling-announcement/horizo​​ntal-scrolling-announcement.php

它看起来像是在尝试再次添加先前添加的列(hsa_link)。尝试将“添加 hsa_link”更改为“修改 hsa_link”，或者您可以删除 SQL 并自行更改。