[Top][All Lists]
[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/