Hardcoded wp_terms in query causing error in logs

This topic contains 4 replies, has 3 voices, and was last updated by  jkirker 4 years, 7 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • #510369

    jkirker
    Lifetime Member
    Post count: 298

    In this particular database, xyzsys_xchs1.wp_terms does not exist as the wp_ prefix was replaced with xchs_

    These are the places where I believe the issue exists:

    ./geodirectory/includes/taxonomy-functions.php:766:		$row = $wpdb->get_row( $wpdb->prepare( "SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN {$wpdb->term_taxonomy} AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = %s AND tt.term_id = %d", array( $taxonomy, $child_of ) ) );
    ./geodirectory/includes/taxonomy-functions.php:772:	$query = $wpdb->prepare( "SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN {$wpdb->term_taxonomy} AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = %s AND tt.parent = %d", array( $taxonomy, $child_of ) )
    #510371

    jkirker
    Lifetime Member
    Post count: 298
    This reply has been marked as private.
    #510441

    Alex Rollin
    Moderator
    Post count: 27815

    Thanks for your post.

    The developers will take a look at your question.

    #510960

    Naveen Giri
    Moderator
    Post count: 1559

    Hi @jkirker,

    Thanks for mentioning it.
    I have updated code and it will up in upcoming version. if you want to apply patch, here is pull request.

    https://github.com/AyeCode/geodirectory/pull/944/files

    Thanks

    #511345

    jkirker
    Lifetime Member
    Post count: 298

    Thank you! 😉

Viewing 5 posts - 1 through 5 (of 5 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket