Bug 538248

Summary:	www-app/postfixadmin-2.3.7 - column "t" does not exist UPDATE alias SET active=t
Product:	Gentoo Linux	Reporter:	Maxim Britov <maxbritov>
Component:	Current packages	Assignee:	Gentoo Web Application Packages Maintainers <web-apps>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	Normal
Version:	unspecified
Hardware:	All
OS:	Linux
URL:	http://sourceforge.net/p/postfixadmin/bugs/311/
Whiteboard:
Package list:		Runtime testing required:	---

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.