Error in Addressbook with postgresql

snotty77 2013-07-20 20:57:30 UTC #1

Hi,

I´m using the latest svn checkout of trunk (Version 1.9.019) on an actual Debian system with postgresql 9.1. Until the last checkout, a few days ago, all works well. Today I got the following checkout by opening the Addressbook right after the last checkout:

Database error

Invalid SQL: SELECT DISTINCT egw_addressbook.* FROM egw_addressbook WHERE account_id IS NULL AND contact_tid != ‘D’ AND (egw_addressbook.contact_owner=12 OR contact_private=0 AND egw_addressbook.contact_owner IN (-9,12,0) OR egw_addressbook.contact_owner IS NULL) ORDER BY n_family<>’’ DESC,n_family ASC,n_given ASC,org_name ASC
FEHLER: bei SELECT DISTINCT müssen ORDER-BY-Ausdrücke in der Select-Liste erscheinen
LINE 1: …R egw_addressbook.contact_owner IS NULL) ORDER BY n_family<>…
^ (-1)

The last checkout before is a few days ago. If you need any further info, feel free to ask.

Thanks in advance!

Maybe this apache.log may help:
192.168.1.173 - - [20/Jul/2013:23:23:57 +0200] “GET /egroupware/addressbook/index.php HTTP/1.1” 302 28 “http://groupware/egroupware/index.php?menuaction=calendar.calendar_uiviews.day&date=20130702” "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:22.0) Gecko/20100101 Firefox/22.0"
192.168.1.173 - - [20/Jul/2013:23:23:58 +0200] “GET /egroupware/index.php?menuaction=addressbook.addressbook_ui.index HTTP/1.1” 500 2102 “http://groupware/egroupware/index.php?menuaction=calendar.calendar_uiviews.day&date=20130702” "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:22.0) Gecko/20100101 Firefox/22.0"
192.168.1.173 - - [20/Jul/2013:23:23:59 +0200] “GET /egroupware/phpgwapi/js/jsapi/egw.js HTTP/1.1” 304 - “http://groupware/egroupware/index.php?menuaction=addressbook.addressbook_ui.index” "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:22.0) Gecko/20100101 Firefox/22.0"
192.168.1.173 - - [20/Jul/2013:23:23:59 +0200] “GET /egroupware/phpgwapi/config.php?1369261132 HTTP/1.1” 304 - “http://groupware/egroupware/index.php?menuaction=addressbook.addressbook_ui.index” "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:22.0) Gecko/20100101 Firefox/22.0"
192.168.1.173 - - [20/Jul/2013:23:23:59 +0200] “GET /egroupware/phpgwapi/user.php?1374352875&user=olden HTTP/1.1” 304 - “http://groupware/egroupware/index.php?menuaction=addressbook.addressbook_ui.index” "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:22.0) Gecko/20100101 Firefox/22.0"
192.168.1.173 - - [20/Jul/2013:23:23:59 +0200] “GET /egroupware/phpgwapi/images.php?1369261132&template=idots HTTP/1.1” 304 - “http://groupware/egroupware/index.php?menuaction=addressbook.addressbook_ui.index” “Mozilla/5.0 (Windows NT 6.1; WOW64; rv:22.0) Gecko/20100101 Firefox/22.0”

Ralf_Becker_Stylite 2013-07-25 07:10:54 UTC #2

Hi,

Hi,

I´m using the latest svn checkout of trunk (Version 1.9.019) on an actual
Debian system with postgresql 9.1. Until the last checkout, a few days ago,
all works well. Today I got the following checkout by opening the
Addressbook right after the last checkout:

Database error

Invalid SQL: SELECT DISTINCT egw_addressbook.* FROM egw_addressbook WHERE
account_id IS NULL AND contact_tid != ‘D’ AND
(egw_addressbook.contact_owner=12 OR contact_private=0 AND
egw_addressbook.contact_owner IN (-9,12,0) OR egw_addressbook.contact_owner
IS NULL) ORDER BY n_family<>’’ DESC,n_family ASC,n_given ASC,org_name ASC
FEHLER: bei SELECT DISTINCT müssen ORDER-BY-Ausdrücke in der Select-Liste
erscheinen
LINE 1: …R egw_addressbook.contact_owner IS NULL) ORDER BY n_family<>…
^ (-1)

The last checkout before is a few days ago. If you need any further info,
feel free to ask.

Just checked it today and I cant reproduce what you describe.

Please check again after updating, as I fixed quite a few problems in
that area in the last days.

Ralf

Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk

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

snotty77 2013-07-25 20:45:44 UTC #3

Hi,

many thanks for the quick fix. It seems that r43178 has done the job. Now there is one thing left (I do not know if it is new because I have not testet it in the last few days):

If I try to open an infolog-entry, I get the following error:
Database error

Invalid SQL: SELECT ,egw_pm_projects.pm_id AS pm_id,BIT_OR(role_acl) AS role_acl FROM egw_pm_projects LEFT JOIN egw_pm_members ON (egw_pm_projects.pm_id=egw_pm_members.pm_id AND member_uid IN (12 ,-10,-9)) LEFT JOIN egw_pm_roles ON egw_pm_members.role_id=egw_pm_roles.role_id WHERE pm_status=‘active’ AND (pm_access=‘anonym’ OR pm_access=‘public’ AND pm_creator IN (12) OR pm_access=‘private’ AND pm_creator IN (12) OR role_acl!=0) GROUP BY egw_pm_projects.pm_id, ORDER BY pm_number
FEHLER: Syntaxfehler bei »«
LINE 1: …2) OR role_acl!=0) GROUP BY egw_pm_projects.pm_id, ORDER BY…
^ (-1)

It make no difference if I try if from within the calendar or in the Infolog-app. The list of Infologentrys seems ok. I have tried it with the latest checkout r43227

Ralf_Becker_Stylite 2013-07-26 07:13:32 UTC #4

Hi,

Hi,

many thanks for the quick fix. It seems that r43178 has done the job. Now
there is one thing left (I do not know if it is new because I have not
testet it in the last few days):

If I try to open an infolog-entry, I get the following error:
Database error

Invalid SQL: SELECT ,egw_pm_projects.pm_id AS pm_id,BIT_OR(role_acl) AS
role_acl FROM egw_pm_projects LEFT JOIN egw_pm_members ON
(egw_pm_projects.pm_id=egw_pm_members.pm_id AND member_uid IN (12 ,-10,-9))
LEFT JOIN egw_pm_roles ON egw_pm_members.role_id=egw_pm_roles.role_id WHERE
pm_status=‘active’ AND (pm_access=‘anonym’ OR pm_access=‘public’ AND
pm_creator IN (12) OR pm_access=‘private’ AND pm_creator IN (12) OR
role_acl!=0) GROUP BY egw_pm_projects.pm_id, ORDER BY pm_number
FEHLER: Syntaxfehler bei »«
LINE 1: …2) OR role_acl!=0) GROUP BY egw_pm_projects.pm_id, ORDER BY…
^ (-1)

It make no difference if I try if from within the calendar or in the
Infolog-app. The list of Infologentrys seems ok. I have tried it with the
latest checkout r43227

Is now also fixed (r43228).

Thanks for reporting it

Ralf

Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

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

snotty77 2013-07-27 22:04:53 UTC #5

Yes, it works! Many thanks for the quick fix!

Greetings

Snotty