Here's a very ugly workaround that works here: Change: /var/www/egroupware $ grep ILIKE -r . ./phpbrain/inc/class.sokb.inc.php: $this->like = 'ILIKE'; ./sitemgr/inc/class.search_so.inc.php: $this->like = 'ILIKE'; grep: ./header.inc.php: Keine Berechtigung ./phpgwapi/inc/class.egw_db.inc.php: 'case_insensitive_like' => 'LIKE', // case insensitive version of like, eg. ILIKE for postgres ./phpgwapi/inc/class.egw_db.inc.php: $this->capabilities['case_insensitive_like'] = 'ILIKE'; ./phpgwapi/inc/class.translation.inc.php: $like = $this->db->Type == 'pgsql' ? 'ILIKE' : 'LIKE'; To: /var/www/egroupware $ grep ILIKE -r . ./phpbrain/inc/class.sokb.inc.php: $this->like = '::text ILIKE'; ./sitemgr/inc/class.search_so.inc.php: $this->like = '::text ILIKE'; grep: ./header.inc.php: Keine Berechtigung ./phpgwapi/inc/class.egw_db.inc.php: 'case_insensitive_like' => 'LIKE', // case insensitive version of like, eg. ILIKE for postgres ./phpgwapi/inc/class.egw_db.inc.php: $this->capabilities['case_insensitive_like'] = '::text ILIKE'; ./phpgwapi/inc/class.translation.inc.php: $like = $this->db->Type == 'pgsql' ? '::text ILIKE' : 'LIKE';
Attachment:
signature.asc
Description: Digital signature