Bug 122148 – some errors in postfixadmin with postgresl 8.0.4

• Status: RESOLVED FIXED
• Product: Gentoo Linux

[Description Sergio Bevilacqua 2006-02-08 10:14:17 UTC]

there's a format error in postfixadmin 2.0.1 when it's used with postgresl 8.0.4
in the file templates/admin_list-admin.tpl it passes an int value to an boolean field

[Comment 1 Sergio Bevilacqua 2006-02-08 10:16:53 UTC]

Created attachment 79241 [details, diff]
this is the patch for templates/admin_list-admin.tpl

this patch corrects data type passed in templates/admin_list-admin.tpl

[Comment 2 Jakub Moc (RETIRED) 2006-02-09 07:38:30 UTC]

*** Bug 122253 has been marked as a duplicate of this bug. ***

[Comment 3 Sergio Bevilacqua 2006-02-09 07:41:59 UTC]

Created attachment 79322 [details, diff]
patch for SQL code

[Comment 4 Gunnar Wrobel (RETIRED) 2006-02-12 00:50:29 UTC]

Thanks for the patches. I should have actually tested postgres support before.

I was able to integrate the patches into the ebuild and tried to use the app with postgres but there was still a problem. The backup.php uses the SQL command "SHOW CREATE TABLE" that will fail with postgres. As far as I can tell from googling around, there is no easy fix for this.

Since I can't leave the postgres support in the ebuild if that leads to a broken app I had to remove the use flag.

I did add a postfixadmin ebuild that includes your patches to our overlay though. It can be found here:

http://svn.gnqs.org/projects/gentoo-webapps-overlay/browser/experimental/www-apps/postfixadmin

Thanks again for your contribution!