{"id":4830955,"date":"2014-04-21T03:56:22","date_gmt":"2014-04-21T03:56:22","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/plugin-database-errors\/"},"modified":"2016-08-21T19:33:09","modified_gmt":"2016-08-21T19:33:09","slug":"plugin-database-errors","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/plugin-database-errors\/","title":{"rendered":"Plugin Database errors"},"content":{"rendered":"<p>Our web hosting (Blue Host) has tracked and checked our website often happen \u201can error occurred while processing this directive\u201d error cause of your plugin have database error. <\/p>\n<p>Please see the following error log and could you help to resolve this urgent issue? Thank you.<\/p>\n<p>***error_log excerpt***<\/p>\n<p>[18-Apr-2014 21:21:24 UTC] PHP Fatal error:  Call to a member function has_cap() on a non-object in \/home\/vsviporg\/public_html\/vantageshanghai\/wp-content\/plugins\/alipay\/includes\/fnc.core.php on line 848<br \/>\n[18-Apr-2014 21:21:26 UTC] PHP Fatal error:  Call to a member function has_cap() on a non-object in \/home\/vsviporg\/public_html\/vantageshanghai\/wp-content\/plugins\/alipay\/includes\/fnc.core.php on line 848<br \/>\n[18-Apr-2014 21:39:27 UTC] WordPress database error Illegal mix of collations for operation &#8216; IN &#8216; for query<br \/>\n\t\t\tSELECT<br \/>\n\t\t\t\ttarget.post_id, sum(target.weight * log(968 \/ least(968, freqs.freq))) as score<br \/>\n\t\t\tFROM<br \/>\n\t\t\t\twp_wp_rp_tags as target,<br \/>\n\t\t\t\t(SELECT label, count(1) as freq FROM wp_wp_rp_tags<br \/>\n\t\t\t\t\tWHERE label IN (&#8216;P_moma&#8217;, &#8216;P_new york&#8217;, &#8216;P_sound art&#8217;, &#8216;C_\u827a\u8ff0&#8217;, &#8216;A_art&#8217;, &#8216;A_alt&#8217;, &#8216;A_div&#8217;, &#8216;A_ap&#8217;, &#8216;A_a&#8217;)<br \/>\n\t\t\t\t\tGROUP BY label<br \/>\n\t\t\t\t) as freqs<br \/>\n\t\t\tWHERE<br \/>\n\t\t\t\ttarget.post_id NOT IN (&#8216;15834&#8217;) AND<\/p>\n<p>\t\t\t\ttarget.label=freqs.label AND<br \/>\n\t\t\t\ttarget.label IN (&#8216;P_moma&#8217;, &#8216;P_new york&#8217;, &#8216;P_sound art&#8217;, &#8216;C_\u827a\u8ff0&#8217;, &#8216;A_art&#8217;, &#8216;A_alt&#8217;, &#8216;A_div&#8217;, &#8216;A_ap&#8217;, &#8216;A_a&#8217;)<br \/>\n\t\t\tGROUP BY target.post_id<br \/>\n\t\t\tORDER BY score desc, target.post_id desc<br \/>\n\t\t\tLIMIT 10; made by require, require_once, include, the_content, apply_filters, call_user_func_array, wp_rp_add_related_posts_hook, wp_rp_get_related_posts, wp_rp_fetch_posts_and_title, wp_rp_append_posts, call_user_func, wp_rp_fetch_related_posts_v2<\/p>\n<p>https:\/\/wordpress.org\/plugins\/alipay\/<\/p>\n","protected":false},"template":"","class_list":["post-4830955","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4830955","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4830955\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=4830955"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}