[eGroupWare-users] XMLRPC addressbook.boaddressbook.search returns database error [LONG POST]

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

(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"?>
<methodCall>
	<methodName>addressbook.boaddressbook.search</methodName>
	<params>
		<param>
			<value>
				<struct>
					<member>
						<name>start</name>
						<value><int>0</int></value>
					</member>
					<member>
						<name>limit</name>
						<value><int>5</int></value>
					</member>
					<member>
						<name>fields</name>
						<value>
							<array></array>
[side note : is this how an 'unset' array is made? i.e. with no 'data' ?]
						</value>
					</member>
					<member>
						<name>query</name>
						<value><string>079</string></value>
					</member>
					<member>
						<name>filter</name>
						<value><string>none</string></value>
					</member>
					<member>
						<name>order</name>
						<value><string>fn</string></value>
					</member>
					<member>
						<name>sort</name>
						<value><string>ASC</string></value>
					</member>
					<member>
						<name>include_users</name>
						<value><string>all</string></value>
					</member>
				</struct>
			</value>
		</param>
	</params>
</methodCall>

I am getting this in return :

<html>
<head>
<title>Database error</title>
</head>
<body>
<h3>Database error</h3>
<pre><b>db::column_data_implode(' AND ',Array
(
    [none] =&gt; 
    [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_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_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',,&lt;pre&gt;Array
(
    [contact_id] =&gt; Array
        (
            [type] =&gt; auto
            [nullable] =&gt; 
        )

    [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
        )

)
&lt;/pre&gt;&lt;b&gt;nothing known about column 'none'!&lt;/b&gt;</b>

</pre>
<p><a href="/egroupware/index.php">Click here to resume your eGroupWare Session.</a></p>
</body>
</html>

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

<html>
<head>
<title>Database error</title>
</head>
<body>
<h3>Database error</h3>
<pre><b>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 &gt; 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_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_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</b>

</pre>
<p><a href="/egroupware/index.php">Click here to resume your eGroupWare Session.</a></p>
</body>
</html>