Re: [Phpgroupware-users] Email Javascript Error

[Alex]

Well....mhm.. isnt supposed to happen. I havent tested it in 0.9.14.2,
maybe something changed in the contact's class that bork it..... nothing
to worry about for shure though.... ill check it out.... if you put it
up in savanah it would help A LOT

:)


El mié, 26 de 03 de 2003 a las 09:07, address@hidden escribió:
> 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 mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
-- 
Alex <address@hidden>
Step One Group