bugphpGroupWare - Bugs: bug #12017, after changing address book view...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #12017: after changing address book view settings, mysql causes error

Submitted by:  None
Submitted on:  Fri 18 Feb 2005 02:21:25 AM UTC  
 
Item Group: 0.9.16.005Category: API - Preferences
Severity: 3 - NormalPriority: 6
Status: FixedPrivacy: Public
Assigned to: Jonathan Rivera <jarg>Open/Closed: Closed
Component Version: ZIPOperating System: GNU/Linux - RedHat/Fedora
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Thu 15 Sep 2005 05:42:38 PM UTC, comment #1:

This has been corrected in CVS.

To grab a complete update of all fixes:

1) Check to see if you have cvs installed: 'cvs --help'.
1a) If not, install a copy of cvs-cli from your favorite
distro.

2) Then just type:
'cd <your phpgroupware dir>; cvs update -dP'.

You can do step 2 as many times in a day as you wish, and
will always get the most current bug fixes.

Thanks,

Jonathan Rivera <jarg>In charge of this item.
Fri 18 Feb 2005 02:21:25 AM UTC, original submission:

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: -unavailable-

--Jeff

Anonymous

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 3 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Thu 29 Dec 2005 03:37:39 PM UTCjargOpen/ClosedOpen=>Closed
Thu 15 Sep 2005 05:42:37 PM UTCjargStatusNone=>Fixed
Mon 21 Feb 2005 09:58:00 PM UTCskwashdAssigned toNone=>jarg

Back to the top


Powered by Savane 3.1-cleanup1