Addressbook bug?

Marco_Gaiarin-3 2012-05-15 12:11:24 UTC #1

[Debian lenny, apache 2.2.9-10+lenny12, php 5.2.6.dfsg.1-1+lenny16,
mysql 5.0.51a-24+lenny5, egroupware 1.8.004]

Building a query using some extra field on addressbook, i’ve hit a page
saying me:

Database error

Invalid SQL: SELECT SQL_CALC_FOUND_ROWS DISTINCT egw_addressbook.* FROM
egw_addressbook LEFT JOIN egw_addressbook_extra extra_order ON
egw_addressbook.contact_id=extra_order.contact_id AND
extra_order.contact_name=‘associazione<>’’’ LEFT JOIN
egw_addressbook_extra extra_order ON
egw_addressbook.contact_id=extra_order.contact_id AND
extra_order.contact_name=‘associazione’ WHERE contact_tid=‘n’ AND
egw_addressbook.contact_owner != 0 AND
(egw_addressbook.contact_owner=1054 OR contact_private=0 AND
egw_addressbook.contact_owner IN
(-1064,-1040,-1039,-1034,-1033,-1026,-1025,-1024,-1022,-1021,-1020,-513,-512,1054,0)
OR egw_addressbook.contact_owner IS NULL) ORDER BY
extra_order.contact_value IS NULL,extra_order.contact_value
DESC,extra_order.contact_value IS NULL,extra_order.contact_value
ASC,org_name ASC,n_family ASC,n_given ASC:
Not unique table/alias: ‘extra_order’

Click here to resume your eGroupWare Session.

Then, error appear at every addressbook access try; after some panic,
i’ve found on options table:

select * from egw_preferences where preference_owner=1054 and preference_app=‘addressbook’;
±-----------------±---------------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
preference_owner | preference_app | preference_value

±-----------------±---------------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

        1054 | addressbook    | a:2:{s:11:"index_state";s:190:"a:6:{s:6:\"filter\";s:0:\"\";s:6:\"cat_id\";s:0:\"\";s:5:\"order\";s:13:\"#associazione\";s:4:\"sort\";s:3:\"ASC\";s:10:\"col_filter\";a:1:{s:3:\"tid\";s:1:\"n\";}s:8:\"org_view\";s:0:\"\";}";s:32:"nextmatch-addressbook.index.rows";s:204:"n_fileas_n_given_n_family_n_family_n_given_org_name_n_family_n_given_n_fileas,role,photo,bday,home,tel_work_tel_cell_tel_home,url_email_email_home,customfields,#parrocchia,#codice,#zona,#associazione,note";} |

and after removing this row on egw_preferences table, logout and login
back, i was able to fix this issue.

Hope can i help.

–
The Twentieth Century was shaped largely by three trends: the growth of
democracy, the growth of corporate power, and the growth of corporate
propaganda as a means of protecting corporate power against democracy.
(Alex Carey)

Live Security Virtual Conference
Exclusive live event will cover all the ways today’s security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

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