Data usage tab not loading

[Dion Garcia]

Hi,

I'm just starting with my Radiusdesk setup and I noticed that the data
usage tab does not continue to load. I ignored it at first because I
thought its just because i have no data. But later on its still not
loading even when i'm done with my configurations and clients are
connected. So i did some checks and saw errors in the logs. I thought
this is just a data problem so I tried reverting the DB back to its
original state but the problem still persist.

Cake3 error log:

2020-05-19 15:11:08 Error: [PDOException] SQLSTATE[HY000]: General 
error: 1525 Incorrect TIMESTAMP value: '2020-05-18 59:59:59
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php(39): 
PDOStatement->execute()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Database/Connection.php(334): 
Cake\Database\Statement\MysqlStatement->execute()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Core/Retry/CommandRetry.php(68): 
Cake\Database\Connection->Cake\Database\{closure}()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Database/Connection.php(337): 
Cake\Core\Retry\CommandRetry->run()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Database/Query.php(219): 
Cake\Database\Connection->run()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/ORM/Query.php(1141): 
Cake\Database\Query->execute()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Datasource/QueryTrait.php(309): 
Cake\ORM\Query->_execute()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/ORM/Query.php(1088): 
Cake\ORM\Query->_all()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Datasource/QueryTrait.php(471): 
Cake\ORM\Query->all()
/var/www/html/cake3/rd_cake/src/Controller/DataUsagesController.php(423): 
Cake\ORM\Query->first()
/var/www/html/cake3/rd_cake/src/Controller/DataUsagesController.php(130): 
App\Controller\DataUsagesController->_getWeeklyGraph()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Controller/Controller.php(610): 
App\Controller\DataUsagesController->usageForRealm()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Http/ActionDispatcher.php(120): 
Cake\Controller\Controller->invokeAction()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Http/ActionDispatcher.php(94): 
Cake\Http\ActionDispatcher->_invoke()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Http/BaseApplication.php(235): 
Cake\Http\ActionDispatcher->dispatch()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Http/Runner.php(65): 
Cake\Http\BaseApplication->__invoke()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Routing/Middleware/RoutingMiddleware.php(162): 
Cake\Http\Runner->__invoke()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Http/Runner.php(65): 
Cake\Routing\Middleware\RoutingMiddleware->__invoke()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Routing/Middleware/AssetMiddleware.php(97): 
Cake\Http\Runner->__invoke()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Http/Runner.php(65): 
Cake\Routing\Middleware\AssetMiddleware->__invoke()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Error/Middleware/ErrorHandlerMiddleware.php(96): 
Cake\Http\Runner->__invoke()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Http/Runner.php(65): 
Cake\Error\Middleware\ErrorHandlerMiddleware->__invoke()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Http/Runner.php(51): 
Cake\Http\Runner->__invoke()
/var/www/html/cake3/rd_cake/vendor/cakephp/cakephp/src/Http/Server.php(98): 
Cake\Http\Runner->run()
/var/www/html/cake3/rd_cake/webroot/index.php(37): 
Cake\Http\Server->run()
/var/www/html/cake3/rd_cake/index.php(16): require('/var/www/html/c...')
{main}
Request URL: 
/data-usages/usage_for_realm.json?_dc=1589872268021&type=realm&username=36&token=b4c6ac81-8c7c-4802-b50a-0a6380555b50&sel_language=4_4
Referer URL: http://192.168.100.19/rd/

All the other features I tested so far are working fine except for this.
The individual graphs are working but it would still be nice if the data
usage summary tab is working too so i can see everything in one page. If
anybody has an have an idea how to solve this issue please let me know.

This is my build environment:
  OS: Ubuntu 20.04
  Arch: arm64 running on Raspberry Pi
  DB: Mysql 8

Thanks and regards.

[Dion Garcia]

I finally got it working. I think this is a bug in the code.

/var/www/html/cake3/rd_cake/src/Controller# diff DataUsagesController.php DataUsagesController.php.orig 
411c411
<         $slot_end   = "$start_day 23:59:59";
---
>         $slot_end   = "$start_day 59:59:59";
435c435
<             $slot_end   = "$start_day 23:59:59";
---
>             $slot_end   = "$start_day 59:59:59";

/var/www/html/cake3/rd_cake/src/Controller# diff UserStatsController.php UserStatsController.php.orig 
124c124
<         $slot_end   = "$start_day 23:59:59";
---
>         $slot_end   = "$start_day 59:59:59";
155c155
<             $slot_end   = "$start_day 23:59:59";
---
>             $slot_end   = "$start_day 59:59:59";

Cheers.