phpgroupware-tracker
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-tracker] [Bug #2951] javascript error in mail/addressbook


From: nobody
Subject: [Phpgroupware-tracker] [Bug #2951] javascript error in mail/addressbook when switched to javascript
Date: Wed, 26 Mar 2003 17:09:14 -0500

=================== BUG #2951: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=2951&group_id=509

Changes by: Dave Hall <address@hidden>
Date: Thu 03/27/03 at 09:09 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
           Bug Group | None                      | 0.9.14.002 release
         Assigned to | None                      | alexbsa
                  CC |                           | address@hidden




=================== BUG #2951: FULL BUG SNAPSHOT ===================


Submitted by: None                    Project: phpGroupWare                 
Submitted on: Thu 03/27/03 at 08:04
Category:  email                      Bug Group:  0.9.14.002 release        
Severity:  5 - Major                  Priority:  None                       
Resolution:  None                     Assigned to:  alexbsa                 
Status:  Open                         Component Version:  None              
Platform Version:  None               Reproducibility:  Every Time          

Summary:  javascript error in mail/addressbook when switched to javascript

Original Submission:   When i'm switching to javascript-addressbook in my email 
preferences, i get the
> following error instead of an addressbook:
> 
> ------------
> Database error: Invalid SQL: SELECT * FROM phpgw_addressbook WHERE ( UPPER(fn)
> LIKE UPPER('%%') OR UPPER(n_given) LIKE UPPER('%%') OR UPPER(n_family) LIKE 
> UPPER
> ('%%') OR UPPER(n_middle) LIKE UPPER('%%') OR UPPER(n_prefix) LIKE 
> UPPER('%%') OR
> UPPER(n_suffix) LIKE UPPER('%%') OR UPPER(sound) LIKE UPPER('%%') OR 
> UPPER(bday)
> LIKE UPPER('%%') OR UPPER(note) LIKE UPPER('%%') OR UPPER(tz) LIKE 
> UPPER('%%') OR
> UPPER(geo) LIKE UPPER('%%') OR UPPER(url) LIKE UPPER('%%') OR UPPER(pubkey) 
> LIKE
> UPPER('%%') OR UPPER(org_name) LIKE UPPER('%%') OR UPPER(org_unit) LIKE 
> UPPER('%
> %') OR UPPER(title) LIKE UPPER('%%') OR UPPER(adr_one_street) LIKE 
> UPPER('%%') OR
> UPPER(adr_one_locality) LIKE UPPER('%%') OR UPPER(adr_one_region) LIKE 
> UPPER('%%')
> OR UPPER(adr_one_postalcode) LIKE UPPER('%%') OR UPPER(adr_one_countryname) 
> LIKE
> UPPER('%%') OR UPPER(adr_one_type) LIKE UPPER('%%') OR UPPER(label) LIKE 
> UPPER('%
> %') OR UPPER(adr_two_street) LIKE UPPER('%%') OR UPPER(adr_two_locality) LIKE 
> UPPER
> ('%%') OR UPPER(adr_two_region) LIKE UPPER('%%') OR UPPER(adr_two_postalcode) 
> LIKE
> UPPER('%%') OR UPPER(adr_two_countryname) LIKE UPPER('%%') OR 
> UPPER(adr_two_type)
> LIKE UPPER('%%') OR UPPER(tel_work) LIKE UPPER('%%') OR UPPER(tel_home) LIKE 
> UPPER
> ('%%') OR UPPER(tel_voice) LIKE UPPER('%%') OR UPPER(tel_fax) LIKE 
> UPPER('%%') OR
> UPPER(tel_msg) LIKE UPPER('%%') OR UPPER(tel_cell) LIKE UPPER('%%') OR UPPER
> (tel_pager) LIKE UPPER('%%') OR UPPER(tel_bbs) LIKE UPPER('%%') OR UPPER
> (tel_modem) LIKE UPPER('%%') OR UPPER(tel_car) LIKE UPPER('%%') OR 
> UPPER(tel_isdn)
> LIKE UPPER('%%') OR UPPER(tel_video) LIKE UPPER('%%') OR UPPER(tel_prefer) 
> LIKE
> UPPER('%%') OR UPPER(email) LIKE UPPER('%%') OR UPPER(email_type) LIKE 
> UPPER('%%')
> OR UPPER(email_home) LIKE UPPER('%%') OR UPPER(email_home_type) LIKE 
> UPPER('%%') )
> AND ((cat_id LIKE '%,) AND (owner=11 OR (access='public' AND owner in
> (1,12,11,15))) ORDER BY n_family,n_given,email ASC
> MySQL Error: 1064 (You have an error in your SQL syntax near 'public' AND 
> owner in
> (1,12,11,15))) ORDER BY n_family,n_given,email ASC' at line 1)
> 
> File: /srv/www/htdocs/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php
> Line: 496
> Session halted.
> ---------------
> 
> I tested 2 clients (both winxp). Latest anglemail; phpgw
> 0.9.14.002




No Followups Have Been Posted


CC List
*******

CC Address                          | Comment
------------------------------------+-----------------------------
address@hidden                  | original poster of problem to the list



No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=2951&group_id=509




reply via email to

[Prev in Thread] Current Thread [Next in Thread]