eTicket Community
September 02, 2010, 03:06:46 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Want to engage your customers? eTicket  will soon be incorporated into Help Center Live!, the Live Chat leader!
 
   Home   Help Search Login Register  
Quick Register
Choose username  Email                 
Verify password    Choose password 
I agree to Registration Agreement
eTicket Community > Support > Installation Help & Software Support (Moderators: jason, Hummdis) > Topic: [SOLVED] Answers Have A Wrong Time
Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: [SOLVED] Answers Have A Wrong Time  (Read 2216 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 Community > Support > Installation Help & Software Support (Moderators: jason, Hummdis) > Topic: [SOLVED] Answers Have A Wrong Time
 « previous next »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.8 | SMF © 2006-2008, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
Page created in 2.498 seconds with 22 queries.

Google visited last this page August 31, 2010, 01:13:31 PM