phpgroupware-users
[Top][All Lists]
Advanced

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

[Phpgroupware-users] Email Javascript Error


From: lms
Subject: [Phpgroupware-users] Email Javascript Error
Date: Wed, 26 Mar 2003 15:07:36 +0000

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.
---------------

any things to try? I tested 2 clients (both winxp). Latest anglemail; phpgw
0.9.14.002

thanks
jens





reply via email to

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