tags 407597 + moreinfo stop Hello Dan
On 2007-01-19 dan wrote: > Package: mysql-server-4.1 > Version: 4.1.11a-4sarge7 > > I found that when i execute a certain sql query the mysql-server crash. > It happened while I examine the newest trunk of egroupware > (http://www.egroupware.org/other/trunk-snapshot.tar.bz2) > You just need a egroupware database and execute the following sql query: > > SELECT SQL_CALC_FOUND_ROWS org_name,COUNT(org_name) AS > org_count,COUNT(DISTINCT CASE WHEN org_unit IS NULL THEN '' ELSE org_unit > END) AS org_unit_count,COUNT(DISTINCT CASE WHEN adr_one_locality IS NULL > THEN '' ELSE adr_one_locality END) AS adr_one_locality_count FROM > egw_addressbook WHERE contact_tid='n' AND contact_owner=-1 AND > (contact_owner=5 OR contact_private=0 AND contact_owner IN (-1,5,0)) AND > org_name != '' GROUP BY org_name ORDER BY org_name ASC LIMIT 0,15 Could you send me a mysqldump copy of this egw_addressbook table? Most bugs only occur with a special combination of data and I don't like to download and install this egroupware thing. Thanks! bye, -christian- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
