08-29-2018, 05:10 PM
The problem is related to the last_verify column in the database. We set this to timestamp, which means most databases are updating this on every action. If the user logs in, or is modified before they verify, it renders the verification URL invalid. The fix for it is running the following SQL:
ALTER TABLE users DROP COLUMN vericode_expiry;
ALTER TABLE users ADD COLUMN vericode_expiry datetime;
Thank you,
Brandin.
ALTER TABLE users DROP COLUMN vericode_expiry;
ALTER TABLE users ADD COLUMN vericode_expiry datetime;
Thank you,
Brandin.