wavelog: LotW Upload failing in DB_query_builder

Describe the bug My previous LotW certificate expired, so I applied for an extension and got a new cert. The new cert was exported to p12 file without password using TQSL 2.8.1 and uploaded to Wavelog. Wavelog shows a valid certificate. My QSOs don’t upload to LotW anymore, however.

Version Information We need some information about your versions. You can get all Information in the Admin > Debug Menu

  • OS: DietPi v9.12.1
  • PHP: 8.2.28
  • MySQL/MariaDB: 10.11.11-MariaDB-0+deb12u1
  • Wavelog: 2.0.3

Steps to Reproduce

  1. Wait for cron triggered LotW upload -> no upload.
  2. Go to 3rd Party Services - LotW and start manual sync -> no upload

There is no error message displayed in the UI! However, this is in the log: ERROR - 2025-05-06 06:34:25 --> Severity: error --> Exception: where_in() expects $values to be a non-empty array /var/www/system/database/DB_query_builder.php 884

The certificate in question is valid from 2025-05-01 to 2028-04-30 for QSOs from 2024-05-01 to 2028-04-30. The last successful QSO upload was on May 1st, still with the previous certificate (which expired on that day).

How could I help troubleshooting this issue?

EDIT: another user on my instance has the same problem with his recently renewed LotW cert.

About this issue

  • Original URL
  • State: closed
  • Created 2 years ago
  • Comments: 25 (14 by maintainers)

Most upvoted comments

Fixed in 2.0.4

The patch is now merged to dev and will be part of the next release 😃. Thank you for reporting and supporting the debugging here.