Discussion:
[Koha] 'timeout' changed
Katharina Penner
2018-08-13 13:13:05 UTC
Permalink
I guess I've made a stupid mistake and now cannot correct it.

While fixing settings in the Global systems preferences under
Administration I've changed in the 'timeout' line the '1d' to '1h', hoping
that this will reduce the timeout from one day to one hour. However, it
seems to have reduced it to one second! And I can do nothing in the system
because of such short time.
While now trying to change it back - as soon as I try to save the change it
says, Error, change possibly not saved. I guess I'm simply not quick enough
to do it all in one second!
Please help me to fix it back to 1d.

Katharina Penner
_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https://lists.
Owen Leonard
2018-08-13 13:25:08 UTC
Permalink
Do you have access to the database? If so you could update it directly:

UPDATE systempreferences SET value = '1d' WHERE variable = 'timeout';

-- Owen
--
Web Developer
Athens County Public Libraries
http://www.myacpl.org
_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
Michael Kuhn
2018-08-13 13:29:59 UTC
Permalink
Hi Katharina
Post by Katharina Penner
I guess I've made a stupid mistake and now cannot correct it.
While fixing settings in the Global systems preferences under
Administration I've changed in the 'timeout' line the '1d' to '1h',
hoping that this will reduce the timeout from one day to one hour.
However, it seems to have reduced it to one second! And I can do
nothing in the system because of such short time.
While now trying to change it back - as soon as I try to save the
change it says, Error, change possibly not saved. I guess I'm simply
not quick enough to do it all in one second!
Please help me to fix it back to 1d.
I would assume you should be able to change parameter "timeout" back to
the old value using this SQL statement in your database:

UPDATE systempreferences SET timeout="1d";

If you want to set timeout to one hour you probably need to change it to
"3600" (meaning 3'600 seconds, the equivalent of 1 hour).

Hope this helps.

Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E ***@adminkuhn.ch · W www.adminkuhn.ch
_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co
Michael Kuhn
2018-08-13 13:35:39 UTC
Permalink
Hi
Post by Michael Kuhn
Post by Katharina Penner
I guess I've made a stupid mistake and now cannot correct it.
While fixing settings in the Global systems preferences under
Administration I've changed in the 'timeout' line the '1d' to '1h',
hoping that this will reduce the timeout from one day to one hour.
However, it seems to have reduced it to one second! And I can do
nothing in the system because of such short time.
While now trying to change it back - as soon as I try to save the
change it says, Error, change possibly not saved. I guess I'm simply
not quick enough to do it all in one second!
Please help me to fix it back to 1d.
I would assume you should be able to change parameter "timeout" back
UPDATE systempreferences SET timeout="1d";
I'm sorry, forget my suggestion... Owen's syntax is the correct one:

UPDATE systempreferences SET value = '1d' WHERE variable = 'timeout';

Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E ***@adminkuhn.ch · W www.adminkuhn.ch
_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo
Loading...