{"id":17007659,"date":"2023-08-28T20:55:22","date_gmt":"2023-08-28T20:55:22","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/request-error-5\/"},"modified":"2023-08-28T20:57:26","modified_gmt":"2023-08-28T20:57:26","slug":"request-error-5","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/request-error-5\/","title":{"rendered":"Request Error"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Hi,<br \/>I found an error in sql request on file <strong>includes\/gedshow_db_handler.php<\/strong> using Version 2.1.0<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Lines 174 and 176 on the request <br \/>$Results = $wpdb-&gt;get_results($wpdb-&gt;prepare(&#8220;SELECT <em>, COUNT(<\/em>) totalcount FROM $names_tbl WHERE living LIKE &#8216;N&#8217; AND LEFT(surname,1)= %s GROUP BY surname ASC&#8221;, $letter));<br \/><br \/>Need to remove ASC at the end of the request.<br \/><br \/>Best Regards<br \/><br \/>Franck<br \/><br \/><\/p>\n","protected":false},"template":"","class_list":["post-17007659","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17007659","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":1,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17007659\/revisions"}],"predecessor-version":[{"id":17007662,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17007659\/revisions\/17007662"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=17007659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}