[Top][All Lists]
[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
- [Phpgroupware-users] Email Javascript Error,
lms <=