User registration breaks with RecentTopics

[Gnarfoz]

Expected Behavior

User registration as normal

Actual Behavior

User registration breaks when the user posts the registration form.
SQL error is: Incorrect integer value: '' for column 'user_rt_sort_start_time' at row 1 [1366]

Steps to Reproduce the Problem

1. In the extension options, set Sort by topic start time to No
2. In the extension options, set Only display unread topics to No
3. Try user registration

Specifications

• phpbb version: 3.2.2
• recenttopics version: 9607a50

[Galixte]

Hi @Sajaki,

could you fix this, please?

[Galixte]

@Sajaki Always the same error in 2.2.8 version:

SQL ERROR [ mysqli ]

Incorrect integer value: '' for column 'user_rt_sort_start_time' at row 1 [1366]

SQL

UPDATE phpbb_users SET user_rt_enable = '1' , user_rt_sort_start_time = '' , user_rt_unread_only = '' , user_rt_location = 'RT_TOP' , user_rt_number = 5 WHERE 1=1 AND user_id = 1

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 996
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/paybas/recenttopics/event/ucp_listener.php
LINE: 227
CALL: phpbb\db\driver\factory->sql_query()

FILE: (not given by php)
LINE: (not given by php)
CALL: paybas\recenttopics\event\ucp_listener->ucp_register_set_data()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 184
CALL: call_user_func()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 46
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 62
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/includes/ucp/ucp_register.php
LINE: 341
CALL: phpbb\event\dispatcher->trigger_event()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: ucp_register->main()

FILE: [ROOT]/includes/functions_module.php
LINE: 998
CALL: p_master->load_active()

FILE: [ROOT]/ucp.php
LINE: 70
CALL: p_master->load()