In egroupware 17.1 I have a problem with capturing infolog

evgenv 2017-11-28 08:43:34 UTC #1

Hello,

my egroupware community version runs on linux centos 7 and postgres database 9.6 … everything works ok except infolog. let me know the next announcement

Database error

Invalid SQL: SELECT main.info_id FROM egw_infolog main LEFT JOIN egw_infolog_users ON main.info_id=egw_infolog_users.info_id AND egw_infolog_users.info_res_deleted IS NULL LEFT JOIN egw_infolog_users attendees ON main.info_id=attendees.info_id AND attendees.info_res_deleted IS NULL WHERE ( (info_owner=5 OR (egw_infolog_users.account_id IN (-2,-1,5) AND egw_infolog_users.info_res_deleted IS NULL) OR info_owner=5 OR (info_access=‘public’ AND info_owner=5)) AND NOT (info_status IN (‘deleted’,‘template’,‘nonactive’,‘archive’)) ) GROUP BY main.info_id
ERROR: operator does not exist: character varying = integer
LINE 1: … ( (info_owner=5 OR (egw_infolog_users.account_id IN (-2,-1,…
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. (-1)

best regards
Evgen vodopivec

RalfBecker 2017-12-02 02:09:12 UTC #2

Hi Evgen,

we have not done any testing with PostgreSQL so far

Looks like PostgreSQL needs an explicit cast there.

I will look into it and let you know when it’s fixed.

Ralf

RalfBecker 2017-12-02 02:31:14 UTC #3

Hi Evgen,

should be fixed with this commit https://github.com/EGroupware/egroupware/commit/83caee0edd5cc181da3e4d6a46099173d84956a9

Just download https://raw.githubusercontent.com/EGroupware/egroupware/17.1/infolog/inc/class.infolog_so.inc.php and replace it in your installation.

Let me know if that fixes your issue and - of cause - if you have any other issues with PostgreSQL.

Ralf

J_Roeleveld 2017-12-03 12:38:43 UTC #4

Ralf,

Is this file included when I do a fresh install using “git”?
If yes, then there is still at least an issue when creating a new todo-item:

Database error

Invalid SQL: SELECT *,ARRAY_TO_STRING(ARRAY_AGG(account_id), ‘,’) AS info_responsible,ARRAY_TO_STRING(ARRAY_AGG(info_res_attendee), ‘,’) AS info_cc,egw_infolog.info_id AS info_id FROM egw_infolog LEFT JOIN egw_infolog_users ON egw_infolog.info_id=egw_infolog_users.info_id AND egw_infolog_users.info_res_deleted IS NULL WHERE egw_infolog.info_id=1 GROUP BY egw_infolog.info_id
ERROR: column “egw_infolog_users.info_res_id” must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT *,ARRAY_TO_STRING(ARRAY_AGG(account_id), ‘,’) AS info…

evgenv 2017-12-03 16:42:19 UTC #5

Hello !

Thanks for the help.
When I changed the file by the instructions, it tells me after restarting the following

Best regards

Evgen Vodopivec

RalfBecker 2017-12-06 01:23:51 UTC #6

I believe you still use the old version, maybe you copied the new file in the wrong directory …

Ralf

RalfBecker 2017-12-06 01:35:56 UTC #7

Yes, it is included when you do a new git install or pull the latest changes.

I believe you found a new issue. I will have a look and report back, when I have a fix (maybe later today).

Ralf

J_Roeleveld 2017-12-06 07:27:01 UTC #8

Thank you.
I will upgrade the install when you want me to test a new version.
Where do you prefer me to report my findings? In this thread? Or create new ones?

–
Joost

RalfBecker 2017-12-06 13:31:46 UTC #9

This is fixed now in Git, so please pull again to get the newest update AND report back if it works now. It does with my PostgreSQL 9.5.

Ralf

J_Roeleveld 2017-12-06 15:09:25 UTC #10

Ralf, this is fixed now. I can create infolog items (TODO) without any error showing.

Thank you

RalfBecker 2017-12-07 08:32:45 UTC #11

Please mark it as resolved.

Ralf

evgenv 2017-12-11 14:54:52 UTC #12

Hello! After reinstalling the latest update, I still report the following error:
<img src="/uploads/default/original/2X/d/d4d325699799c4f346f50ab1dcb128ae84bb6647.png" alt="Slika v vrstici 1" width="561" height="126">

Best regards

Evgen Vodopivec

evgenv 2017-12-11 15:03:43 UTC #13

Hello

I apologize for the speedy mail sent by the previous mail.

After the last installation and repair I received from you, the thing works.
Thank you very much for your cooperation and help

Best regards
Evgen Vodopivec

StefanU 2017-12-11 15:11:19 UTC #14

Hello Evgen,

if an answer solves your problem or if you tell us the answer in your own post, please mark the answer as solution. I have described how to do this:

This helps me and everyone else to keep track of things. Thank you.

You can delete posts.
The mail will only be sent after 10 minutes by e-mail to the mailing list participants, until then you have time to change or delete.

And please note: 1 problem = 1 thread

Greetings
Stefan