0
Started

Wrong Players Scorers Table

Alessandro Morrone 3 years ago in Player updated by Andrei S. (Developer) 3 years ago 11

Hi to anyone,
after two league matches update now my scorers table shows me only one and zero scorers from two teams.

Image 4308


Leagues has got 20 teams (round robin).


  • Plugin Version: AnWP Football Leagues 0.13.5
  • WordPress version: 5.8.2
  • Server Time: UTC
  • WP Time: Europe/Rome
  • Current Date: 2021-12-14
  • Site Locale: it_IT
  • Plugin DB version: 15
  • Statistic records: (matches/stats - 112/112)
  • PHP version: 7.4.24
  • Attiva plugin:
    --- redux-framework
    --- all-in-one-seo-pack
    --- all-in-one-video-gallery
    --- blog2social
    --- classic-editor
    --- cmb2
    --- coming-soon-maintenance-mode-from-acurax
    --- contact-form-7
    --- download-manager
    --- duplicate-page
    --- easy-wp-smtp
    --- enhanced-media-library
    --- football-leagues-by-anwppro
    --- gdlr-shortcode
    --- goodlayers-soccer
    --- google-site-kit
    --- insta-gallery
    --- jetpack
    --- photo-gallery
    --- quick-pagepost-redirect-plugin
    --- quotes-collection
    --- recent-posts-widget-with-thumbnails
    --- responsive-menu-pro
    --- simple-icons
    --- svg-vector-icon-plugin
    --- taxonomy-terms-order
    --- tinymce-advanced
    --- uk-cookie-consent
    --- updraftplus
    --- wordapp
    --- wp-cerber
    --- wp-file-manager
    --- wp-google-maps
    --- wp-poll
    --- wp-statistics
    --- wptelegram
  • Elenco delle tabelle del DB:
    cerber_acl, cerber_blocks, cerber_countries, cerber_lab, cerber_lab_ip, cerber_lab_net, cerber_log, cerber_qmem, cerber_traffic, wp265_actionscheduler_actions, wp265_actionscheduler_claims, wp265_actionscheduler_groups, wp265_actionscheduler_logs, wp265_ahm_assets, wp265_ahm_asset_links, wp265_ahm_download_stats, wp265_ahm_emails, wp265_ahm_sessions, wp265_ahm_social_conns, wp265_ahm_user_download_counts, wp265_aioseo_cache, wp265_aioseo_notifications, wp265_aioseo_posts, wp265_androapp_stats, wp265_anwpfl_matches, wp265_anwpfl_missing_players, wp265_anwpfl_players, wp265_b2s_posts, wp265_b2s_posts_drafts, wp265_b2s_posts_favorites, wp265_b2s_posts_network_details, wp265_b2s_posts_sched_details, wp265_b2s_user, wp265_b2s_user_contact, wp265_b2s_user_network_settings, wp265_bwg_album, wp265_bwg_album_gallery, wp265_bwg_file_paths, wp265_bwg_gallery, wp265_bwg_image, wp265_bwg_image_comment, wp265_bwg_image_rate, wp265_bwg_image_tag, wp265_bwg_shortcode, wp265_bwg_theme, wp265_cerber_files, wp265_cerber_sets, wp265_cerber_uss, wp265_chaty_contact_form_leads, wp265_commentmeta, wp265_comments, wp265_enjoy_instagram_hashtags, wp265_enjoy_instagram_media, wp265_gs_logo_slider, wp265_huge_it_videogallery_galleries, wp265_huge_it_videogallery_videos, wp265_hurrytimer_evergreen, wp265_joomsport_box_fields, wp265_joomsport_box_match, wp265_joomsport_config, wp265_joomsport_events, wp265_joomsport_events_depending, wp265_joomsport_extra_fields, wp265_joomsport_extra_select, wp265_joomsport_groups, wp265_joomsport_maps, wp265_joomsport_match_events, wp265_joomsport_match_statuses, wp265_joomsport_playerlist, wp265_joomsport_seasons, wp265_joomsport_season_table, wp265_joomsport_squad, wp265_links, wp265_lsd_data, wp265_masterslider_options, wp265_masterslider_sliders, wp265_mts_locker_stats, wp265_nextend2_image_storage, wp265_nextend2_section_storage, wp265_nextend2_smartslider3_generators, wp265_nextend2_smartslider3_sliders, wp265_nextend2_smartslider3_sliders_xref, wp265_nextend2_smartslider3_slides, wp265_opanda_leads, wp265_opanda_leads_fields, wp265_opanda_stats_v2, wp265_options, wp265_page_visit, wp265_page_visit_history, wp265_pollsa, wp265_pollsip, wp265_pollsq, wp265_postmeta, wp265_posts, wp265_pw_gcmusers, wp265_quotescollection, wp265_rcsm_subscribers, wp265_responsive_menu, wp265_responsive_menu_pro, wp265_rich_web_video_slider_effects_data, wp265_rich_web_video_slider_font_family, wp265_rich_web_video_slider_id, wp265_rich_web_video_slider_manager, wp265_rich_web_video_slider_videos, wp265_rich_web_vs_effect_1, wp265_rich_web_vs_effect_10, wp265_rich_web_vs_effect_2, wp265_rich_web_vs_effect_3, wp265_rich_web_vs_effect_4, wp265_rich_web_vs_effect_5, wp265_rich_web_vs_effect_6, wp265_rich_web_vs_effect_7, wp265_rich_web_vs_effect_8, wp265_rich_web_vs_effect_9, wp265_sbi_instagram_feeds_posts, wp265_sbi_instagram_posts, wp265_scroll_news, wp265_statistics_exclusions, wp265_statistics_historical, wp265_statistics_pages, wp265_statistics_search, wp265_statistics_useronline, wp265_statistics_visit, wp265_statistics_visitor, wp265_statistics_visitor_relationships, wp265_termmeta, wp265_terms, wp265_term_relationships, wp265_term_taxonomy, wp265_usermeta, wp265_users, wp265_wdi_feeds, wp265_wdi_themes, wp265_wd_fb_data, wp265_wd_fb_info, wp265_wd_fb_option, wp265_wd_fb_shortcode, wp265_wd_fb_theme, wp265_wfblockediplog, wp265_wfblocks7, wp265_wfconfig, wp265_wfcrawlers, wp265_wffilechanges, wp265_wffilemods, wp265_wfhits, wp265_wfhoover, wp265_wfissues, wp265_wfknownfilelist, wp265_wflivetraffichuman, wp265_wflocs, wp265_wflogins, wp265_wfls_2fa_secrets, wp265_wfls_settings, wp265_wfnotifications, wp265_wfpendingissues, wp265_wfreversecache, wp265_wfsnipcache, wp265_wfstatus, wp265_wftrafficrates, wp265_wonderplugin_slider, wp265_wpfm_backup, wp265_wpgmza, wp265_wpgmza_categories, wp265_wpgmza_category_maps, wp265_wpgmza_circles, wp265_wpgmza_maps, wp265_wpgmza_polygon, wp265_wpgmza_polylines, wp265_wpgmza_rectangles, wp265_wpum_fieldmeta, wp265_wpum_fields, wp265_wpum_fieldsgroups, wp265_wpum_registration_formmeta, wp265_wpum_registration_forms, wp265_wpum_search_fields
  • ============================================




How I Can understand what's going on?
Thanks

this happens after update to 0.13.5

for the moment I made a workaround at line 1304 of include/class-anwpfl-player.php restored WHERE 1=1 and not WHERE appearance > 0

this issue is now solved by this action .

It was both (in widget and in shortcode )

Started

Hello


What is it: shortcode or widget?

--

Best Regards

Andrei S.

Send a link to this page and tell what data it should display.

--

Best Regards

Andrei S.

Do you have players in game lineups? 

--

Best Regards

Andrei S.

obviously not. It will be customizable apperance field?

"WHERE appearance > 0" means to filter players who took part in the game according to lineups and substitution events.

--

Best Regards

Andrei S.

yes I know.

But before was where 1=1 :)

"appearance > 0" helps me calculate the number of played games.

I will change this logic to handle your situation in future releases.

--

Best Regards

Andrei S.