PDOException: SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: character varying < integer
LINE 1: ...= LOCALTIMESTAMP AND edate IS NOT NULL  AND edate < 20240918...
                                                             ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts. in /home/tristate/includes/classes/core_lib/PostgreSQLDB.php on line 107

Call Stack:
    0.0021     366344   1. {main}() /home/tristate/html/rebate_links.php:0
    0.0021     366720   2. require_once('/home/tristate/html/controller.php') /home/tristate/html/rebate_links.php:3
    0.0021     367224   3. require_once('/home/tristate/includes/public_controller.php') /home/tristate/html/controller.php:4
    0.0027     379880   4. ActionRebateListPage->execute() /home/tristate/includes/public_controller.php:18
    0.0211     421240   5. RebateDAO->fetchAllRebates($filter = 'expired') /home/tristate/includes/classes/action/ActionRebateListPage.php:17
    0.0212     426456   6. QueryManager->fetchStatementResults($sql = ' SELECT DISTINCT p.ts_id, p.url_path, m.name man_name, p.name, p.rebate, p.rebate_url, p.rebate_file, p.edate, to_char(p.begin_rebate_dt, \'MM/DD/YYYY\') begin_rebate_dt  FROM  product p, manufacturer m  WHERE p.mfr=m.id AND p.ts_show = \'1\' AND p.rebate > 0  AND  (rebate_url IS NOT NULL OR rebate_file IS NOT NULL )  AND p.begin_rebate_dt <= LOCALTIMESTAMP AND edate IS NOT NULL  AND edate < 20240918 AND edate > :end  ORDER BY m.name ', $params = ['end' => '20240818']) /home/tristate/includes/classes/dao/RebateDAO.php:253
    0.0212     429904   7. PostgreSQLDB->execute($stmt = class PDOStatement { public string $queryString = ' SELECT DISTINCT p.ts_id, p.url_path, m.name man_name, p.name, p.rebate, p.rebate_url, p.rebate_file, p.edate, to_char(p.begin_rebate_dt, \'MM/DD/YYYY\') begin_rebate_dt  FROM  product p, manufacturer m  WHERE p.mfr=m.id AND p.ts_show = \'1\' AND p.rebate > 0  AND  (rebate_url IS NOT NULL OR rebate_file IS NOT NULL )  AND p.begin_rebate_dt <= LOCALTIMESTAMP AND edate IS NOT NULL  AND edate < 20240918 AND edate > :end  ORDER BY m.name ' }) /home/tristate/includes/classes/core_lib/QueryManager.php:135
    0.0212     430912   8. PDOStatement->execute() /home/tristate/includes/classes/core_lib/PostgreSQLDB.php:107


Variables in local scope (#7):
  $QueryEntity = class QueryEntity { public $type = 'EXECUTE'; public $data = '( SELECT DISTINCT p.ts_id, p.url_path, m.name man_name, p.name, p.rebate, p.rebate_url, p.rebate_file, p.edate, to_char(p.begin_rebate_dt, \'MM/DD/YYYY\') begin_rebate_dt  FROM  product p, manufacturer m  WHERE p.mfr=m.id AND p.ts_show = \'1\' AND p.rebate > 0  AND  (rebate_url IS NOT NULL OR rebate_file IS NOT NULL )  AND p.begin_rebate_dt <= LOCALTIMESTAMP AND edate IS NOT NULL  AND edate < 20240918 AND edate > :end  ORDER BY m.name ) SELECT DISTINCT p.ts_id, p.url_path, m.name man_name, p.name, p.rebate, p.r'...; public $startTime = 1726688455; public $endTime = '' }
  $result = *uninitialized*
  $stmt = class PDOStatement { public string $queryString = ' SELECT DISTINCT p.ts_id, p.url_path, m.name man_name, p.name, p.rebate, p.rebate_url, p.rebate_file, p.edate, to_char(p.begin_rebate_dt, \'MM/DD/YYYY\') begin_rebate_dt  FROM  product p, manufacturer m  WHERE p.mfr=m.id AND p.ts_show = \'1\' AND p.rebate > 0  AND  (rebate_url IS NOT NULL OR rebate_file IS NOT NULL )  AND p.begin_rebate_dt <= LOCALTIMESTAMP AND edate IS NOT NULL  AND edate < 20240918 AND edate > :end  ORDER BY m.name ' }


Fatal error: Uncaught PDOException: SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: character varying < integer
LINE 1: ...= LOCALTIMESTAMP AND edate IS NOT NULL  AND edate < 20240918...
                                                             ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts. in /home/tristate/includes/classes/core_lib/PostgreSQLDB.php on line 107

PDOException: SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: character varying < integer
LINE 1: ...= LOCALTIMESTAMP AND edate IS NOT NULL  AND edate < 20240918...
                                                             ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts. in /home/tristate/includes/classes/core_lib/PostgreSQLDB.php on line 107

Call Stack:
    0.0021     366344   1. {main}() /home/tristate/html/rebate_links.php:0
    0.0021     366720   2. require_once('/home/tristate/html/controller.php') /home/tristate/html/rebate_links.php:3
    0.0021     367224   3. require_once('/home/tristate/includes/public_controller.php') /home/tristate/html/controller.php:4
    0.0027     379880   4. ActionRebateListPage->execute() /home/tristate/includes/public_controller.php:18
    0.0211     421240   5. RebateDAO->fetchAllRebates($filter = 'expired') /home/tristate/includes/classes/action/ActionRebateListPage.php:17
    0.0212     426456   6. QueryManager->fetchStatementResults($sql = ' SELECT DISTINCT p.ts_id, p.url_path, m.name man_name, p.name, p.rebate, p.rebate_url, p.rebate_file, p.edate, to_char(p.begin_rebate_dt, \'MM/DD/YYYY\') begin_rebate_dt  FROM  product p, manufacturer m  WHERE p.mfr=m.id AND p.ts_show = \'1\' AND p.rebate > 0  AND  (rebate_url IS NOT NULL OR rebate_file IS NOT NULL )  AND p.begin_rebate_dt <= LOCALTIMESTAMP AND edate IS NOT NULL  AND edate < 20240918 AND edate > :end  ORDER BY m.name ', $params = ['end' => '20240818']) /home/tristate/includes/classes/dao/RebateDAO.php:253
    0.0212     429904   7. PostgreSQLDB->execute($stmt = class PDOStatement { public string $queryString = ' SELECT DISTINCT p.ts_id, p.url_path, m.name man_name, p.name, p.rebate, p.rebate_url, p.rebate_file, p.edate, to_char(p.begin_rebate_dt, \'MM/DD/YYYY\') begin_rebate_dt  FROM  product p, manufacturer m  WHERE p.mfr=m.id AND p.ts_show = \'1\' AND p.rebate > 0  AND  (rebate_url IS NOT NULL OR rebate_file IS NOT NULL )  AND p.begin_rebate_dt <= LOCALTIMESTAMP AND edate IS NOT NULL  AND edate < 20240918 AND edate > :end  ORDER BY m.name ' }) /home/tristate/includes/classes/core_lib/QueryManager.php:135
    0.0212     430912   8. PDOStatement->execute() /home/tristate/includes/classes/core_lib/PostgreSQLDB.php:107


Variables in local scope (#7):
  $QueryEntity = class QueryEntity { public $type = 'EXECUTE'; public $data = '( SELECT DISTINCT p.ts_id, p.url_path, m.name man_name, p.name, p.rebate, p.rebate_url, p.rebate_file, p.edate, to_char(p.begin_rebate_dt, \'MM/DD/YYYY\') begin_rebate_dt  FROM  product p, manufacturer m  WHERE p.mfr=m.id AND p.ts_show = \'1\' AND p.rebate > 0  AND  (rebate_url IS NOT NULL OR rebate_file IS NOT NULL )  AND p.begin_rebate_dt <= LOCALTIMESTAMP AND edate IS NOT NULL  AND edate < 20240918 AND edate > :end  ORDER BY m.name ) SELECT DISTINCT p.ts_id, p.url_path, m.name man_name, p.name, p.rebate, p.r'...; public $startTime = 1726688455; public $endTime = '' }
  $result = *uninitialized*
  $stmt = class PDOStatement { public string $queryString = ' SELECT DISTINCT p.ts_id, p.url_path, m.name man_name, p.name, p.rebate, p.rebate_url, p.rebate_file, p.edate, to_char(p.begin_rebate_dt, \'MM/DD/YYYY\') begin_rebate_dt  FROM  product p, manufacturer m  WHERE p.mfr=m.id AND p.ts_show = \'1\' AND p.rebate > 0  AND  (rebate_url IS NOT NULL OR rebate_file IS NOT NULL )  AND p.begin_rebate_dt <= LOCALTIMESTAMP AND edate IS NOT NULL  AND edate < 20240918 AND edate > :end  ORDER BY m.name ' }