Nov 2017
14 / 14
Dec 2017
Dec 2017
evgenv
Nov '17

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 :slight_smile:

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

RalfBeckerEGroupware GmbH
Dec '17

Hi Evgen,

we have not done any testing with PostgreSQL so far :frowning:

Looks like PostgreSQL needs an explicit cast there.

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

Ralf

J_Roeleveld
Dec '17

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…

RalfBeckerEGroupware GmbH
Dec '17
J_Roeleveld

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
Dec '17

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

J_Roeleveld
Dec '17

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

Thank you

evgenv
Dec '17
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
Dec '17
RalfBecker
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
StefanUEGroupware GmbH
Dec '17

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