Diagnostic Tools: Failed to fix channelOrphaned!

[alecrespi78]

Describe the bug

Error message shows up with "channelOrphaned" tool.

Exception throw at line 442 in file /web/htdocs/www.commandsandcolors.net/home/thegreatwar/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php with message Truncated incorrect INTEGER value: 'none'
Failed to fix channelOrphaned!

To Reproduce
Steps to reproduce the behavior:

1. Login on a Joomla backend (admin panel)
2. Open a Kunena / Dashboard
3. Click on "Tools" button
4. Select "Diagnostics"
5. Select "Fix issues" on "channelOrphaned"

Sample site: https://www.commandsandcolors.net/thegreatwar/

Expected behavior
Fixing orphaned threads.

Actual result
Error message.

Screenshots

System information (please complete the following information)

Joomla version: 4.3.3
Kunena version: 6.1.2
Php version: 8.2.7
Database version: 5.7.32-35

Desktop (please complete the following information):

• OS: Win
• Browser Chrome
• Version 115.0.5790.110

[alecrespi78]

Updated System information but the error is still present.

Joomla version: 4.3.4
Kunena version: 6.1.3.1 | 2023-08-21
Php version: 8.2.7
Database version: 5.7.32-35

[github-actions]

This issue is stale because it has been open 30 days with no activity.