• I get Function wpdb::prepare was called incorrectly on ui.php line 155.

    The wpdb::prepare() function requires at least one placeholder (%s, %d, etc.) and a corresponding parameter to be passed for security reasons.
    Since the SQL query does not have any user-provided values, you don’t need to use prepare(). Instead, you can use the query directly like this:

    $top_searches = $wpdb->get_results( "SELECT * FROM {$table_name} ORDER BY LENGTH(query) DESC, occurrences DESC, results DESC LIMIT 100" );
  • You must be logged in to reply to this topic.