[08-Nov-2025 10:11:55 Asia/Bangkok] [Landing] User has dashboard permission - redirecting to dashboard
[08-Nov-2025 10:11:55 Asia/Bangkok] Dashboard appointments error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause'
[08-Nov-2025 10:19:36 Asia/Bangkok] [Landing] User has dashboard permission - redirecting to dashboard
[08-Nov-2025 10:19:36 Asia/Bangkok] Dashboard appointments error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause'
[08-Nov-2025 10:21:25 Asia/Bangkok] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'deleted_at' in 'where clause' in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php:40
Stack trace:
#0 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php(40): PDO->prepare('SELECT COUNT(*)...')
#1 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(49): App\Helpers\Database->query('SELECT COUNT(*)...', Array)
#2 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(91): App\Models\BaseModel->count(Array)
#3 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/EncountersController.php(28): App\Models\BaseModel->paginate(Array)
#4 [internal function]: App\Controllers\EncountersController->index()
#5 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Router.php(102): call_user_func(Array)
#6 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/index.php(322): App\Helpers\Router::dispatch()
#7 {main}
  thrown in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php on line 40
[08-Nov-2025 10:21:36 Asia/Bangkok] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'deleted_at' in 'where clause' in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php:40
Stack trace:
#0 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php(40): PDO->prepare('SELECT COUNT(*)...')
#1 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(49): App\Helpers\Database->query('SELECT COUNT(*)...', Array)
#2 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(91): App\Models\BaseModel->count(Array)
#3 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/EncountersController.php(28): App\Models\BaseModel->paginate(Array)
#4 [internal function]: App\Controllers\EncountersController->index()
#5 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Router.php(102): call_user_func(Array)
#6 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/index.php(322): App\Helpers\Router::dispatch()
#7 {main}
  thrown in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php on line 40
[08-Nov-2025 10:22:40 Asia/Bangkok] PHP Warning:  include(/home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Views/care_plans/index.php): Failed to open stream: No such file or directory in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/CarePlanController.php on line 71
[08-Nov-2025 10:22:40 Asia/Bangkok] PHP Warning:  include(): Failed opening '/home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Views/care_plans/index.php' for inclusion (include_path='.:/opt/cpanel/ea-php81/root/usr/share/pear') in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/CarePlanController.php on line 71
[08-Nov-2025 10:23:14 Asia/Bangkok] PHP Warning:  include(/home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Views/care_plans/index.php): Failed to open stream: No such file or directory in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/CarePlanController.php on line 71
[08-Nov-2025 10:23:14 Asia/Bangkok] PHP Warning:  include(): Failed opening '/home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Views/care_plans/index.php' for inclusion (include_path='.:/opt/cpanel/ea-php81/root/usr/share/pear') in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/CarePlanController.php on line 71
[08-Nov-2025 10:23:20 Asia/Bangkok] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'deleted_at' in 'where clause' in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php:40
Stack trace:
#0 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php(40): PDO->prepare('SELECT COUNT(*)...')
#1 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(49): App\Helpers\Database->query('SELECT COUNT(*)...', Array)
#2 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(91): App\Models\BaseModel->count(Array)
#3 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/EncountersController.php(28): App\Models\BaseModel->paginate(Array)
#4 [internal function]: App\Controllers\EncountersController->index()
#5 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Router.php(102): call_user_func(Array)
#6 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/index.php(322): App\Helpers\Router::dispatch()
#7 {main}
  thrown in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php on line 40
[08-Nov-2025 10:34:18 Asia/Bangkok] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'deleted_at' in 'where clause' in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php:40
Stack trace:
#0 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php(40): PDO->prepare('SELECT COUNT(*)...')
#1 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(49): App\Helpers\Database->query('SELECT COUNT(*)...', Array)
#2 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(91): App\Models\BaseModel->count(Array)
#3 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/EncountersController.php(28): App\Models\BaseModel->paginate(Array)
#4 [internal function]: App\Controllers\EncountersController->index()
#5 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Router.php(102): call_user_func(Array)
#6 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/index.php(322): App\Helpers\Router::dispatch()
#7 {main}
  thrown in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php on line 40
[08-Nov-2025 10:36:35 Asia/Bangkok] Remember-me login error: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'is_active' in where clause is ambiguous
[08-Nov-2025 10:36:37 Asia/Bangkok] Remember-me login error: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'is_active' in where clause is ambiguous
[08-Nov-2025 10:36:39 Asia/Bangkok] Remember-me login error: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'is_active' in where clause is ambiguous
[08-Nov-2025 10:36:40 Asia/Bangkok] Dashboard appointments error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause'
[08-Nov-2025 10:36:45 Asia/Bangkok] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'deleted_at' in 'where clause' in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php:40
Stack trace:
#0 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php(40): PDO->prepare('SELECT COUNT(*)...')
#1 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(49): App\Helpers\Database->query('SELECT COUNT(*)...', Array)
#2 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(91): App\Models\BaseModel->count(Array)
#3 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/EncountersController.php(28): App\Models\BaseModel->paginate(Array)
#4 [internal function]: App\Controllers\EncountersController->index()
#5 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Router.php(102): call_user_func(Array)
#6 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/index.php(322): App\Helpers\Router::dispatch()
#7 {main}
  thrown in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php on line 40
[08-Nov-2025 10:37:44 Asia/Bangkok] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'deleted_at' in 'where clause' in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php:40
Stack trace:
#0 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php(40): PDO->prepare('SELECT COUNT(*)...')
#1 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(49): App\Helpers\Database->query('SELECT COUNT(*)...', Array)
#2 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(91): App\Models\BaseModel->count(Array)
#3 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/EncountersController.php(28): App\Models\BaseModel->paginate(Array)
#4 [internal function]: App\Controllers\EncountersController->index()
#5 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Router.php(102): call_user_func(Array)
#6 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/index.php(322): App\Helpers\Router::dispatch()
#7 {main}
  thrown in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php on line 40
[08-Nov-2025 10:37:46 Asia/Bangkok] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'deleted_at' in 'where clause' in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php:40
Stack trace:
#0 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php(40): PDO->prepare('SELECT COUNT(*)...')
#1 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(49): App\Helpers\Database->query('SELECT COUNT(*)...', Array)
#2 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(91): App\Models\BaseModel->count(Array)
#3 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/EncountersController.php(28): App\Models\BaseModel->paginate(Array)
#4 [internal function]: App\Controllers\EncountersController->index()
#5 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Router.php(102): call_user_func(Array)
#6 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/index.php(322): App\Helpers\Router::dispatch()
#7 {main}
  thrown in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php on line 40
[08-Nov-2025 10:38:39 Asia/Bangkok] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'deleted_at' in 'where clause' in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php:40
Stack trace:
#0 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php(40): PDO->prepare('SELECT COUNT(*)...')
#1 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(49): App\Helpers\Database->query('SELECT COUNT(*)...', Array)
#2 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(91): App\Models\BaseModel->count(Array)
#3 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/EncountersController.php(28): App\Models\BaseModel->paginate(Array)
#4 [internal function]: App\Controllers\EncountersController->index()
#5 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Router.php(102): call_user_func(Array)
#6 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/index.php(322): App\Helpers\Router::dispatch()
#7 {main}
  thrown in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php on line 40
[08-Nov-2025 10:38:39 Asia/Bangkok] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'deleted_at' in 'where clause' in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php:40
Stack trace:
#0 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php(40): PDO->prepare('SELECT COUNT(*)...')
#1 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(49): App\Helpers\Database->query('SELECT COUNT(*)...', Array)
#2 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(91): App\Models\BaseModel->count(Array)
#3 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/EncountersController.php(28): App\Models\BaseModel->paginate(Array)
#4 [internal function]: App\Controllers\EncountersController->index()
#5 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Router.php(102): call_user_func(Array)
#6 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/index.php(322): App\Helpers\Router::dispatch()
#7 {main}
  thrown in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php on line 40
[08-Nov-2025 10:38:40 Asia/Bangkok] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'deleted_at' in 'where clause' in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php:40
Stack trace:
#0 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php(40): PDO->prepare('SELECT COUNT(*)...')
#1 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(49): App\Helpers\Database->query('SELECT COUNT(*)...', Array)
#2 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(91): App\Models\BaseModel->count(Array)
#3 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/EncountersController.php(28): App\Models\BaseModel->paginate(Array)
#4 [internal function]: App\Controllers\EncountersController->index()
#5 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Router.php(102): call_user_func(Array)
#6 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/index.php(322): App\Helpers\Router::dispatch()
#7 {main}
  thrown in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php on line 40
[08-Nov-2025 10:38:40 Asia/Bangkok] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'deleted_at' in 'where clause' in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php:40
Stack trace:
#0 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php(40): PDO->prepare('SELECT COUNT(*)...')
#1 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(49): App\Helpers\Database->query('SELECT COUNT(*)...', Array)
#2 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(91): App\Models\BaseModel->count(Array)
#3 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/EncountersController.php(28): App\Models\BaseModel->paginate(Array)
#4 [internal function]: App\Controllers\EncountersController->index()
#5 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Router.php(102): call_user_func(Array)
#6 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/index.php(322): App\Helpers\Router::dispatch()
#7 {main}
  thrown in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php on line 40
[08-Nov-2025 10:38:40 Asia/Bangkok] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'deleted_at' in 'where clause' in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php:40
Stack trace:
#0 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php(40): PDO->prepare('SELECT COUNT(*)...')
#1 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(49): App\Helpers\Database->query('SELECT COUNT(*)...', Array)
#2 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(91): App\Models\BaseModel->count(Array)
#3 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/EncountersController.php(28): App\Models\BaseModel->paginate(Array)
#4 [internal function]: App\Controllers\EncountersController->index()
#5 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Router.php(102): call_user_func(Array)
#6 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/index.php(322): App\Helpers\Router::dispatch()
#7 {main}
  thrown in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php on line 40
[08-Nov-2025 10:39:48 Asia/Bangkok] Dashboard appointments error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause'
[08-Nov-2025 10:39:51 Asia/Bangkok] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'deleted_at' in 'where clause' in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php:40
Stack trace:
#0 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php(40): PDO->prepare('SELECT COUNT(*)...')
#1 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(49): App\Helpers\Database->query('SELECT COUNT(*)...', Array)
#2 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Models/BaseModel.php(91): App\Models\BaseModel->count(Array)
#3 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/EncountersController.php(28): App\Models\BaseModel->paginate(Array)
#4 [internal function]: App\Controllers\EncountersController->index()
#5 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Router.php(102): call_user_func(Array)
#6 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/index.php(322): App\Helpers\Router::dispatch()
#7 {main}
  thrown in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Helpers/Database.php on line 40
[08-Nov-2025 10:42:17 Asia/Bangkok] PHP Warning:  include(/home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Views/care_plans/index.php): Failed to open stream: No such file or directory in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/CarePlanController.php on line 71
[08-Nov-2025 10:42:17 Asia/Bangkok] PHP Warning:  include(): Failed opening '/home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Views/care_plans/index.php' for inclusion (include_path='.:/opt/cpanel/ea-php81/root/usr/share/pear') in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/CarePlanController.php on line 71
[08-Nov-2025 10:42:59 Asia/Bangkok] PHP Warning:  include(/home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Views/care_plans/index.php): Failed to open stream: No such file or directory in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/CarePlanController.php on line 71
[08-Nov-2025 10:42:59 Asia/Bangkok] PHP Warning:  include(): Failed opening '/home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Views/care_plans/index.php' for inclusion (include_path='.:/opt/cpanel/ea-php81/root/usr/share/pear') in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/CarePlanController.php on line 71
[08-Nov-2025 10:44:35 Asia/Bangkok] PHP Warning:  include(/home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/../Views/care_plans/index.php): Failed to open stream: No such file or directory in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/CarePlanController.php on line 71
[08-Nov-2025 10:44:35 Asia/Bangkok] PHP Warning:  include(): Failed opening '/home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/../Views/care_plans/index.php' for inclusion (include_path='.:/opt/cpanel/ea-php81/root/usr/share/pear') in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/CarePlanController.php on line 71
[08-Nov-2025 10:49:24 Asia/Bangkok] PHP Warning:  include(/home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Views/care_plans/index.php): Failed to open stream: No such file or directory in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/CarePlanController.php on line 71
[08-Nov-2025 10:49:24 Asia/Bangkok] PHP Warning:  include(): Failed opening '/home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Views/care_plans/index.php' for inclusion (include_path='.:/opt/cpanel/ea-php81/root/usr/share/pear') in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/CarePlanController.php on line 71
[08-Nov-2025 10:49:54 Asia/Bangkok] PHP Warning:  include(/home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Views/care_plans/index.php): Failed to open stream: No such file or directory in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/CarePlanController.php on line 71
[08-Nov-2025 10:49:54 Asia/Bangkok] PHP Warning:  include(): Failed opening '/home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Views/care_plans/index.php' for inclusion (include_path='.:/opt/cpanel/ea-php81/root/usr/share/pear') in /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/app/Controllers/CarePlanController.php on line 71
[08-Nov-2025 10:51:30 Asia/Bangkok] [Landing] User has dashboard permission - redirecting to dashboard
[08-Nov-2025 10:51:30 Asia/Bangkok] Dashboard appointments error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause'
[08-Nov-2025 10:57:15 Asia/Bangkok] Dashboard appointments error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause'
[08-Nov-2025 10:57:25 Asia/Bangkok] Dashboard appointments error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause'
[08-Nov-2025 10:57:29 Asia/Bangkok] [Landing] User logged in without dashboard permission - showing landing page with user info
[08-Nov-2025 10:57:29 Asia/Bangkok] [Landing] Displaying landing page for user: admin (role: Admin)
[08-Nov-2025 11:10:19 Asia/Bangkok] [Landing] User logged in without dashboard permission - showing landing page with user info
[08-Nov-2025 11:10:19 Asia/Bangkok] [Landing] Displaying landing page for user: admin (role: Admin)
[08-Nov-2025 11:10:35 Asia/Bangkok] Dashboard appointments error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause'
[10-Nov-2025 17:24:49 Asia/Bangkok] Remember-me login error: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'is_active' in where clause is ambiguous
[10-Nov-2025 17:24:51 Asia/Bangkok] Remember-me login error: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'is_active' in where clause is ambiguous
[10-Nov-2025 17:24:54 Asia/Bangkok] Remember-me login error: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'is_active' in where clause is ambiguous
[10-Nov-2025 17:24:55 Asia/Bangkok] Dashboard appointments error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause'
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] ========== SSO Login Attempt ==========
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Timestamp: 2025-11-10 17:26:34
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Client IP: 110.77.176.148
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 Edg/142.0.0.0
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] JWT validation attempt for token: eyJ0eXAiOiJKV1QiLCJh...
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] JWT signature validation: SUCCESS
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] JWT expiration check: PASSED (expires at 2025-11-11 01:26:33, clock skew: 60s)
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] JWT claims validation: SUCCESS - user_id=1, username=admin
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] JWT audience validation: SKIPPED - No audience claim in token
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] JWT validation: COMPLETE - All checks passed
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] User provisioning: START - username=admin, central_user_id=1, role_id=84
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] User provisioning: FAILED - Error upserting user: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'full_name' in 'field list' | Stack trace: #0 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/sso_login.php(396): PDOStatement->execute(Array)
#1 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/sso_login.php(580): upsert_user(Object(PDO), Array, 84)
#2 {main}
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: START - role_id=84, total_permissions=69
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=dashboard.view, permission_id=102
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=elderly.view, permission_id=197
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=elderly.create, permission_id=95
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=elderly.edit, permission_id=198
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=elderly.delete, permission_id=97
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=patients.view, permission_id=199
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=patients.create, permission_id=200
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=patients.edit, permission_id=201
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=patients.delete, permission_id=202
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=caregivers.view, permission_id=203
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=caregivers.create, permission_id=204
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=caregivers.edit, permission_id=205
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=caregivers.delete, permission_id=206
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=health_records.view, permission_id=207
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=health_records.create, permission_id=208
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=health_records.edit, permission_id=209
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=health_records.delete, permission_id=210
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=vital_signs.view, permission_id=211
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=vital_signs.create, permission_id=212
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=vital_signs.edit, permission_id=213
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=vital_signs.delete, permission_id=214
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=medications.view, permission_id=215
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=medications.create, permission_id=216
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=medications.edit, permission_id=217
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=medications.delete, permission_id=218
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=vaccinations.view, permission_id=109
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=vaccinations.create, permission_id=219
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=vaccinations.edit, permission_id=220
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=vaccinations.delete, permission_id=221
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=chronic.view, permission_id=142
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=chronic.create, permission_id=222
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=chronic.edit, permission_id=223
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=chronic.delete, permission_id=224
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=problems.view, permission_id=225
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=problems.create, permission_id=226
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=problems.edit, permission_id=227
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=problems.delete, permission_id=228
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: FILTERED - permission=allergies.view (not in whitelist)
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: FILTERED - permission=allergies.create (not in whitelist)
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: FILTERED - permission=allergies.edit (not in whitelist)
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: FILTERED - permission=allergies.delete (not in whitelist)
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=geriatric.view, permission_id=107
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=geriatric.create, permission_id=229
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=geriatric.edit, permission_id=230
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=geriatric.delete, permission_id=231
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=appointments.view, permission_id=232
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=appointments.create, permission_id=233
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=appointments.edit, permission_id=234
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=appointments.delete, permission_id=235
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=care_plans.view, permission_id=236
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=care_plans.create, permission_id=237
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=care_plans.edit, permission_id=238
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=care_plans.delete, permission_id=239
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=referrals.view, permission_id=240
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=referrals.create, permission_id=241
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=referrals.edit, permission_id=242
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=referrals.delete, permission_id=243
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=calendar.view, permission_id=244
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=calendar.create, permission_id=245
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=calendar.edit, permission_id=246
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=calendar.delete, permission_id=247
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=reports.view, permission_id=248
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=reports.generate, permission_id=249
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: FILTERED - permission=users.view (not in whitelist)
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: FILTERED - permission=users.create (not in whitelist)
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: FILTERED - permission=users.edit (not in whitelist)
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: FILTERED - permission=users.delete (not in whitelist)
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: FILTERED - permission=settings.view (not in whitelist)
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: FILTERED - permission=settings.edit (not in whitelist)
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Permission sync: COMPLETE - synced=59, filtered=10, failed=0
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Ensuring dashboard.view permission for role_id=84
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Dashboard permission: SUCCESS - dashboard.view granted to role_id=84
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Session management: START - Creating session for user
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Session management: App session created - user_id=1, username=admin
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Session management: Legacy session keys set - permissions_count=69
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Session management: Session ID regenerated for security
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Remember token: Generating token for user_id=1
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Remember token: Cookie set via helper function
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Session management: COMPLETE - Session established successfully
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Redirect: Determining destination URL
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Redirect: Redirecting to landing page (landing will handle dashboard redirect if permitted)
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] SSO Login: SUCCESS - Final redirect destination: https://claoffice.shop/user-permission-system/elderly_care_system/public/landing
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Activity log: FAILED - SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`zkwdpszw_elderly_care_system`.`activity_logs`, CONSTRAINT `fk_log_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT)
[10-Nov-2025 17:26:34 Asia/Bangkok] [SSO] Activity log: SSO login success logged - user_id=1, username=admin
[10-Nov-2025 17:26:34 Asia/Bangkok] [Landing] User has dashboard permission - redirecting to dashboard
[10-Nov-2025 17:26:34 Asia/Bangkok] Dashboard appointments error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause'
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] ========== SSO Login Attempt ==========
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Timestamp: 2025-11-11 12:02:22
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Client IP: 171.4.186.173
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] JWT validation attempt for token: eyJ0eXAiOiJKV1QiLCJh...
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] JWT signature validation: SUCCESS
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] JWT expiration check: PASSED (expires at 2025-11-11 20:02:21, clock skew: 60s)
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] JWT claims validation: SUCCESS - user_id=5, username=admin
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] JWT audience validation: SKIPPED - No audience claim in token
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] JWT validation: COMPLETE - All checks passed
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] User provisioning: START - username=admin, central_user_id=5, role_id=94
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] User provisioning: FAILED - Error upserting user: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'full_name' in 'field list' | Stack trace: #0 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/sso_login.php(396): PDOStatement->execute(Array)
#1 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/sso_login.php(580): upsert_user(Object(PDO), Array, 94)
#2 {main}
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: START - role_id=94, total_permissions=16
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=dashboard.view, permission_id=102
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=elderly.view, permission_id=197
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=elderly.create, permission_id=95
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=elderly.edit, permission_id=198
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=patients.view, permission_id=199
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=patients.create, permission_id=200
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=patients.edit, permission_id=201
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=caregivers.view, permission_id=203
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=health_records.view, permission_id=207
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=vital_signs.view, permission_id=211
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=vital_signs.create, permission_id=212
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=appointments.view, permission_id=232
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=appointments.create, permission_id=233
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=calendar.view, permission_id=244
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=calendar.create, permission_id=245
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=reports.view, permission_id=248
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Permission sync: COMPLETE - synced=16, filtered=0, failed=0
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Ensuring dashboard.view permission for role_id=94
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Dashboard permission: SUCCESS - dashboard.view granted to role_id=94
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Session management: START - Creating session for user
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Session management: App session created - user_id=5, username=admin
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Session management: Legacy session keys set - permissions_count=16
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Session management: Session ID regenerated for security
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Remember token: Generating token for user_id=5
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Remember token: Cookie set via helper function
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Session management: COMPLETE - Session established successfully
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Redirect: Determining destination URL
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Redirect: Redirecting to landing page (landing will handle dashboard redirect if permitted)
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] SSO Login: SUCCESS - Final redirect destination: https://claoffice.shop/user-permission-system/elderly_care_system/public/landing
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Activity log: FAILED - SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`zkwdpszw_elderly_care_system`.`activity_logs`, CONSTRAINT `fk_log_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT)
[11-Nov-2025 12:02:22 Asia/Bangkok] [SSO] Activity log: SSO login success logged - user_id=5, username=admin
[11-Nov-2025 12:02:22 Asia/Bangkok] [Landing] User has dashboard permission - redirecting to dashboard
[11-Nov-2025 12:02:22 Asia/Bangkok] Dashboard appointments error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause'
[24-Nov-2025 21:53:25 Asia/Bangkok] Remember-me login error: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'is_active' in where clause is ambiguous
[24-Nov-2025 21:53:29 Asia/Bangkok] Remember-me login error: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'is_active' in where clause is ambiguous
[24-Nov-2025 21:53:34 Asia/Bangkok] Remember-me login error: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'is_active' in where clause is ambiguous
[24-Nov-2025 21:53:34 Asia/Bangkok] Dashboard appointments error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause'
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] ========== SSO Login Attempt ==========
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Timestamp: 2025-11-24 22:03:28
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Client IP: 223.205.120.76
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36 Edg/143.0.0.0
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] JWT validation attempt for token: eyJ0eXAiOiJKV1QiLCJh...
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] JWT signature validation: SUCCESS
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] JWT expiration check: PASSED (expires at 2025-11-25 06:03:28, clock skew: 60s)
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] JWT claims validation: SUCCESS - user_id=5, username=admin
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] JWT audience validation: SKIPPED - No audience claim in token
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] JWT validation: COMPLETE - All checks passed
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] User provisioning: START - username=admin, central_user_id=5, role_id=94
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] User provisioning: FAILED - Error upserting user: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'full_name' in 'field list' | Stack trace: #0 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/sso_login.php(396): PDOStatement->execute(Array)
#1 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/sso_login.php(580): upsert_user(Object(PDO), Array, 94)
#2 {main}
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: START - role_id=94, total_permissions=16
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=dashboard.view, permission_id=102
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=elderly.view, permission_id=197
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=elderly.create, permission_id=95
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=elderly.edit, permission_id=198
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=patients.view, permission_id=199
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=patients.create, permission_id=200
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=patients.edit, permission_id=201
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=caregivers.view, permission_id=203
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=health_records.view, permission_id=207
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=vital_signs.view, permission_id=211
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=vital_signs.create, permission_id=212
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=appointments.view, permission_id=232
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=appointments.create, permission_id=233
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=calendar.view, permission_id=244
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=calendar.create, permission_id=245
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=reports.view, permission_id=248
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Permission sync: COMPLETE - synced=16, filtered=0, failed=0
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Ensuring dashboard.view permission for role_id=94
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Dashboard permission: SUCCESS - dashboard.view granted to role_id=94
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Session management: START - Creating session for user
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Session management: App session created - user_id=5, username=admin
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Session management: Legacy session keys set - permissions_count=16
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Session management: Session ID regenerated for security
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Remember token: Generating token for user_id=5
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Remember token: Cookie set via helper function
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Session management: COMPLETE - Session established successfully
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Redirect: Determining destination URL
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Redirect: Redirecting to landing page (landing will handle dashboard redirect if permitted)
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] SSO Login: SUCCESS - Final redirect destination: https://claoffice.shop/user-permission-system/elderly_care_system/public/landing
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Activity log: FAILED - SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`zkwdpszw_elderly_care_system`.`activity_logs`, CONSTRAINT `fk_log_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT)
[24-Nov-2025 22:03:28 Asia/Bangkok] [SSO] Activity log: SSO login success logged - user_id=5, username=admin
[24-Nov-2025 22:03:28 Asia/Bangkok] [Landing] User has dashboard permission - redirecting to dashboard
[24-Nov-2025 22:03:28 Asia/Bangkok] Dashboard appointments error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause'
[24-Nov-2025 22:28:09 Asia/Bangkok] [SSO] ========== SSO Login Attempt ==========
[24-Nov-2025 22:28:09 Asia/Bangkok] [SSO] Timestamp: 2025-11-24 22:28:09
[24-Nov-2025 22:28:09 Asia/Bangkok] [SSO] Client IP: 223.205.120.76
[24-Nov-2025 22:28:09 Asia/Bangkok] [SSO] User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36 Edg/143.0.0.0
[24-Nov-2025 22:28:09 Asia/Bangkok] [SSO] JWT validation attempt for token: eyJ0eXAiOiJKV1QiLCJh...
[24-Nov-2025 22:28:09 Asia/Bangkok] [SSO] JWT signature validation: SUCCESS
[24-Nov-2025 22:28:09 Asia/Bangkok] [SSO] JWT expiration check: PASSED (expires at 2025-11-25 06:28:09, clock skew: 60s)
[24-Nov-2025 22:28:09 Asia/Bangkok] [SSO] JWT claims validation: SUCCESS - user_id=5, username=admin
[24-Nov-2025 22:28:09 Asia/Bangkok] [SSO] JWT audience validation: SKIPPED - No audience claim in token
[24-Nov-2025 22:28:09 Asia/Bangkok] [SSO] JWT validation: COMPLETE - All checks passed
[24-Nov-2025 22:28:09 Asia/Bangkok] [SSO] User provisioning: START - username=admin, central_user_id=5, role_id=94
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] User provisioning: FAILED - Error upserting user: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'full_name' in 'field list' | Stack trace: #0 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/sso_login.php(396): PDOStatement->execute(Array)
#1 /home/zkwdpszw/public_html/user-permission-system/elderly_care_system/public/sso_login.php(580): upsert_user(Object(PDO), Array, 94)
#2 {main}
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: START - role_id=94, total_permissions=16
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=dashboard.view, permission_id=102
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=elderly.view, permission_id=197
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=elderly.create, permission_id=95
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=elderly.edit, permission_id=198
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=patients.view, permission_id=199
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=patients.create, permission_id=200
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=patients.edit, permission_id=201
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=caregivers.view, permission_id=203
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=health_records.view, permission_id=207
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=vital_signs.view, permission_id=211
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=vital_signs.create, permission_id=212
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=appointments.view, permission_id=232
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=appointments.create, permission_id=233
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=calendar.view, permission_id=244
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=calendar.create, permission_id=245
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: GRANTED - permission=reports.view, permission_id=248
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Permission sync: COMPLETE - synced=16, filtered=0, failed=0
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Ensuring dashboard.view permission for role_id=94
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Dashboard permission: SUCCESS - dashboard.view granted to role_id=94
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Session management: START - Creating session for user
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Session management: App session created - user_id=5, username=admin
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Session management: Legacy session keys set - permissions_count=16
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Session management: Session ID regenerated for security
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Remember token: Generating token for user_id=5
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Remember token: Cookie set via helper function
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Session management: COMPLETE - Session established successfully
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Redirect: Determining destination URL
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Redirect: Redirecting to landing page (landing will handle dashboard redirect if permitted)
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] SSO Login: SUCCESS - Final redirect destination: https://claoffice.shop/user-permission-system/elderly_care_system/public/landing
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Activity log: FAILED - SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`zkwdpszw_elderly_care_system`.`activity_logs`, CONSTRAINT `fk_log_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT)
[24-Nov-2025 22:28:10 Asia/Bangkok] [SSO] Activity log: SSO login success logged - user_id=5, username=admin
[24-Nov-2025 22:28:10 Asia/Bangkok] [Landing] User has dashboard permission - redirecting to dashboard
[24-Nov-2025 22:28:10 Asia/Bangkok] Dashboard appointments error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause'
