#41 Postgresql 8.1 causes SQL errors

[Anonymous]

I installed versions 0.9 & 0.85 of helpmeict with:

httpd-2.0.55
php-5.0.5
pgsql-8.1.0

When entering a new issue an SQL error stating that
vw_users was not in the FROM clause.

This can be fixed by altering newissue.php, however
this is only one of several places which need the fix.

Original:
(SELECT DISTINCT id,name FROM vw_UserTypes WHERE
active=1 AND vw_Users.available=1 AND usertypesortorder
IN (2,3,4) AND id>0 AND site=$site ORDER BY name);")

Patched:
(SELECT DISTINCT id,name FROM vw_UserTypes vw_Users
WHERE active=1 AND vw_Users.available=1 AND
usertypesortorder IN (2,3,4) AND id>0 AND site=$site
ORDER BY name);")

Downgrading to pgsql-8.0.4 fixed the problem without
modifing the script.

Steve Atkinson
atn@fallibroome.cheshire.sch.uk

[Michael Stilson Jr]

Logged In: YES
user_id=597323
Originator: NO

work-around in postgres 8.1.x

change the value of "add_missing_from" from "off" to "on" in your postgresql.conf

fix in postgres 8.1.x

author correct sql statements.