php notice: geodir_location_functions.php

This topic contains 1 reply, has 2 voices, and was last updated by  Kiran 5 years, 11 months ago.

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • May 16, 2018 at 11:07 am #430817

    Rainer Lang
    Expired Member
    Post count: 33

    Hello,
    there are three wrong $wpdb->prepare calls in geodir_location_functions.php lines 553, 559 and 567.
    This is the php notice:

    Notice: wpdb::prepare was called incorrectly. The query does not contain the correct number of placeholders (1) for the number of arguments passed (2). Please see Debugging in WordPress for more information. (This message was added in version 4.8.3.) in /[…]/wp-includes/functions.php on line 4147

    This is the code (e.g. line 553):

    $sql = $wpdb->prepare( "SELECT COUNT(*) AS total FROM " . POST_LOCATION_TABLE . " WHERE " . $field . "=%s GROUP BY " . $field, $location, $location );

    There is one 

    $location

    too much. Could you please correct this for the next version?

    WP 4.9.5
    GeoDirectory 1.6.25
    GeoDir Location Manager 1.5.62

    May 16, 2018 at 1:02 pm #430847

    Kiran
    Moderator
    Post count: 7069

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)

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

Open Support Ticket