lib/userslib fix for PostGres
- Status
- Closed
- Subject
- lib/userslib fix for PostGres
- Version
- 1.9.x
- Category
- Error
- Patch
- Resolution status
- Fixed or Solved
- Submitted by
- wbeaver2
- Volunteered to solve
- wbeaver2
- Lastmod by
- amette
- Rating
- Description
- The string "isUsers" in line 1013, lib/userslib.php, must be enclosed in Backticks, else query will return postgres error when processed (because postgres will interpret the column name as "isuser" instead of "isUser")
- Solution
Replace the line:
$query = "delete from `tiki_newsletter_subscriptions` where `email`=? and isUser=?";
with the line:
$query = "delete from `tiki_newsletter_subscriptions` where `email`=? and `isUser`=?"
- Importance
- 2
- Priority
- 10
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 343
- Created
- Thursday 22 September, 2005 17:47:09 UTC
by Unknown - LastModif
- Tuesday 11 October, 2005 13:34:24 UTC