I just spent today tracking down why the 'one time url' that gets sent out to new users wasn't working ... most often then not, they would click on it, and end up being redirected back to the /home page ... other times, if really lucky, you'd get to the password change screen, but with a big error:
====
User error: SQL ERROR [ postgres ]
ERROR: column "ScrappyGmail" does not exist LINE 2: WHERE username = "ScrappyGmail" ^ []
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists. in dbal->sql_error() (line 707 of /usr/local/www/d_admin/bestseniorsinfo.com/www/phpBB3/includes/db/dbal.php).
====
What I wasn't cluing into was that the [WHERE username = "ScrappyGmail"] part was using doublequotes, which, under PostgreSQL means 'treat this as a case sensitive field name', not 'treat this as a string' ...
The fix is simple, and patch attached ... hopefully someone can get this committed before next -dev (or -alpha) release ... this is against the latest alpha3 ...
| Comment | File | Size | Author |
|---|---|---|---|
| PhpbbVBridgeApp.php_.patch | 960 bytes | hubScrappy |
Comments
Comment #1
fizk commentedAdding todo tag.