Menu

#26 SQL Error

open
nobody
None
5
2010-12-20
2010-12-20
yilez
No

Probably not set Postgres up correctly, but I get the following error when I click "new issue..."

Fatal Error: SQL Query Failed.

(SELECT id,name FROM tbl_Users WHERE id=0) UNION (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=2 ORDER BY name);

This could be because there is no valid connection, or because the query is incorrect.

Discussion


Log in to post a comment.