{"id":20343,"date":"2024-02-16T15:55:59","date_gmt":"2024-02-16T14:55:59","guid":{"rendered":"https:\/\/help.openbee.com\/open-bee-portal\/knowledge-base\/troubleshooting-items\/troubleshooting-documents\/error-500-while-searching\/"},"modified":"2024-02-16T15:55:59","modified_gmt":"2024-02-16T14:55:59","slug":"error-500-while-searching","status":"publish","type":"page","link":"https:\/\/help.openbee.com\/en\/open-bee-portal\/knowledge-base\/troubleshooting-items\/troubleshooting-documents\/error-500-while-searching\/","title":{"rendered":"Error 500 while searching"},"content":{"rendered":"<div id=\"main-content\" class=\"wiki-content group\">\n<h1 id=\"Erreur500lorsdelarecherche-Sympt\u00f4mes\">Symptoms<\/h1>\n<p>Browser returns HTTP 500 error when searching<\/p>\n<h1 id=\"Erreur500lorsdelarecherche-Versionsimpact\u00e9es\">Impacted versions<\/h1>\n<p>Open Bee\u2122 Portal version 6.x.<\/p>\n<h1 id=\"Erreur500lorsdelarecherche-Causes\">Causes&nbsp;<\/h1>\n<p>The index tables in the database are corrupted.&nbsp;<\/p>\n<p>To confirm that this is the issue:&nbsp;<\/p>\n<div class=\"code panel pdl\" style=\"border-width: 1px;\">\n<div class=\"codeContent panelContent pdl\">\n<pre class=\"theme: Confluence; brush: java; gutter: false\" style=\"font-size:12px;\">mysqlcheck  -uroot -p obportal<\/pre>\n<\/div>\n<\/div>\n<p>Tables obp_document_index and\/or obp_document_text should be marked as &#8220;crashed&#8221;&nbsp;<\/p>\n<h1 id=\"Erreur500lorsdelarecherche-R\u00e9solution\"><span style=\"line-height: 1.25;\">Resolution<\/span><\/h1>\n<p>Repair the database:&nbsp;<\/p>\n<div class=\"code panel pdl\" style=\"border-width: 1px;\">\n<div class=\"codeContent panelContent pdl\">\n<pre class=\"theme: Confluence; brush: java; gutter: false\" style=\"font-size:12px;\">mysqlcheck -uroot -p  --auto-repair -A<\/pre>\n<\/div>\n<\/div>\n<p><span style=\"line-height: 1.25;\"><br \/>\n<\/span><\/p>\n<p><span style=\"line-height: 1.25;\">If the repair fails, connect to mysql:&nbsp;<\/span><\/p>\n<p><span style=\"line-height: 1.25;\">&nbsp;<\/span><\/p>\n<div class=\"code panel pdl\" style=\"border-width: 1px;\">\n<div class=\"codeContent panelContent pdl\">\n<pre class=\"theme: Confluence; brush: java; gutter: false\" style=\"font-size:12px;\">mysql -uroot -p obportal<\/pre>\n<\/div>\n<\/div>\n<p>Repair the affected table from the FRM files.&nbsp;<\/p>\n<div class=\"code panel pdl\" style=\"border-width: 1px;\">\n<div class=\"codeContent panelContent pdl\">\n<pre class=\"theme: Confluence; brush: java; gutter: false\" style=\"font-size:12px;\">repair table XXX use_frm<\/pre>\n<\/div>\n<\/div>\n<p>Check that the base is repaired:&nbsp;<\/p>\n<div class=\"code panel pdl\" style=\"border-width: 1px;\">\n<div class=\"codeContent panelContent pdl\">\n<pre class=\"theme: Confluence; brush: java; gutter: false\" style=\"font-size:12px;\">mysqlcheck  -uroot -p obportal<\/pre>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Symptoms Browser returns HTTP 500 error when searching Impacted versions Open Bee\u2122 Portal version 6.x. Causes&nbsp; The index tables in the database are corrupted.&nbsp; To confirm that this is the issue:&nbsp; mysqlcheck -uroot -p obportal Tables obp_document_index and\/or obp_document_text should be marked as &#8220;crashed&#8221;&nbsp; Resolution Repair the database:&nbsp; mysqlcheck -uroot -p &#8211;auto-repair -A If the [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":20339,"menu_order":6,"comment_status":"closed","ping_status":"closed","template":"templates\/ob-help-products.php","meta":{"footnotes":""},"class_list":["post-20343","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/20343","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/comments?post=20343"}],"version-history":[{"count":0,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/20343\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/20339"}],"wp:attachment":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/media?parent=20343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}