Bugs in webinterface

J_Roeleveld 2016-11-10 06:35:58 UTC #1

Hi,

I am seeing the following issues in the webinterface:

When creating a new TODO-item (Infolog) they get created in the database
with Id=0. This causes issues. Manually correcting the ID resolves this.
When deleting a calendar item, the webinterface shows an error "
"SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
for integer: “#e22705eac68c58e703820ac6b54c29d8” ". After refreshing (F5) the
website, the entry is actually gone.

I do not see these issues when using the GroupDAV interface.

Also, when trying to create an Eqroupware Trial on your website, it fails
with:

An error happened while creating your instance
MServer: MServer: Unknown instance_id or domain: egroupware.org

Kind regards,

Joost Roeleveld

Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi

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

RalfBecker 2016-11-10 08:19:29 UTC #2

Hi Joost,

Hi,

I am seeing the following issues in the webinterface:

When creating a new TODO-item (Infolog) they get created in the database
with Id=0. This causes issues. Manually correcting the ID resolves this.

Not sure I understand you correct: you create an InfoLog and it has
info_id=0 in the database?
Hmm, can’t reproduce that on 16.1 with MySQL/MariaDB. What branch and DB
are you using?

I see an error with PostgreSQL on master, which I need to fix …
It gives a straight SQL error when trying to save a new InfoLog.

When deleting a calendar item, the webinterface shows an error "
"SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax
for integer: “#e22705eac68c58e703820ac6b54c29d8” ". After refreshing (F5) the
website, the entry is actually gone.

Can NOT reproduce that either

I do not see these issues when using the GroupDAV interface.

Also, when trying to create an Eqroupware Trial on your website, it fails
with:

An error happened while creating your instance
MServer: MServer: Unknown instance_id or domain: egroupware.org

That one should be fixed now.

Ralf

Kind regards,

Joost Roeleveld

–
Ralf Becker
EGroupware GmbH [www.egroupware.org]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 631 31657-0

J_Roeleveld 2016-11-10 08:38:39 UTC #3

Hi Joost,

Hi,

I am seeing the following issues in the webinterface:

When creating a new TODO-item (Infolog) they get created in the
database
with Id=0. This causes issues. Manually correcting the ID resolves this.

Not sure I understand you correct: you create an InfoLog and it has
info_id=0 in the database?

Yes, that is correct.

Hmm, can’t reproduce that on 16.1 with MySQL/MariaDB. What branch and DB
are you using?

The most recent release. 20161107 (I think) and I use PostgreSQL.

I see an error with PostgreSQL on master, which I need to fix …
It gives a straight SQL error when trying to save a new InfoLog.

When deleting a calendar item, the webinterface shows an error "
"SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input
syntax for integer: “#e22705eac68c58e703820ac6b54c29d8” ". After
refreshing (F5) the website, the entry is actually gone.

Can NOT reproduce that either

Maybe also because I use PostgreSQL exclusively?

I do not see these issues when using the GroupDAV interface.

Also, when trying to create an Eqroupware Trial on your website, it fails
with:

An error happened while creating your instance
MServer: MServer: Unknown instance_id or domain: egroupware.org

That one should be fixed now.

ok, only wanted to use that to see if I can reproduce the issues there.

–
Joost

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

J_Roeleveld 2016-11-10 10:46:58 UTC #4

Hi Joost,

Hi,

I am seeing the following issues in the webinterface:

When creating a new TODO-item (Infolog) they get created in the
database
with Id=0. This causes issues. Manually correcting the ID resolves this.

Not sure I understand you correct: you create an InfoLog and it has
info_id=0 in the database?
Hmm, can’t reproduce that on 16.1 with MySQL/MariaDB. What branch and DB
are you using?

I see an error with PostgreSQL on master, which I need to fix …
It gives a straight SQL error when trying to save a new InfoLog.

Ralf,

I just noticed something else, the sequence “egw_infolog_info_id_seq” is not
updated either.
Checking the database schema, the default value for that record is set to use
the sequence.

The sequence itself also works, as using " select
nextval(‘egw_infolog_info_id_seq’::regclass); " provides a logical ID.
(executed inside a transaction which I aborted to avoid any possible database
issues.

Kind regards,

Joost

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

RalfBecker 2016-11-10 15:48:17 UTC #5

Hi Joost, Problem gefunden und behoben, bitte die folgende Datei bei
Ihnen austauschen:
https://raw.githubusercontent.com/EGroupware/egroupware/16.1/infolog/inc/class.infolog_so.inc.php
Und einen ggf. mit info_id=0 erzeugten Eintrag eine id geben: UPDATE
egw_infolog SET info_id=nextval(‘egw_infolog_info_id_seq’) WHERE
info_id=0 Ralf

Hi Joost,

Hi,

I am seeing the following issues in the webinterface:

When creating a new TODO-item (Infolog) they get created in the
database
with Id=0. This causes issues. Manually correcting the ID resolves this.
Not sure I understand you correct: you create an InfoLog and it has
info_id=0 in the database?
Hmm, can’t reproduce that on 16.1 with MySQL/MariaDB. What branch and DB
are you using?

I see an error with PostgreSQL on master, which I need to fix …
It gives a straight SQL error when trying to save a new InfoLog.
Ralf,

I just noticed something else, the sequence “egw_infolog_info_id_seq” is not
updated either.
Checking the database schema, the default value for that record is set to use
the sequence.

The sequence itself also works, as using " select
nextval(‘egw_infolog_info_id_seq’::regclass); " provides a logical ID.
(executed inside a transaction which I aborted to avoid any possible database
issues.

Kind regards,

Joost

Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi

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

J_Roeleveld 2016-11-10 18:36:56 UTC #6

Hi Joost, Problem gefunden und behoben, bitte die folgende Datei bei
Ihnen austauschen:
https://raw.githubusercontent.com/EGroupware/egroupware/16.1/infolog/inc/cla
ss.infolog_so.inc.php Und einen ggf. mit info_id=0 erzeugten Eintrag eine id
geben: UPDATE egw_infolog SET info_id=nextval(‘egw_infolog_info_id_seq’)
WHERE
info_id=0 Ralf

Hallo Ralf,

Vielen dank fuer die schnelle fix.
Many thanks for the quick fix.

–
Joost

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