bugphpGroupWare - Bugs: bug #2951, javascript error in...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #2951: javascript error in mail/addressbook when switched to javascript

Submitted by:  None
Submitted on:  Wed 26 Mar 2003 09:04:00 PM UTC  
 
Item Group: 0.9.14.002 releaseCategory: email
Severity: 3 - NormalPriority: 5 - Normal
Status: FixedPrivacy: Public
Assigned to: Alejandro Borges (lex) <alexbsa>Open/Closed: Closed
Component Version: NoneOperating System: None
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Fri 27 Jun 2003 02:32:45 AM UTC, comment #1:

looks like missing SQL '
AND ((cat_id LIKE '%,) AND (owner=11 OR (access='public'
maybe , should be ' ?
any idea lex? or is this fixed?

Chris Weiss <cw>
Project Administrator
Wed 26 Mar 2003 09:04:00 PM UTC, 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

Anonymous

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 4 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Fri 23 Apr 2004 11:01:36 PM UTCalexbsaStatusNone=>Fixed
  Open/ClosedOpen=>Closed
Wed 26 Mar 2003 10:09:14 PM UTCskwashdItem GroupNone=>(Error - Not Found)
  Assigned toNone=>NA

Back to the top


Powered by Savane 3.1-cleanup1