Dear Barton, 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 ( https://stackoverflow.com/questions/930900/how-do-i-set-the-time-zone-of-mysql) to set the timezone. Thanks again for your help. On Tue, Jul 4, 2017 at 10:05 PM Barton Chittenden < bar...@bywatersolutions.com> wrote: > Log on to your koha server via SSH. > > Type > > date > > 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. > > --Barton > > > On Tue, Jul 4, 2017 at 5:41 AM, Mubassir Ahsan <mahsa...@gmail.com> wrote: > >> Hello All, >> >> Recently I have got that checkin time is behind the system time. My >> current >> System is 04 July 3:39PM but when check in items it is showing 2.19AM >> only, >> 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 >> University* >> >> *-----------------------------* >> *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@lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > > -- *Best wishes.* *--------------------* *Md. Mubassir AhsanAssistant Librarian(Library In-Charge)Southeast University* *-----------------------------* *Mobile+Viber+IMO: 01916303060* *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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha