Fatal error: Uncaught PDOException: SQLSTATE[42703]: Undefined column: 7 ERROR: column tc.employee_id does not exist
LINE 1: ...ficates" AS "tc" INNER JOIN "employees" AS "e" ON tc.employe...
^ in /var/www/TAF/api/utils/DB.php:191
Stack trace:
#0 /var/www/TAF/api/utils/DB.php(191): PDOStatement->execute()
#1 /var/www/TAF/api/utils/DB.php(210): Core\DB->runQuery()
#2 /var/www/TAF/api/utils/QueryBuilder.php(239): Core\DB->select()
#3 /var/www/TAF/cli/CertificateExpiry.php(22): Core\QueryBuilder->get()
#4 {main}
Next PDOException: SQL Error: SQLSTATE[42703]: Undefined column: 7 ERROR: column tc.employee_id does not exist
LINE 1: ...ficates" AS "tc" INNER JOIN "employees" AS "e" ON tc.employe...
^ | Query: SELECT tc.id, tc.employee_id, tc.expires_at, tc.course_id, e.email FROM "training_certificates" AS "tc" INNER JOIN "employees" AS "e" ON tc.employee_id = e.id WHERE "tc"."renewal_required" = ? AND "tc"."expires_at" >= ? AND "tc"."expires_at" <= ? in /var/www/TAF/api/utils/DB.php:196
Stack trace:
#0 /var/www/TAF/api/utils/DB.php(210): Core\DB->runQuery()
#1 /var/www/TAF/api/utils/QueryBuilder.php(239): Core\DB->select()
#2 /var/www/TAF/cli/CertificateExpiry.php(22): Core\QueryBuilder->get()
#3 {main}
thrown in /var/www/TAF/api/utils/DB.php on line 196