Title: Request Error
Last modified: August 28, 2023

---

# Request Error

 *  Resolved [flk73](https://wordpress.org/support/users/flk73/)
 * (@flk73)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/request-error-5/)
 * Hi,
   I found an error in sql request on file **includes/gedshow_db_handler.php**
   using Version 2.1.0
 * Lines 174 and 176 on the request 
   $Results = $wpdb->get_results($wpdb->prepare(“
   SELECT _, COUNT(_) totalcount FROM $names_tbl WHERE living LIKE ‘N’ AND LEFT(
   surname,1)= %s GROUP BY surname ASC”, $letter));Need to remove ASC at the end
   of the request.Best RegardsFranck
    -  This topic was modified 2 years, 9 months ago by [flk73](https://wordpress.org/support/users/flk73/).

Viewing 1 replies (of 1 total)

 *  Plugin Author [colinsp](https://wordpress.org/support/users/colinsp/)
 * (@colinsp)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/request-error-5/#post-17009406)
 * Franck
 * Thank you for spotting this I will remove it from the next release.

Viewing 1 replies (of 1 total)

The topic ‘Request Error’ is closed to new replies.

 * ![](https://ps.w.org/gedshow/assets/icon-256x256.png?rev=2008510)
 * [GedShow](https://wordpress.org/plugins/gedshow/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/gedshow/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/gedshow/)
 * [Active Topics](https://wordpress.org/support/plugin/gedshow/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/gedshow/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/gedshow/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [colinsp](https://wordpress.org/support/users/colinsp/)
 * Last activity: [2 years, 9 months ago](https://wordpress.org/support/topic/request-error-5/#post-17009406)
 * Status: resolved