bugphpGroupWare - Bugs: bug #7277, search does not work

 
 

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

bug #7277: search does not work

Submitted by:  None
Submitted on:  Thu 15 Jan 2004 09:46:34 PM UTC  
 
Item Group: 0.9.16RC2Category: addressbook
Severity: 3 - NormalPriority: 5 - Normal
Status: FixedPrivacy: Public
Assigned to: Jonathan Rivera <jarg>Open/Closed: Closed
Component Version: SVNOperating System: GNU/Linux - Debian
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Sun 25 Jan 2004 07:12:06 AM UTC, comment #3:

fixed - patch applied

Dave Hall <skwashd>
Project Administrator
Sun 25 Jan 2004 01:06:11 AM UTC, comment #2:

is there still an error?

Jonathan Rivera <jarg>In charge of this item.
Wed 21 Jan 2004 10:36:53 PM UTC, comment #1:

I have a patch to apply to fix this. Will post a follow up when done.

Dave Hall <skwashd>
Project Administrator
Thu 15 Jan 2004 09:46:34 PM UTC, original submission:

Warning: Invalid argument supplied for foreach() in /var/www/html/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php on line 3175

Warning: Missing argument 2 for has() in /var/www/html/phpgroupware/phpgwapi/inc/class.sql.inc.php on line 128
Database error: Invalid SQL: SELECT count(person_id) AS count_persons FROM phpgw_contact AS contact_central LEFT JOIN phpgw_contact_addr AS contact_addr ON contact_addr.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 (-3,3)) OR contact_central.owner = 3) AND (contact_addr.preferred = 'Y' OR contact_addr.contact_addr_id IS NULL) ) AND (UPPER(contact_person.first_name) LIKE '%test%' OR UPPER(contact_person.last_name) LIKE '%test%' OR UPPER(contact_person.department) LIKE '%test%' OR UPPER(contact_person.title) LIKE '%test%' OR UPPER(contact_addr.add1) LIKE '%test%' OR UPPER(contact_addr.city) LIKE '%test%' OR UPPER(contact_central.owner) LIKE '%test%' OR UPPER(contact_central.contact_id) LIKE '%test%' OR UPPER(Array) LIKE '%%'))
MySQL Error: 1054 (Unknown column 'Array' in 'where clause')

File: /var/www/html/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php
Line: 1339

Session halted.

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

Date Changed By Updated Field Previous Value => Replaced By
Sun 25 Jan 2004 07:12:06 AM UTCskwashdStatusNone=>Fixed
  Assigned toskwashd=>jarg
  Open/ClosedOpen=>Closed
Wed 21 Jan 2004 10:36:53 PM UTCskwashdAssigned toNone=>skwashd

Back to the top


Powered by Savane 3.1-cleanup1