Need help with Joomla? We are available for hire to help with Joomla customization, upgrades, maintenance, and custom development.

Bug Report - Events Booking Pro 5.10.0 - Late Fee

More

8 hours 17 minutes ago #179896 by Tom

Bug Report - Events Booking Pro 5.10.0 - Late Fee was created by Tom

Component: Events Booking Pro 5.10.0 Bug: Late fee triggers at start of calendar day instead of at the configured timeExpected:

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

Code:

DATEDIFF()

for the late fee check:

Code:

DATEDIFF($currentDate, a.late_fee_date) AS late_fee_date_diff

Code:

DATEDIFF

strips the time portion, so any time on Oct 16 returns 0, and

Code:

0 >= 0

triggers the fee.The other query paths (

Code:

model/event.php:47

,

Code:

model/list.php:279

,

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

Code:

database.php:92

from

Code:

DATEDIFF(...)

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.

Please Log in or Create an account to join the conversation.