[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [bugs #2951] javascript error in mail/addressbook
From: |
Alejandro Borges (lex) |
Subject: |
[Phpgroupware-tracker] [bugs #2951] javascript error in mail/addressbook when switched to javascript |
Date: |
Fri, 23 Apr 2004 19:01:42 -0400 |
User-agent: |
Mozilla/5.0 (X11; U; Linux ppc; en-US; rv:1.6) Gecko/20040414 Epiphany/1.0.8 |
This mail is an automated notification from the bugs tracker
of the project: phpGroupWare.
/**************************************************************************/
[bugs #2951] Latest Modifications:
Changes by:
Alejandro Borges (lex) <address@hidden>
'Date:
Fri 04/23/04 at 23:01 (Mexico/General)
What | Removed | Added
---------------------------------------------------------------------------
Resolution | None | Fixed
Status | Open | Closed
/**************************************************************************/
[bugs #2951] Full Item Snapshot:
URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=2951>
Project: phpGroupWare
Submitted by: 0
On: Wed 03/26/03 at 21:04
Category: email
Item Group: 0.9.14.002 release
Severity: 5 - Average
Priority: 5 - Normal
Resolution: Fixed
Assigned to: alexbsa
Status: Closed
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
Follow-up Comments
------------------
-------------------------------------------------------
Date: Fri 06/27/03 at 02:32 By: cw
looks like missing SQL '
AND ((cat_id LIKE '%,) AND (owner=11 OR (access='public'
maybe , should be ' ?
any idea lex? or is this fixed?
CC List
-------
CC Address | Comment
------------------------------------+-----------------------------
lms --AT-- eminenz --DOT-- ath --DOT-- cx | original poster of problem to the
list
For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=2951>
_______________________________________________
Message sent via/by Savannah
http://savannah.gnu.org/
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-tracker] [bugs #2951] javascript error in mail/addressbook when switched to javascript,
Alejandro Borges (lex) <=