Hello,
I was too fast in reporting success X(
(Disclaimer: I use the ‘extra’ (custom) fields on the addressbook a lot for vital (to me) things)
and today after upgrade when I tried to get into Addressbook application I got:
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=‘CDUPhyPort<>’’’ LEFT JOIN egw_addressbook_extra extra_order ON egw_addressbook.contact_id=extra_order.contact_id AND extra_order.contact_name=‘CDUPhyPort’ WHERE contact_tid=‘n’ AND (CONCAT(’,’,cat_id,’,’) LIKE ‘%,32,%’ OR CONCAT(’,’,cat_id,’,’) LIKE ‘%,17,%’ OR CONCAT(’,’,cat_id,’,’) LIKE ‘%,12,%’ OR CONCAT(’,’,cat_id,’,’) LIKE ‘%,18,%’ OR CONCAT(’,’,cat_id,’,’) LIKE ‘%,13,%’ OR CONCAT(’,’,cat_id,’,’) LIKE ‘%,73,%’) AND contact_private=0 AND egw_addressbook.contact_owner=-1 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’
Apache error log has
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] 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=‘CDUPhyPort<>\’\’’ LEFT JOIN egw_addressbook_extra extra_order ON egw_addressbook.contact_id=extra_order.contact_id AND extra_order.contact_name=‘CDUPhyPort’ WHERE contact_tid=‘n’ AND (CONCAT(’,’,cat_id,’,’) LIKE ‘%,32,%’ OR CONCAT(’,’,cat_id,’,’) LIKE ‘%,17,%’ OR CONCAT(’,’,cat_id,’,’) LIKE ‘%,12,%’ OR CONCAT(’,’,cat_id,’,’) LIKE ‘%,18,%’ OR CONCAT(’,’,cat_id,’,’) LIKE ‘%,13,%’ OR CONCAT(’,’,cat_id,’,’) LIKE ‘%,73,%’) AND contact_private=0 AND egw_addressbook.contact_owner=-1 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:\nNot unique table/alias: ‘extra_order’, re
ferer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #0 /usr/share/egroupware/phpgwapi/inc/class.egw_db.inc.php(685): egw_db->halt(‘Invalid SQL: SE…’, 1022, ‘/usr/share/egro…’), referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #1 /usr/share/egroupware/phpgwapi/inc/class.egw_db.inc.php(2014): egw_db->query(‘SELECT SQL_CALC…’, 1022, ‘/usr/share/egro…’, 0, 15, false, 2), referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #2 /usr/share/egroupware/etemplate/inc/class.so_sql.inc.php(1023): egw_db->select(‘egw_addressbook’, ‘SQL_CALC_FOUND_…’, Array, 1022, ‘/usr/share/egro…’, 0, ‘ORDER BY extra_…’, ‘phpgwapi’, 15, ’ LEFT JOIN egw_…’), referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #3 /usr/share/egroupware/etemplate/inc/class.so_sql_cf.inc.php(615): so_sql->search(’’, ‘DISTINCT egw_ad…’, ‘extra_order.con…’, ‘’, ‘%’, false, ‘OR’, Array, Array, ’ LEFT JOIN egw_…’, NULL), referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #4 /usr/share/egroupware/addressbook/inc/class.addressbook_sql.inc.php(390): so_sql_cf->search(’’, false, ‘#CDUPhyPort<>’’…’, ‘’, ‘%’, false, ‘OR’, Array, Array, ‘’, NULL), referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #5 /usr/share/egroupware/addressbook/inc/class.addressbook_so.inc.php(671): addressbook_sql->search(’’, false, ‘#CDUPhyPort<>’’…’, ‘’, ‘%’, false, ‘OR’, Array, Array, ‘’, NULL), referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #6 /usr/share/egroupware/addressbook/inc/class.addressbook_ui.inc.php(1003): addressbook_so->search(’’, false, ‘#CDUPhyPort<>’’…’, ‘’, ‘%’, false, ‘OR’, Array, Array), referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #7 /usr/share/egroupware/etemplate/inc/class.nextmatch_widget.inc.php(548): addressbook_ui->get_rows(Array, Array, Array), referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #8 /usr/share/egroupware/etemplate/inc/class.nextmatch_widget.inc.php(302): nextmatch_widget::call_get_rows(Array, Array, Array), referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #9 /usr/share/egroupware/etemplate/inc/class.boetemplate.inc.php(516): nextmatch_widget->pre_process(‘exec[nm]’, Array, Array, Array, Array, Object(etemplate)), referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #10 /usr/share/egroupware/etemplate/inc/class.etemplate.inc.php(1084): boetemplate->extensionPreProcess(‘nextmatch’, ‘exec[nm]’, Array, Array, Array), referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #11 /usr/share/egroupware/etemplate/inc/class.etemplate.inc.php(862): etemplate->show_cell(Array, Array, Array, ‘exec’, 0, 2, ‘all’, ‘’, ‘/0/3A’), referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #12 /usr/share/egroupware/etemplate/inc/class.etemplate.inc.php(1429): etemplate->show_grid(Array, Array, Array, ‘exec’, 0, 0, ‘/0’), referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #13 /usr/share/egroupware/etemplate/inc/class.etemplate.inc.php(671): etemplate->show_cell(Array, Array, Array, ‘exec’, 0, 0, ‘’, NULL, ‘/0’), referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #14 /usr/share/egroupware/etemplate/inc/class.etemplate.inc.php(259): etemplate->show(Array, Array, Array, ‘exec’), referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #15 /usr/share/egroupware/addressbook/inc/class.addressbook_ui.inc.php(350): etemplate->exec(‘addressbook.add…’, Array, Array, NULL, Array, 0), referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #16 /usr/share/egroupware/index.php(134): addressbook_ui->index(), referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] #17 {main}, referer: https://my_server/egroupware/home/index.php
[Tue Apr 10 12:21:17 2012] [error] [client my_client_ip] # Instance=default, User=Lukasz, URL=https://my_server/egroupware/index.php?menuaction=addressbook.addressbook_ui.index, referer: https://my_server/egroupware/home/index.php
to my untrained eye the ‘addressbook.contact_id=extra_order.contact_id’ matching is wrong, it should be
’addressbook.contact_id=egw_addressbook_extra.contact_id’ and where the hell is the extra_order ?
t.b.c.
L.
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users
