Quantcast

egroupware 1.6 rc2 + postgresql

classic Classic list List threaded Threaded
1 message Options
agostinho-2 agostinho-2
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

egroupware 1.6 rc2 + postgresql

Database error

Invalid SQL: SELECT COUNT(*) FROM egw_addressbook  WHERE contact_tid='n' AND (egw_addressbook.contact_owner=6 OR contact_private=0 AND egw_addressbook.contact_owner IN (-1,6,0) OR egw_addressbook.contact_owner IS NULL) AND (n_family ILIKE '%@%' OR n_given ILIKE '%@%' OR n_middle ILIKE '%@%' OR n_prefix ILIKE '%@%' OR n_suffix ILIKE '%@%' OR n_fn ILIKE '%@%' OR n_fileas ILIKE '%@%' OR contact_bday ILIKE '%@%' OR org_name ILIKE '%@%' OR org_unit ILIKE '%@%' OR contact_title ILIKE '%@%' OR contact_role ILIKE '%@%' OR contact_assistent ILIKE '%@%' OR contact_room ILIKE '%@%' OR adr_one_street ILIKE '%@%' OR adr_one_street2 ILIKE '%@%' OR adr_one_locality ILIKE '%@%' OR adr_one_region ILIKE '%@%' OR adr_one_postalcode ILIKE '%@%' OR adr_one_countryname ILIKE '%@%' OR contact_label ILIKE '%@%' OR adr_two_street ILIKE '%@%' OR adr_two_street2 ILIKE '%@%' OR adr_two_locality ILIKE '%@%' OR adr_two_region ILIKE '%@%' OR adr_two_postalcode ILIKE '%@%' OR adr_two_countryname ILIKE '%@%' OR tel_work ILIKE '%@%' OR tel_cell ILIKE '%@%' OR tel_fax ILIKE '%@%' OR tel_assistent ILIKE '%@%' OR tel_car ILIKE '%@%' OR tel_pager ILIKE '%@%' OR tel_home ILIKE '%@%' OR tel_fax_home ILIKE '%@%' OR tel_cell_private ILIKE '%@%' OR tel_other ILIKE '%@%' OR tel_prefer ILIKE '%@%' OR contact_email ILIKE '%@%' OR contact_email_home ILIKE '%@%' OR contact_url ILIKE '%@%' OR contact_url_home ILIKE '%@%' OR contact_freebusy_uri ILIKE '%@%' OR contact_calendar_uri ILIKE '%@%' OR contact_note ILIKE '%@%' OR contact_geo ILIKE '%@%' OR contact_pubkey ILIKE '%@%' OR contact_etag ILIKE '%@%' OR contact_uid ILIKE '%@%'):
ERROR:  operator does not exist: integer ~~* unknown
LINE 1: ...@%' OR contact_pubkey ILIKE '%@%' OR contact_etag ILIKE '%@%...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

#0 /usr/local/www/data-dist/eg/phpgwapi/inc/class.egw_db.inc.php(674): egw_db->halt('Invalid SQL: SE...', 841, '/usr/local/www/...')
#1 /usr/local/www/data-dist/eg/phpgwapi/inc/class.egw_db.inc.php(1892): egw_db->query('SELECT COUNT(*)...', 841, '/usr/local/www/...', false, -1, false, 2)
#2 /usr/local/www/data-dist/eg/etemplate/inc/class.so_sql.inc.php(841): egw_db->select('egw_addressbook', 'COUNT(*)', Array, 841, '/usr/local/www/...', false, '', 'phpgwapi', 0, '')
#3 /usr/local/www/data-dist/eg/addressbook/inc/class.addressbook_sql.inc.php(399): so_sql->search(Array, false, 'n_family<>'' DE...', '', '%', false, 'OR', Array, Array, '', NULL)
#4 /usr/local/www/data-dist/eg/addressbook/inc/class.addressbook_so.inc.php(613): addressbook_sql->search(Array, false, 'n_family<>'' DE...', '', '%', false, 'OR', Array, Array, '', NULL)
#5 /usr/local/www/data-dist/eg/addressbook/inc/class.addressbook_ui.inc.php(931): addressbook_so->search('@', false, 'n_family<>'' DE...', '', '%', false, 'OR', Array, Array)
#6 /usr/local/www/data-dist/eg/etemplate/inc/class.nextmatch_widget.inc.php(318): addressbook_ui->get_rows(Array, NULL, NULL)
#7 /usr/local/www/data-dist/eg/etemplate/inc/class.boetemplate.inc.php(528): nextmatch_widget->pre_process('exec[nm]', Array, Array, Array, Array, Object(etemplate))
#8 /usr/local/www/data-dist/eg/etemplate/inc/class.etemplate.inc.php(1010): boetemplate->extensionPreProcess('nextmatch', 'exec[nm]', Array, Array, Array)
#9 /usr/local/www/data-dist/eg/etemplate/inc/class.etemplate.inc.php(801): etemplate->show_cell(Array, Array, Array, 'exec', 0, 2, 'all', '', '/0/3A')
#10 /usr/local/www/data-dist/eg/etemplate/inc/class.etemplate.inc.php(1335): etemplate->show_grid(Array, Array, Array, 'exec', 0, 0, '/0')
#11 /usr/local/www/data-dist/eg/etemplate/inc/class.etemplate.inc.php(607): etemplate->show_cell(Array, Array, Array, 'exec', 0, 0, '', NULL, '/0')
#12 /usr/local/www/data-dist/eg/etemplate/inc/class.etemplate.inc.php(220): etemplate->show(Array, Array, Array, 'exec')
#13 /usr/local/www/data-dist/eg/addressbook/inc/class.addressbook_ui.inc.php(333): etemplate->exec('addressbook.add...', Array, Array, NULL, Array, 2)
#14 /usr/local/www/data-dist/eg/addressbook/inc/class.addressbook_ui.inc.php(381): addressbook_ui->index(NULL, NULL, true)
#15 /usr/local/www/data-dist/eg/index.php(110): addressbook_ui->emailpopup()
#16 {main}



When I do a new message and click in the address icon a have this error because the
contact_etag filed in (contact_etag ILIKE '%@%') is not varchar but integer.
Loading...