Beim Update von der Community-Version 1.72 (1.17 rev 202111700 ) auf 1.18 (1.18 (rev 202211800) erscheint eine Fehlermeldung während des Datenbankupdates.

Die Fehlermeldung lautet:

Database error : Query error: ' SELECT isys_obj__id FROM isys_cats_person_list INNER JOIN isys_obj ON isys_obj.isys_obj__id = isys_cats_person_list__isys_obj__id WHERE isys_cats_person_list__disabled_login = 0 AND isys_cats_person_list__status = 2 AND isys_obj__status = 2 AND isys_cats_person_list__title = 'admin'': Unknown column 'isys_cats_person_list__disabled_login' in 'where clause'

Die Updateseite von i-doit mit der og. Fehlermeldung kann neu geladen werden, wenn das fehlende Feld mittels zB. phpmyadmin oder auch direkt in mysql in der Tabelle durch

ALTER TABLE isys_cats_person_list ADD isys_cats_person_list__disabled_login int(1) unsigned DEFAULT 0

vorher hinzugefügt wird.

Danach läuft das Update problemlos durch.

For all those, who have this problem, I found out the solution for the V4.1.15-8-default:

1st: keep cool (it took me several coffees to calm down on this silly thing. If the value for timeout is 0, so the setting is off or the value is wrong. Why the heck, wasn't this catched by the program??)

2nd: Login on your webserver, go into the i-doit-folder in the apache-webfiles (f.e. SuSE: /srv/www/htdocs/i-doit/…)
3rd: find the globals.inc.php
4th: open it with your favourite text-editor
5th: find and copy the following line:

$g_config["sess_time"]   = isys_settings::get('session.time', 300);

6th: uncomment one of the original one with two slashes

// $g_config["sess_time"]   = isys_settings::get('session.time', 300);

7th: change the copied line:

FROM

$g_config["sess_time"]   = isys_settings::get('session.time', 300);

TO

$g_config["sess_time"]   = 900;

8th: SAVE the file, but leave it open in your text-editor

9th: Login to i-doit and change the value for Session Timeout in the Settings. 3600 (1 hour) might be a good value. Save the sessings

10th: uncomment in the globals.inc.php

// $g_config["sess_time"]   = isys_settings::get('session.time', 300);

and comment the line

$g_config["sess_time"]   = 900;

That's it.