Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 
Advanced search

2505 Posts in 648 Topics- by 1314 Members - Latest Member: Saudi Arabia

eTicket CommunitySupportInstallation Help & Software Support (Moderators: jason, Hummdis)Topic: [SOLVED] Answers Have A Wrong Time
« previous next »
Pages: [1]   Go Down
Print
Author Topic: [SOLVED] Answers Have A Wrong Time  (Read 1599 times)
0 Members and 1 Guest are viewing this topic.
renekuehn
New Member
*

Karma: +1/-0
Offline Offline

Posts: 2
« on: August 24, 2008, 02:05:23 AM »
Hi,
I hope you can help me.
In the settings I use the timezone GMT +02:00 (Jerusalem) [system timezone: +0200]. When I'm opening a new ticket or the system is getting a new message via POP3 or I'm writing a private message (internal note), the time is correct.
When I'm answering, the time is 2 hours in future. What can I do to solve this problem?

eTicket version: 1.7.2

(Sorry for my bad English)
« Last Edit: March 11, 2009, 04:18:01 AM by Hummdis » Logged
renekuehn
New Member
*

Karma: +1/-0
Offline Offline

Posts: 2
« Reply #1 on: August 24, 2008, 05:01:06 AM »
OK. I think I solved this.

In inc/class.ticket.php on line 411 I added "timestamp" and in line 412 I added "UTC_TIMESTAMP()".

My changes:
Code:
$sql = "INSERT INTO " . $db_table['answers'] . " (ticket, message, rep, reference, timestamp) ";
$sql.= "VALUES('$ticket', $sql_message, '$repid', '$refid', UTC_TIMESTAMP())";

Original:
Code:
$sql = "INSERT INTO " . $db_table['answers'] . " (ticket, message, rep, reference) ";
$sql.= "VALUES('$ticket', $sql_message, '$repid', '$refid')";[/

For me it works fine.
Logged
beven
Project Manager/Developer
Global Moderator
Super Member
*****

Karma: +12/-4
Offline Offline

Posts: 804


WWW
« Reply #2 on: August 24, 2008, 12:03:16 PM »
Yes this bug was discovered while working on version 2, and it has been resolved.
Logged
Not to be confused with Bob Evans.
Ask not what eTicket community can do for you - ask what you can do for eTicket community.

Version 2 coming out shortly.
eTicket Community
   
 Logged
Pages: [1]   Go Up
Print
eTicket CommunitySupportInstallation Help & Software Support (Moderators: jason, Hummdis)Topic: [SOLVED] Answers Have A Wrong Time « previous next »
Jump to: