[not-a-crosspost] XMLRPC vs addressbook search results in database error

el_es 2013-09-19 13:46:01 UTC #1

[not a crosspost, in fact, a re-send]
(egroupware (1.8.004.20130322) hardy from suse packages)
Hi,

I am trying to do a query over XMLRPC like this:
(according to http://wiki.egroupware.org/index.php?wikipage=AddressbookXmlRpc)

<?xml version="1.0"?> addressbook.boaddressbook.search start 0 limit 5 fields [side note : is this how an 'unset' array is made? i.e. with no 'data' ?] query 079 filter none // <<< if I change this to all... order fn sort ASC include_users all

I am getting this in return :

(my comments inline, marked // )

Database error

db::column_data_implode(' AND ',Array
(
// so this is the only place where I see 'none' in the output and it sort of matches the 'none' of
// predefined filter field...
    [none] => // <<<< if i change the 'all' in above inovcation, 'all' appears here. <<<<
		//  if i just pass empty value (empty string) I get Invalid SQL like the next output,
		// if i just pass an anonymous empty  I also get Invalid SQL... 
[0] =&gt; contact_tid != 'D'
[1] =&gt; (egw_addressbook.contact_owner=6 OR contact_private=0 AND egw_addressbook.contact_owner IN (-39,-21,-1,6,0)  OR egw_addressbook.contact_owner IS NULL)
[2] =&gt; (account_expires IS NULL OR account_expires = -1 OR account_expires &gt; 1379580785)
[3] =&gt; ((((( CONCAT(CAST(COALESCE(n_family,'') AS char),CAST(COALESCE(n_given,'') AS char),CAST(COALESCE(n_middle,'') AS char),CAST(COALESCE(n_prefix,'') AS char),CAST(COALESCE(n_suffix,'') AS char),CAST(COALESCE(n_fn,'') AS char),CAST(COALESCE(n_fileas,'') AS char),CAST(COALESCE(contact_bday,'') AS char),CAST(COALESCE(org_name,'') AS char),CAST(COALESCE(org_unit,'') AS char),CAST(COALESCE(contact_title,'') AS char),CAST(COALESCE(contact_role,'') AS char),CAST(COALESCE(contact_assistent,'') AS char),CAST(COALESCE(contact_room,'') AS char),CAST(COALESCE(adr_one_street,'') AS char),CAST(COALESCE(adr_one_street2,'') AS char),CAST(COALESCE(adr_one_locality,'') AS char),CAST(COALESCE(adr_one_region,'') AS char),CAST(COALESCE(adr_one_postalcode,'') AS char),CAST(COALESCE(adr_one_countryna

me,’’) AS char),CAST(COALESCE(contact_label,’’) AS char),CAST(COALESCE(adr_two_street,’’) AS char),CAST(COALESCE(adr_two_street2,’’) AS char),CAST(COALESCE(adr_two_locality,’’) AS char),CAST(COALESCE

(adr_two_region,’’) AS char),CAST(COALESCE(adr_two_postalcode,’’) AS char),CAST(COALESCE(adr_two_countryname,’’) AS char),CAST(COALESCE(tel_work,’’) AS char),CAST(COALESCE(tel_cell,’’) AS char),CAST(COALESCE(tel_fax,’’) AS char),CAST(COALESCE(tel_assistent,’’) AS char),CAST(COALESCE(tel_car,’’) AS char),CAST(COALESCE(tel_pager,’’) AS char),CAST(COALESCE(tel_home,’’) AS char),CAST(COALESCE(tel_fax_home,’’) AS char),CAST(COALESCE(tel_cell_private,’’) AS char),CAST(COALESCE(tel_other,’’) AS char),CAST(COALESCE(tel_prefer,’’) AS char),CAST(COALESCE(contact_email,’’) AS char),CAST(COALESCE(contact_email_home,’’) AS char),CAST(COALESCE(contact_url,’’) AS char),CAST(COALESCE(contact_url_home,’’) AS char),CAST(COALESCE(contact_freebusy_uri,’’) AS char),CAST(COALESCE(contact_calendar_uri,’’) AS cha

r),CAST(COALESCE(contact_note,’’) AS char),CAST(COALESCE(contact_geo,’’) AS char),CAST(COALESCE(contact_pubkey,’’) AS char),CAST(COALESCE(adr_one_countrycode,’’) AS char),CAST(COALESCE(adr_two_countr

ycode,’’) AS char),CAST(COALESCE(carddav_name,’’) AS char),CAST(COALESCE(egw_addressbook_extra.contact_value,’’) AS char)) LIKE ‘%079%’ OR (egw_addressbook.contact_id IS NOT NULL AND egw_addressbook.contact_id = 079))) )))

)

,‘1’,<pre>Array

(

[contact_id] => Array

(

[type] => auto

[nullable] =>

)
[contact_tid] =&gt; Array
    (
        [type] =&gt; char
        [precision] =&gt; 1
        [default] =&gt; n
    )

[contact_owner] =&gt; Array
    (
        [type] =&gt; int
        [precision] =&gt; 8
        [nullable] =&gt; 
    )

[contact_private] =&gt; Array
    (
        [type] =&gt; int
        [precision] =&gt; 1
        [default] =&gt; 0
    )

[cat_id] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 255
    )

[n_family] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[n_given] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[n_middle] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[n_prefix] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[n_suffix] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[n_fn] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 128
    )

[n_fileas] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 255
    )

[contact_bday] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 12
    )

[org_name] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 128
    )

[org_unit] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[contact_title] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[contact_role] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[contact_assistent] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[contact_room] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[adr_one_street] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[adr_one_street2] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[adr_one_locality] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[adr_one_region] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[adr_one_postalcode] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[adr_one_countryname] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[contact_label] =&gt; Array
    (
        [type] =&gt; text
    )

[adr_two_street] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[adr_two_street2] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[adr_two_locality] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[adr_two_region] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[adr_two_postalcode] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[adr_two_countryname] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
    )

[tel_work] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 40
    )

[tel_cell] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 40
    )

[tel_fax] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 40
    )

[tel_assistent] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 40
    )

[tel_car] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 40
    )

[tel_pager] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 40
    )

[tel_home] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 40
    )

[tel_fax_home] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 40
    )

[tel_cell_private] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 40
    )

[tel_other] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 40
    )

[tel_prefer] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 32
    )

[contact_email] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 128
    )

[contact_email_home] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 128
    )

[contact_url] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 128
    )

[contact_url_home] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 128
    )

[contact_freebusy_uri] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 128
    )

[contact_calendar_uri] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 128
    )

[contact_note] =&gt; Array
    (
        [type] =&gt; text
    )

[contact_tz] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 8
    )

[contact_geo] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 32
    )

[contact_pubkey] =&gt; Array
    (
        [type] =&gt; text
    )

[contact_created] =&gt; Array
    (
        [type] =&gt; int
        [precision] =&gt; 8
    )

[contact_creator] =&gt; Array
    (
        [type] =&gt; int
        [precision] =&gt; 4
        [nullable] =&gt; 
    )

[contact_modified] =&gt; Array
    (
        [type] =&gt; int
        [precision] =&gt; 8
        [nullable] =&gt; 
    )

[contact_modifier] =&gt; Array
    (
        [type] =&gt; int
        [precision] =&gt; 4
    )

[contact_jpegphoto] =&gt; Array
    (
        [type] =&gt; blob
    )

[account_id] =&gt; Array
    (
        [type] =&gt; int
        [precision] =&gt; 4
    )

[contact_etag] =&gt; Array
    (
        [type] =&gt; int
        [precision] =&gt; 4
        [default] =&gt; 0
    )

[contact_uid] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 255
    )

[adr_one_countrycode] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 2
    )

[adr_two_countrycode] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 2
    )

[carddav_name] =&gt; Array
    (
        [type] =&gt; varchar
        [precision] =&gt; 64
        [comment] =&gt; name part of CardDAV URL, if specified by client
    )

)

</pre><b>nothing known about column ‘none’!</b>

Click here to resume your eGroupWare Session.

Seems like the only place above where ‘none’ is used is in the ‘filter’ member of the query, but if
I remove the whole ‘filter’ member, I get ‘Invalid SQL’, like below, so…

Database error

Invalid SQL: SELECT SQL_CALC_FOUND_ROWS  FROM egw_addressbook  LEFT JOIN egw_accounts ON egw_addressbook.account_id=egw_accounts.account_id LEFT JOIN egw_addressbook_extra ON egw_addressbook.contact_id=egw_addressbook_extra.contact_id WHERE contact_tid != 'D' AND (egw_addressbook.contact_owner=6 OR contact_private=0 AND egw_addressbook.contact_owner IN (-39,-21,-1,6,0)  OR egw_addressbook.contact_owner IS NULL) AND (account_expires IS NULL OR account_expires = -1 OR account_expires > 1379581363) AND ((((( CONCAT(CAST(COALESCE(n_family,'') AS char),CAST(COALESCE(n_given,'') AS char),CAST(COALESCE(n_middle,'') AS char),CAST(COALESCE(n_prefix,'') AS char),CAST(COALESCE(n_suffix,'') AS char),CAST(COALESCE(n_fn,'') AS char),CAST(COALESCE(n_fileas,'') AS char),CAST(COALESCE(contact_bd
 ay,'') AS char),CAST(COALESCE(org_name,'') AS char),CAST(COALESCE(org_unit,'') AS char),CAST(COALESCE(contact_title,'') AS char),CAST(COALESCE(contact_role,'') AS char),CAST(COALESCE(contact_assisten
t,'') AS char),CAST(COALESCE(contact_room,'') AS char),CAST(COALESCE(adr_one_street,'') AS char),CAST(COALESCE(adr_one_street2,'') AS char),CAST(COALESCE(adr_one_locality,'') AS char),CAST(COALESCE(adr_one_region,'') AS char),CAST(COALESCE(adr_one_postalcode,'') AS char),CAST(COALESCE(adr_one_countryname,'') AS char),CAST(COALESCE(contact_label,'') AS char),CAST(COALESCE(adr_two_street,'') AS char),CAST(COALESCE(adr_two_street2,'') AS char),CAST(COALESCE(adr_two_locality,'') AS char),CAST(COALESCE(adr_two_region,'') AS char),CAST(COALESCE(adr_two_postalcode,'') AS char),CAST(COALESCE(adr_two_countryname,'') AS char),CAST(COALESCE(tel_work,'') AS char),CAST(COALESCE(tel_cell,'') AS char),CAST(COALESCE(tel_fax,'') AS char),CAST(COALESCE(tel_assistent,'') AS char),CAST(COALESCE(tel_car,'') AS
  char),CAST(COALESCE(tel_pager,'') AS char),CAST(COALESCE(tel_home,'') AS char),CAST(COALESCE(tel_fax_home,'') AS char),CAST(COALESCE(tel_cell_private,'') AS char),CAST(COALESCE(tel_other,'') AS char
),CAST(COALESCE(tel_prefer,'') AS char),CAST(COALESCE(contact_email,'') AS char),CAST(COALESCE(contact_email_home,'') AS char),CAST(COALESCE(contact_url,'') AS char),CAST(COALESCE(contact_url_home,'') AS char),CAST(COALESCE(contact_freebusy_uri,'') AS char),CAST(COALESCE(contact_calendar_uri,'') AS char),CAST(COALESCE(contact_note,'') AS char),CAST(COALESCE(contact_geo,'') AS char),CAST(COALESCE(contact_pubkey,'') AS char),CAST(COALESCE(adr_one_countrycode,'') AS char),CAST(COALESCE(adr_two_countrycode,'') AS char),CAST(COALESCE(carddav_name,'') AS char),CAST(COALESCE(egw_addressbook_extra.contact_value,'') AS char)) LIKE '%079%' OR (egw_addressbook.contact_id IS NOT NULL AND egw_addressbook.contact_id = 079))) ))) ORDER BY contact_fn ASC:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM egw_addressbook  LEFT JOIN egw_accounts ON egw_addressbook.account_id=egw_a' at line 1

Click here to resume your eGroupWare Session.

… so my conclusion is :

the invocation with ‘filter’ member must pass a name of a pre-defined filter
where is this filter defined ?
is there a way to get a list of filters we’re supposed to use here?
or a way to define the filter ?

Hope it’s not hopeless

Lukasz

LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

ngegw 2013-09-19 14:33:00 UTC #2

…
</pre>nothing known about column ‘none’!

This is an empty array (array()), not null:

fields

I don’t know what will be accepted as null. Have you tried leaving out the
fields member entirely? Maybe lose the tag?

Seems like the only place above where ‘none’ is used is in the 'filter’
member of the query, but if
I remove the whole ‘filter’ member, I get ‘Invalid SQL’, like below, so…

…

… so my conclusion is :

the invocation with ‘filter’ member must pass a name of a pre-defined
filter

where is this filter defined ?

is there a way to get a list of filters we’re supposed to use here?

or a way to define the filter ?

This code doesn’t have the concept of pre-defined filters.

From boaddressbook->search() (line 355):
@param string $param[‘filter’]=’’ filters with syntax like
=,=,=!’’ for not empty

I don’t know what that means exactly, or how to translate it into a valid
request, but most likely it wants something like cat_id=15 or ‘’.

Nathan

el_es 2013-09-19 16:26:03 UTC #3

… </pre>nothing known about column
’none’!

This is an empty array (array()), not null:
fields I
don’t know what will be accepted as null. Have you tried leaving out
the fields member entirely? Maybe lose the tag?

[trying with just then - Invalid SQL through the filter thingy I suppose. ]
so it got through to querying the database, good…
but read below…

Seems like the only place above where ‘none’ is used is in the
’filter’ member of the query, but if I remove the whole 'filter’
member, I get ‘Invalid SQL’, like below, so…

…

… so my conclusion is :

the invocation with ‘filter’ member must pass a name of a
pre-defined filter - where is this filter defined ? - is there a way
to get a list of filters we’re supposed to use here? - or a way to
define the filter ?

This code doesn’t have the concept of pre-defined filters.

From boaddressbook->search() (line 355): @param string
$param[‘filter’]=’’ filters with syntax like
=,=,=!’’ for not empty

ok so with not in, and filter all=!’’, I get…

filter all=!'' (or all=!'' ...nope, same thing)

but result is still Invalid SQL…

ah ! and with value>=!’’

SELECT SQL_CALC_FOUND_ROWS FROM egw_addressbook LEFT JOIN egw_accounts ON egw_addressbook.account_id=egw_accounts.account_id LEFT JOIN egw_addressbook_extra ON egw_addressbook.contact_id=egw_addressbook_extra.contact_id WHERE != ‘’ AND contact_tid != ‘D’ AND

look there >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>^^^^^^^^^^ here the filter lands!
trying to put a valid field name:
(egw_addressbook.contact_owner=6 OR contact_private=0 AND egw_addressbook.contact_owner IN (-39,-21,-1,6,0) OR egw_addressbook.contact_owner IS NULL) AND (account_expires IS NULL OR account_expires = -1 OR account_expires > 1379605768) AND ((((( CONCAT(CAST(COALESCE(n_family,’’) AS char),CAST(COALESCE(n_given,’’) AS char),CAST(COALESCE(n_middle,’’) AS char),CAST(COALESCE(n_prefix,’’) AS char),CAST(COALESCE(n_suffix,’’) AS char),CAST(COALESCE(n_fn,’’) AS char),CAST(COALESCE(n_fileas,’’) AS char),CAST(COALESCE(contact_bday,’’) AS char),CAST(COALESCE(org_name,’’) AS char),CAST(COALESCE(org_unit,’’) AS char),CAST(COALESCE(contact_title,’’) AS char),CAST(COALESCE(contact_role,’’) AS char),CAST(COALESCE(contact_assistent,’’) AS char)

putting the filter value simply ‘true’ gives…

Database error

db::column_data_implode(' AND ',Array
(
    [true] => <<<< why does it end as a name of a column???
    [0] => contact_tid != 'D'

I don’t know what that means exactly, or how to translate it into a

valid request, but most likely it wants something like cat_id=15 or

’’.

putting in cat_id=!’’ yields a different InvalidSQL:
Invalid SQL: SELECT SQL_CALC_FOUND_ROWS  FROM egw_addressbook  LEFT JOIN egw_accounts ON egw_addressbook.account_id=egw_accounts.account_id LEFT JOIN egw_addressbook_extra ON egw_addressbook.contact_id=egw_addressbook_extra.contact_id WHERE contact_tid != ‘D’ AND ( (CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,0,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,30,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,167,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,82,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,99,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,75,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,7,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,76,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,77,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,78,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,79,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,80,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,14,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,81,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,84,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,159,%’ OR CONCAT(’,’,cat_id,’,’) NOT L

IKE ‘%,97,%’ OR C …
(just an excerpt, it’s huge, overall response got some 3760+8192+788 bytes… whoa.)

Nathan

It means probably that I need to examine the boaddressbook->search function  for valid inputs.

to establish what it needs where; but also that the wiki is out of date L:(
Well, one thing at a time.

Tomorrow is also another day 
Lukasz

LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!

1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint

2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes

Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.

http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk

eGroupWare-developers mailing list

eGroupWare-developers@lists.sourceforge.net

https://lists.sourceforge.net/lists/listinfo/egroupware-developers

Ralf_Becker_Stylite 2013-09-22 11:43:41 UTC #4

Hi Lukasz,

xmlrpc is a long time dead, do NOT use it. I will remove it, once I find
some time for it.

Use CalDAV/CardDAV instead.

Ralf

… </pre>nothing known about column
’none’!

This is an empty array (array()), not null:
fields I
don’t know what will be accepted as null. Have you tried leaving out
the fields member entirely? Maybe lose the tag?

[trying with just then - Invalid SQL through the filter thingy I suppose. ]
so it got through to querying the database, good…
but read below…

Seems like the only place above where ‘none’ is used is in the
’filter’ member of the query, but if I remove the whole 'filter’
member, I get ‘Invalid SQL’, like below, so…

…

… so my conclusion is :

the invocation with ‘filter’ member must pass a name of a
pre-defined filter - where is this filter defined ? - is there a way
to get a list of filters we’re supposed to use here? - or a way to
define the filter ?

This code doesn’t have the concept of pre-defined filters.

From boaddressbook->search() (line 355): @param string
$param[‘filter’]=’’ filters with syntax like
=,=,=!’’ for not empty

ok so with not in, and filter all=!’’, I get…
filter all=!'' (or all=!'' ...nope, same thing)
but result is still Invalid SQL…

ah ! and with value>=!’’

SELECT SQL_CALC_FOUND_ROWS FROM egw_addressbook LEFT JOIN egw_accounts ON egw_addressbook.account_id=egw_accounts.account_id LEFT JOIN egw_addressbook_extra ON egw_addressbook.contact_id=egw_addressbook_extra.contact_id WHERE != ‘’ AND contact_tid != ‘D’ AND

look there >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>^^^^^^^^^^ here the filter lands!
trying to put a valid field name:
(egw_addressbook.contact_owner=6 OR contact_private=0 AND egw_addressbook.contact_owner IN (-39,-21,-1,6,0) OR egw_addressbook.contact_owner IS NULL) AND (account_expires IS NULL OR account_expires = -1 OR account_expires > 1379605768) AND ((((( CONCAT(CAST(COALESCE(n_family,’’) AS char),CAST(COALESCE(n_given,’’) AS char),CAST(COALESCE(n_middle,’’) AS char),CAST(COALESCE(n_prefix,’’) AS char),CAST(COALESCE(n_suffix,’’) AS char),CAST(COALESCE(n_fn,’’) AS char),CAST(COALESCE(n_fileas,’’) AS char),CAST(COALESCE(contact_bday,’’) AS char),CAST(COALESCE(org_name,’’) AS char),CAST(COALESCE(org_unit,’’) AS char),CAST(COALESCE(contact_title,’’) AS char),CAST(COALESCE(contact_role,’’) AS char),CAST(COALESCE(contact_assistent,’’) AS char)

putting the filter value simply ‘true’ gives…

Database error
db::column_data_implode(' AND ',Array
(
 [true] => <<<< why does it end as a name of a column???
 [0] => contact_tid != 'D'

I don’t know what that means exactly, or how to translate it into a

valid request, but most likely it wants something like cat_id=15 or

’’.

putting in cat_id=!’’ yields a different InvalidSQL:
Invalid SQL: SELECT SQL_CALC_FOUND_ROWS FROM egw_addressbook LEFT JOIN egw_accounts ON egw_addressbook.account_id=egw_accounts.account_id LEFT JOIN egw_addressbook_extra ON egw_addressbook.contact_id=egw_addressbook_extra.contact_id WHERE contact_tid != ‘D’ AND ( (CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,0,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,30,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,167,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,82,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,99,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,75,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,7,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,76,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,77,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,78,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,79,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,80,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,14,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,81,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,84,%’ OR CONCAT(’,’,cat_id,’,’) NOT LIKE ‘%,159,%’ OR CONCAT(’,’,cat_id

,’

,’) NOT L

IKE ‘%,97,%’ OR C …
(just an excerpt, it’s huge, overall response got some 3760+8192+788 bytes… whoa.)

Nathan

It means probably that I need to examine the boaddressbook->search function for valid inputs.

to establish what it needs where; but also that the wiki is out of date L:(
Well, one thing at a time.

Tomorrow is also another day 
Lukasz

LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!

1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint

2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes

Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.

http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk

eGroupWare-developers mailing list

eGroupWare-developers@lists.sourceforge.net

https://lists.sourceforge.net/lists/listinfo/egroupware-developers

–
Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13.
http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

el_es 2013-09-23 11:33:51 UTC #5

Hi Lukasz,

xmlrpc is a long time dead, do NOT use it. I will remove it, once I find
some time for it.

Use CalDAV/CardDAV instead.

Ralf

[cut the history, considering the above]

Thanks Ralf,

Is the same true for SOAP too ?

I shall evaluate on CardDAV then.

Thanks&Regards,
Lukasz

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

Ralf_Becker_6 2013-09-23 18:23:14 UTC #6

Yeap, same is true for saop.

Ralf

Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

Hi Lukasz,

xmlrpc is a long time dead, do NOT use it. I will remove it, once I find
some time for it.

Use CalDAV/CardDAV instead.

Ralf

[cut the history, considering the above]

Thanks Ralf,

Is the same true for SOAP too ?

I shall evaluate on CardDAV then.

Thanks&Regards,
Lukasz

LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

el_es 2013-09-24 10:53:17 UTC #7

Yeap, same is true for saop.

Ralf

Thanks.

And thanks for keeping CardDAV up to spec - i copy/pasted example query from RFC6532 and
I got output just about what I need.

Lukasz

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers