[Phpgroupware-tracker] [bugs #12017] after changing address book view settings, mysql causes error

[anonymous]

URL:
  <http://savannah.gnu.org/bugs/?func=detailitem&item_id=12017>

                 Summary: after changing address book view settings, mysql
causes error
                 Project: phpGroupWare
            Submitted by: None
            Submitted on: Thu 02/17/2005 at 21:21
              Item Group: 0.9.16.005
                Category: API - Preferences
                Severity: 5 - Average
                Priority: 6
                  Status: None
                 Privacy: Public
             Assigned to: None
             Open/Closed: Open
       Component Version: ZIP
        Platform Version: GNU/Linux - RedHat/Fedora
         Reproducibility: Every Time
         Planned Release: None
           Fixed Release: 

    _______________________________________________________

Details:

Hello,

I was logged in as a normal user (not admin) and changed my address book
preferences. I added "home phone" to the selected fields list and then
clicked save. No problem. Now when I click on address book I get the
following mysql error:



atabase error: Invalid SQL: SELECT contact_central.owner AS owner,
contact_central.contact_id AS contact_id FROM phpgw_contact AS
contact_central WHERE (contact_central.contact_type_id = 1 AND
((contact_central.access = 'public' AND contact_central.owner IN (1,5,4,3,6))
OR contact_central.owner = 5) ) ORDER BY last_name LIMIT 15

MySQL Error: 1054 (Unknown column 'last_name' in 'order clause')



File:
/home/ultimate/public_html/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php

Line: 1087



Session halted. 



This only happens on my account. Other users can access address book with no
problems and no errors. If you have questions, email me:
address@hidden



--Jeff






    _______________________________________________________

This item URL is:

  <http://savannah.gnu.org/bugs/?func=detailitem&item_id=12017>

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