“Last 14 Days by Location” doesn’t show any location

[marco-brandizi]

Describe the bug

Copy-pasting from the support forum:

I’ve enabled the spammer geo-location using IPinfo.

As you can see below, that works well, except for the “Last 14 Days by Location” box, where ‘unknown’ is the only ‘location’ that it’s shown.

Initially, I tried IPbase and that worked for a while. Is it a bug? Is there something I can try to reset?

Steps to Reproduce

1. Install Zero-Spam
2. Enable IP-Info, enable location reporting
3. After a while, open the dashboard

Screenshots, screen recording, code snippet

Environment information

• WP 6.2.2 via Docker, proxied by nginx 1.18.0
• Zero Spam 5.5.1
• Contabo VPS
• Linux Ubuntu 22.04, updated today (20230710)

WordPress information

wp-core

version: 6.2.2
site_language: en_GB
user_language: en_GB
timezone: Europe/London
permalink: /%postname%/
https_status: true
multisite: false
user_registration: 0
blog_public: 1
default_comment_status: open
environment_type: production
user_count: 2
dotorg_communication: true

wp-paths-sizes

wordpress_path: /var/www/html
wordpress_size: 52.83 MB (55396664 bytes)
uploads_path: /var/www/html/wp-content/uploads
uploads_size: 88.67 MB (92973041 bytes)
themes_path: /var/www/html/wp-content/themes
themes_size: 22.89 MB (23999272 bytes)
plugins_path: /var/www/html/wp-content/plugins
plugins_size: 113.30 MB (118806057 bytes)
database_size: 29.28 MB (30703616 bytes)
total_size: 306.97 MB (321878650 bytes)

wp-active-theme

name: Bizz Builder (bizz-builder)
version: 1.0.6
author: WpZita Team
author_website: https://wpzita.com/
parent_theme: Zita (zita)
theme_features: core-block-patterns, block-templates, widgets-block-editor, custom-background, wp-block-styles, align-wide, editor-styles, editor-style, responsive-embeds, custom-spacing, automatic-feed-links, title-tag, post-thumbnails, html5, woocommerce, customize-selective-refresh-widgets, custom-logo, custom-header, menus, widgets
theme_path: /var/www/html/wp-content/themes/bizz-builder
auto_update: Disabled

wp-parent-theme

name: Zita (zita)
version: 1.6.0
author: WpZita Team
author_website: (undefined)
theme_path: /var/www/html/wp-content/themes/zita
auto_update: Disabled

wp-themes-inactive (3)

Twenty Twenty-One: version: 1.8, author: the WordPress team, Auto-updates disabled
Twenty Twenty-Three: version: 1.1, author: the WordPress team, Auto-updates disabled
Twenty Twenty-Two: version: 1.4, author: the WordPress team, Auto-updates disabled

wp-mu-plugins (1)

aaa-wp-cerber.php: version: 1.0, author: Cerber Tech Inc.

wp-plugins-active (12)

Biographical Info Paragraphed: version: 1.1, author: Kamrul Hasan, Auto-updates disabled
Complianz | GDPR/CCPA Cookie Consent: version: 6.5.1, author: Really Simple Plugins, Auto-updates disabled
Password Policy Manager: version: 1.5.0, author: miniOrange, Auto-updates disabled
Smart Custom 404 error page [404page]: version: 11.4.3, author: Peter Raschendorfer, Auto-updates disabled
TaxoPress: version: 3.8.0, author: TaxoPress, Auto-updates disabled
WP Cerber Security, Anti-spam & Malware Scan: version: 9.0, author: Cerber Tech Inc., Auto-updates disabled
WPForms Lite: version: 1.8.2.2, author: WPForms, Auto-updates disabled
WP Githuber MD: version: 1.16.2, author: Terry Lin, Auto-updates disabled
WP Mail SMTP: version: 3.8.0, author: WP Mail SMTP, Auto-updates disabled
Yet Another Stars Rating: version: 3.4.2, author: Dario Curvino, Auto-updates disabled
Zero Spam for WordPress: version: 5.5.1, author: Highfivery LLC, Auto-updates disabled
Zita Site Library: version: 1.6.1, author: WPZita, Auto-updates disabled

wp-plugins-inactive (4)

Akismet Anti-Spam: Spam Protection: version: 5.2, author: Automattic - Anti Spam Team, Auto-updates disabled
Hello Dolly: version: 1.7.2, author: Matt Mullenweg, Auto-updates disabled
New User Approve: version: 2.5.1, author: WPExpertsio, Auto-updates disabled
User Verification: version: 2.0.16, author: PickPlugins, Auto-updates disabled

wp-media

image_editor: WP_Image_Editor_Imagick
imagick_module_version: 1691
imagemagick_version: ImageMagick 6.9.11-60 Q16 x86_64 2021-01-25 https://imagemagick.org
imagick_version: 3.6.0
file_uploads: File uploads is turned off
post_max_size: 64M
upload_max_filesize: 64M
max_effective_size: 64 MB
max_file_uploads: 20
imagick_limits:
imagick::RESOURCETYPE_AREA: 122 MB
imagick::RESOURCETYPE_DISK: 1073741824
imagick::RESOURCETYPE_FILE: 786432
imagick::RESOURCETYPE_MAP: 512 MB
imagick::RESOURCETYPE_MEMORY: 256 MB
imagick::RESOURCETYPE_THREAD: 1
imagick::RESOURCETYPE_TIME: 9.2233720368548E+18
imagemagick_file_formats: 3FR, 3G2, 3GP, AAI, AI, APNG, ART, ARW, AVI, AVIF, AVS, BGR, BGRA, BGRO, BIE, BMP, BMP2, BMP3, BRF, CAL, CALS, CANVAS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CR3, CRW, CUR, CUT, DATA, DCM, DCR, DCX, DDS, DFONT, DNG, DPX, DXT1, DXT5, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, FAX, FILE, FITS, FRACTAL, FTP, FTS, G3, G4, GIF, GIF87, GRADIENT, GRAY, GRAYA, GROUP4, H, HALD, HDR, HEIC, HISTOGRAM, HRZ, HTM, HTML, HTTP, HTTPS, ICB, ICO, ICON, IIQ, INFO, INLINE, IPL, ISOBRL, ISOBRL6, J2C, J2K, JBG, JBIG, JNG, JNX, JP2, JPC, JPE, JPEG, JPG, JPM, JPS, JPT, JSON, K25, KDC, LABEL, M2V, M4V, MAC, MAGICK, MAP, MASK, MAT, MATTE, MEF, MIFF, MKV, MNG, MONO, MOV, MP4, MPC, MPG, MRW, MSL, MTV, MVG, NEF, NRW, NULL, ORF, OTB, OTF, PAL, PALM, PAM, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PES, PFA, PFB, PFM, PGM, PGX, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG00, PNG24, PNG32, PNG48, PNG64, PNG8, PNM, POCKETMOD, PPM, PREVIEW, PS, PS2, PS3, PSB, PSD, PTIF, PWP, RADIAL-GRADIENT, RAF, RAS, RAW, RGB, RGBA, RGBO, RGF, RLA, RLE, RMF, RW2, SCR, SCT, SFW, SGI, SHTML, SIX, SIXEL, SPARSE-COLOR, SR2, SRF, STEGANO, SUN, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TTC, TTF, TXT, UBRL, UBRL6, UIL, UYVY, VDA, VICAR, VID, VIDEO, VIFF, VIPS, VST, WBMP, WEBM, WEBP, WMV, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, YCbCr, YCbCrA, YUV
gd_version: bundled (2.1.0 compatible)
gd_formats: GIF, JPEG, PNG, WebP, BMP
ghostscript_version: 9.53.3

wp-server

server_architecture: Linux 5.15.0-76-generic x86_64
httpd_software: Apache/2.4.56 (Debian)
php_version: 8.0.29 64bit
php_sapi: apache2handler
max_input_variables: 1000
time_limit: 600
memory_limit: 64M
admin_memory_limit: 256M
max_input_time: -1
upload_max_filesize: 64M
php_post_max_size: 64M
curl_version: 7.74.0 OpenSSL/1.1.1n
suhosin: false
imagick_availability: true
pretty_permalinks: true
htaccess_extra_rules: false

wp-database

extension: mysqli
server_version: 8.0.33-0ubuntu0.22.04.2
client_version: mysqlnd 8.0.29
max_allowed_packet: 67108864
max_connections: 151

wp-constants

WP_HOME: undefined
WP_SITEURL: undefined
WP_CONTENT_DIR: /var/www/html/wp-content
WP_PLUGIN_DIR: /var/www/html/wp-content/plugins
WP_MEMORY_LIMIT: 40M
WP_MAX_MEMORY_LIMIT: 256M
WP_DEBUG: false
WP_DEBUG_DISPLAY: true
WP_DEBUG_LOG: false
SCRIPT_DEBUG: false
WP_CACHE: false
CONCATENATE_SCRIPTS: undefined
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_ENVIRONMENT_TYPE: Undefined
DB_CHARSET: utf8
DB_COLLATE: undefined

wp-filesystem

wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable
mu-plugins: writable

wp_mail_smtp

version: 3.8.0
license_key_type: lite
debug: No debug notices found.
lite_install_date: Nov 21, 2020 @ 6:37pm

wpforms

version: 1.8.2.2
lite: Sep 21, 2020 @ 2:47pm
upload_dir: Writable
total_forms: 1
total_submissions: 20

Code of Conduct

• I agree to follow this project's Code of Conduct

[bmarshall511]

@marco-brandizi Thanks for reaching out. Took a quick loop and wasn't able to replicate. Could you shoot me an export of your wpzerospam_log table so I can try to figure out what's going on?

Send it to ben@highfivery.com.

[marco-brandizi]

thanks @bmarshall511, I've emailed you.