phpgroupware-tracker
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-tracker] [bug #5172] Sort order error


From: nobody
Subject: [Phpgroupware-tracker] [bug #5172] Sort order error
Date: Tue, 09 Sep 2003 20:06:26 -0400
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3.1) Gecko/20030618 Debian/1.3.1-3

=================== BUG #5172: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5172&group_id=509

Changes by: Dave Hall <address@hidden>
Date: Wed 09/10/03 at 10:06 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
         Assigned to | None                      | alexbsa




=================== BUG #5172: FULL BUG SNAPSHOT ===================


Submitted by: None                    Project: phpGroupWare                 
Submitted on: Wed 09/10/03 at 06:00
Category:  addressbook                Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  None                       
Resolution:  None                     Assigned to:  alexbsa                 
Status:  Open                         Component Version:  CVS               
Platform Version:  None               Reproducibility:  None                

Summary:  Sort order error

Original Submission:  Clicking on view_organization tab on main ab screen after 
clicking on a view_person table header (ie lastname) to sort records by that 
column results in a SQL error



The ORDER BY criteria isn't being cleared and in this example the error says:

Database error: Invalid SQL: SELECT contact_org.name AS org_name, 
contact_addr.add1 AS addr_add1, contact_addr.city AS addr_city, 
contact_central.owner AS owner, contact_central.contact_id AS contact_id FROM 
phpgw_contact_addr AS contact_addr RIGHT JOIN phpgw_contact AS contact_central 
ON contact_central.contact_id = contact_addr.contact_id LEFT JOIN 
phpgw_contact_org AS contact_org ON contact_org.org_id = 
contact_central.contact_id WHERE contact_central.contact_type_id = '28' ORDER 
BY per_last_name LIMIT 100

PostgreSQL Error: 1 (ERROR: Attribute "per_last_name" not found )



File: /home/htdocs/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php

Line: 837



No Followups Have Been Posted


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5172&group_id=509

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/





reply via email to

[Prev in Thread] Current Thread [Next in Thread]