538248 – www-app/postfixadmin-2.3.7 - column "t" does not exist UPDATE alias SET active=t

Bug 538248 - www-app/postfixadmin-2.3.7 - column "t" does not exist UPDATE alias SET active=t

Summary: www-app/postfixadmin-2.3.7 - column "t" does not exist UPDATE alias SET active=t

Status:	RESOLVED FIXED

Alias:	None

Product:	Gentoo Linux
Classification:	Unclassified
Component:	Current packages (show other bugs)
Hardware:	All Linux

Importance:	Normal normal (vote)
Assignee:	Gentoo Web Application Packages Maintainers

URL:	http://sourceforge.net/p/postfixadmin...
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2015-01-30 14:57 UTC by Maxim Britov
Modified:	2017-06-08 10:05 UTC (History)
CC List:	0 users

See Also:
Package list:
Runtime testing required:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Maxim Britov 2015-01-30 14:57:16 UTC

upstream bug: http://sourceforge.net/p/postfixadmin/bugs/311/
upstream fix: http://sourceforge.net/p/postfixadmin/code/1673/#diff-1

missed '' around $sqlActive in postfixadmin/edit-mailbox.php:165
$result = db_query ("UPDATE $table_alias SET active=$sqlActive WHERE address='$fUsername' AND domain='$fDomain'");

String above fail because SET active=t is wrong, should be SET active='t'


Reproducible: Always

Comment 1 Tomáš Mózes 2017-06-08 10:05:08 UTC

Fixed with version 2.3.8 in tree.