Component: Events Booking Pro 5.10.0
Bug: Late fee triggers at start of calendar day instead of at the configured time
Expected:
Code:
late_fee_date = '2026-10-16 23:59:00'
should not apply the late fee until 11:59 PM on Oct 16.
Actual: Late fee applies immediately at midnight Oct 16 (start of day).
Root cause:
Code:
helper/database.php
line ~92 uses
for the late fee check:
Code:
DATEDIFF($currentDate, a.late_fee_date) AS late_fee_date_diff
strips the time portion, so any time on Oct 16 returns 0, and
triggers the fee.The other query paths (
,
,
Code:
model/commoncalendar.php:115
) correctly use:
Code:
TIMESTAMPDIFF(MINUTE, a.late_fee_date, $currentDate) AS late_fee_date_diff
which returns a negative value until the exact minute is reached.
Fix: Change
from
to
Code:
TIMESTAMPDIFF(MINUTE, a.late_fee_date, $currentDate)
to match the other paths.
Affected path:
Code:
EventbookingHelperDatabase::getEvent()
— used by the registration controller (both frontend and admin), so this is the path that actually calculates the fee at checkout.
