bugphpGroupWare - Bugs: bug #7910, Search for Person produces error

 
 

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

bug #7910: Search for Person produces error

Submitted by:  Bob Crandell <BobCrandell>
Submitted on:  Wed 25 Feb 2004 10:37:22 PM UTC  
 
Item Group: 0.9.16RC3Category: addressbook
Severity: 3 - NormalPriority: 5 - Normal
Status: FixedPrivacy: Public
Assigned to: NoneOpen/Closed: Closed
Component Version: SVNOperating System: GNU/Linux - Other
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Thu 26 Feb 2004 12:27:00 AM 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,

Alejandro Borges (lex) <alexbsa>
Wed 25 Feb 2004 10:37:22 PM UTC, original submission:

This is the error:
Database error: Invalid SQL: SELECT count(person_id) AS count_persons FROM phpgw_contact AS contact_central LEFT JOIN phpgw_contact_comm AS contact_comm ON contact_comm.contact_id = contact_central.contact_id INNER JOIN phpgw_contact_person AS contact_person ON contact_person.person_id = contact_central.contact_id WHERE ((( ((contact_central.access = 'public' AND contact_central.owner IN (595483,599437,599438,599443,599444,599449,599454,599441,599450,599456,599439)) OR contact_central.owner = 599438) AND ( (contact_central.cat_id = '8' OR UPPER(contact_central.cat_id) LIKE '%,8,%') OR (contact_central.cat_id = '19' OR UPPER(contact_central.cat_id) LIKE '%,19,%') OR (contact_central.cat_id = '20' OR UPPER(contact_central.cat_id) LIKE '%,20,%') )) AND (UPPER(contact_person.per_full_name) LIKE '%susan%' OR UPPER(contact_central.owner) LIKE '%susan%' OR UPPER(contact_central.contact_id) LIKE '%susan%')) AND ((UPPER(contact_comm.comm_data) LIKE '%susan%' AND contact_comm.comm_descr_id = 3) OR (UPPER(contact_comm.comm_data) LIKE '%susan%' AND contact_comm.comm_descr_id = 4)))
MySQL Error: 1054 (Unknown column 'contact_person.per_full_name' in 'where clause')

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

Session halted.

Bob Crandell <BobCrandell>

 

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 2 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Thu 26 Feb 2004 12:35:25 AM UTCalexbsaStatusNone=>Fixed
  Open/ClosedOpen=>Closed

Back to the top


Powered by Savane 3.1-cleanup1