[Koha] Check in time is behind system time
mahsandu at gmail.com
Wed Jul 5 16:20:54 NZST 2017
Thanks for the hint. It was mysql database server timezone
misconfiguration. I am using MariaDB. I have solved the problem as below:
command "date" returned right date and time
but in mysql
SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);
returned -7.00 UTC Time. But my time zone is +6.00 that was the problem.
The I have set the right timezone.
SET time_zone = "+06:00";
and restarted mysql server. The problems are gone. I have followed this (
to set the timezone.
Thanks again for your help.
On Tue, Jul 4, 2017 at 10:05 PM Barton Chittenden <
barton at bywatersolutions.com> wrote:
> Log on to your koha server via SSH.
> If this isn't correct, you'll have to change the date on the Linux server.
> I'm assuming that you've got a package install of koha. You'll need to
> know the instance name of your koha installation... replace INSTANCE with
> the actual instance name below.
> sudo koha-myqsql INSTANCE
> at the SQL prompt, type
> SELECT CURRENT_DATETIME;
> if these two do not agree, my guess is that you're running your database
> on a separate server. Exit mysql and type
> sudo grep '^..host' /etc/koha/sites/INSTANCE/koha-conf.xml
> if that shows a different server, SSH into that machine and type 'date'.
> Change the date there if needed.
> Hope that helps.
> On Tue, Jul 4, 2017 at 5:41 AM, Mubassir Ahsan <mahsandu at gmail.com> wrote:
>> Hello All,
>> Recently I have got that checkin time is behind the system time. My
>> System is 04 July 3:39PM but when check in items it is showing 2.19AM
>> even in notices time is printing like this. I have check the hardware and
>> system time, it is ok.
>> Check out time is ok.
>> Thanks in advance.
>> *Best wishes.*
>> *Md. Mubassir AhsanAssistant Librarian(Library In-Charge)Southeast
>> *Mobile+Viber+IMO: 01916303060 <01916-303060>*
>> *Facebook:* mmahsan <http://facebook.com/mmahsan>
>> *Skype+Twitter*: mahsandu
>> Website: Mubassir.info
>> *"Proud to be a LIS Professional*"
>> *Tag: Web Developer, CMS (Drupal, Joomla), ILS (Koha), IR (DSpace,
>> Greenstone), N/W Admin, DBA.*
>> Koha mailing list http://koha-community.org
>> Koha at lists.katipo.co.nz
*Md. Mubassir AhsanAssistant Librarian(Library In-Charge)Southeast
*Facebook:* mmahsan <http://facebook.com/mmahsan>
*"Proud to be a LIS Professional*"
*Tag: Web Developer, CMS (Drupal, Joomla), ILS (Koha), IR (DSpace,
Greenstone), N/W Admin, DBA.*
More information about the Koha