diff options
| author | Grant Limberg <[email protected]> | 2021-06-04 11:22:30 -0700 |
|---|---|---|
| committer | Grant Limberg <[email protected]> | 2021-06-04 11:22:30 -0700 |
| commit | 1dcfc03cbce0142cb40f26e5bc2ecdd7543de3ad (patch) | |
| tree | 50e09bea61c1ee66bb17018ac812e9598399c841 /controller/PostgreSQL.cpp | |
| parent | 0702e581a1a75223c47c87ab1dadc998c4a13c97 (diff) | |
another query fix
Diffstat (limited to 'controller/PostgreSQL.cpp')
| -rw-r--r-- | controller/PostgreSQL.cpp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/controller/PostgreSQL.cpp b/controller/PostgreSQL.cpp index 630143ad..743c510a 100644 --- a/controller/PostgreSQL.cpp +++ b/controller/PostgreSQL.cpp @@ -333,7 +333,7 @@ std::string PostgreSQL::getSSOAuthURL(const nlohmann::json &member) // find an unused nonce, if one exists. pqxx::result r = w.exec_params("SELECT nonce FROM ztc_sso_expiry " "WHERE network_id = $1 AND member_id = $2 " - "AND authentication_expiry_time IS NULL AND ((NOW() AT TIME ZONE 'UTC') <= nonce_expiry", + "AND authentication_expiry_time IS NULL AND ((NOW() AT TIME ZONE 'UTC') <= nonce_expiry)", networkId, memberId); if (r.size() == 1) { |