Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Tue Mar 19, 2024 5:02 am
Hosted Voice Broadcast


All times are UTC




Post new topic Reply to topic  [ 16 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: Wrong time and date in customer CDR
PostPosted: Wed Jun 24, 2009 4:30 am 
Offline

Joined: Fri Jul 07, 2006 4:58 pm
Posts: 28
Hello Areski,

I noticed that version 1.4 is not showing the correct date and time for CDRs under the customer's login.
The administrator shows the corerct time:

2009-06-24 00:10:31

but when I logon as a customer, the same call shows

06/24/2009 16:19:56

I tried changing the time zone for the customer but it does not make any difference. All calls show 14 hours difference in time.
Any suggestions?
Thanks


Top
 Profile  
 
 Post subject: Re: Wrong time and date in customer CDR
PostPosted: Wed Jun 24, 2009 4:52 pm 
Offline

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
Check the settings :
Server GMT server_GMT GMT-00:00 Define the sever gmt time

/Areski


Top
 Profile  
 
 Post subject: Re: Wrong time and date in customer CDR
PostPosted: Wed Jun 24, 2009 6:23 pm 
Offline

Joined: Fri Jul 07, 2006 4:58 pm
Posts: 28
Hello Areski,

I had that setting correct Server GMT server_GMT GMT-05:00 USA Estearn Standard.
I checked the user setting for time zone and it is in -5:00 as well but the calls still show:

06/24/2009 23:25:10 in the customer interface and 2009-06-24 14:25:10 in the administrator interface.

I restarted asterisk and also rebooted the server but no difference. Is there anything else I have to check?

Thanks


Top
 Profile  
 
 Post subject: Re: Wrong time and date in customer CDR
PostPosted: Wed Jun 24, 2009 7:04 pm 
Offline

Joined: Wed May 13, 2009 7:19 am
Posts: 24
Can you get calldate from mysql directly?
I get similar problem with CDR in customer UI.


Top
 Profile  
 
 Post subject: Re: Wrong time and date in customer CDR
PostPosted: Wed Jun 24, 2009 9:13 pm 
Offline

Joined: Fri Jul 07, 2006 4:58 pm
Posts: 28
Hi bgp,

If I ran a query in Mysql I see the same time I see in the admin interface. The admin interface is showing the correct time, it is the time in the customer interface the one is not displaying correctly.

I assume the system takes the CDR time from the cc_call starttime field and then applies the time zone selected for the customer so that when the customer views his call history this one is displayed correctly for him. If this is the case, it is not working. :shock:


Top
 Profile  
 
 Post subject: Re: Wrong time and date in customer CDR
PostPosted: Thu Jun 25, 2009 5:36 am 
Offline

Joined: Wed May 13, 2009 7:19 am
Posts: 24
Hi, asangio!

In my case calldate in CDR in customer ui displayed correctly only when TIMEZONE key set to GMT for customer. But if i set this key to GMT+03:00 (corresponding to my timezone) calldate in customer ui displayed whith 3 hours shift.
For server, server_GMT key set to GMT+03:00.


Top
 Profile  
 
 Post subject: Re: Wrong time and date in customer CDR
PostPosted: Thu Jun 25, 2009 4:03 pm 
Offline

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
I made a fix to use SERVER_GMT from the customer panel, see rev 2145.

Yours,
/Areski


Top
 Profile  
 
 Post subject: Re: Wrong time and date in customer CDR
PostPosted: Thu Jun 25, 2009 11:16 pm 
Offline

Joined: Fri Jul 07, 2006 4:58 pm
Posts: 28
Hello Areski,

I downloaded the latest code with the fix and the CDR time is showing correctly on the customer's inteface. It is working great! thanks!

Quick question though, how do I get rid of the PHP Quick Profiler bar that now displays at the bottom of the customer interface?

Thanks
Asangio


Top
 Profile  
 
 Post subject: Re: Wrong time and date in customer CDR
PostPosted: Fri Jun 26, 2009 2:15 am 
Offline

Joined: Fri Jul 07, 2006 4:58 pm
Posts: 28
I figured it out. Here is how to disable it:

In my case the path for the "common" folder is:
/var/www/html/common/lib
Just edit:
customer.defines.php

Change define ("PHP_QUICK_PROFILER", true);

to

define ("PHP_QUICK_PROFILER", false);


Top
 Profile  
 
 Post subject: Re: Wrong time and date in customer CDR
PostPosted: Sat Dec 31, 2011 6:37 am 
Offline

Joined: Thu Apr 21, 2011 5:22 pm
Posts: 106
I am using version 1.9.4 and I still have this problem. Customer CDR datetime is always wrong even after setting server_GMT and customer timezone correctly.


Top
 Profile  
 
 Post subject: Re: Wrong time and date in customer CDR
PostPosted: Thu Apr 05, 2012 5:26 pm 
Offline

Joined: Wed Feb 02, 2011 1:49 am
Posts: 2
I am having the same issue on both 1.9.3 and 1.9.4 for certain customers. Any ideas?

Thanks!

Drew


Top
 Profile  
 
 Post subject: Re: Wrong time and date in customer CDR
PostPosted: Fri Jun 01, 2012 10:13 am 
Offline

Joined: Tue Jun 22, 2010 8:37 pm
Posts: 152
Having same problem on a2billing 1.9.4 in the customer panel.

On admin panel is right.


Top
 Profile  
 
 Post subject: Re: Wrong time and date in customer CDR
PostPosted: Mon Jul 16, 2012 3:53 pm 
Offline

Joined: Wed Jun 30, 2010 10:00 am
Posts: 8
mysql time zone setting the MySQL time zone
Complete the following questions by MySQL to change the database time zone

# Change the time zone to UTC +01:00 (Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna)
mysql_query ("SET time_zone = '+01:00');
 
# Change the global time zone to UTC +01:00 (Requires "SUPER" privilege)
mysql_query ("SET GLOBAL time_zone = '+01:00');

SELECT CURRENT_TIMESTAMP; spend time


Top
 Profile  
 
 Post subject: Re: Wrong time and date in customer CDR
PostPosted: Wed Jun 17, 2015 12:18 am 
Offline

Joined: Wed Jun 17, 2015 12:10 am
Posts: 1
Hi,

i have A2Billing v2.0.11 and the issue still in customer panel.

Any update?

Best Regards,

Alex


Top
 Profile  
 
 Post subject: Re: Wrong time and date in customer CDR
PostPosted: Sat Jan 16, 2021 11:54 pm 
Offline

Joined: Mon Apr 09, 2007 7:18 pm
Posts: 43
A2Billing v2.0.4
CDR date in mysql and in admin interface is ahead of system time

+--------------------+
| @@global.time_zone |
+--------------------+
| SYSTEM |
+--------------------+
1 row in set (0.00 sec)

Any ideas?


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 16 posts ]  Go to page 1, 2  Next
Hosted Voice Broadcast


All times are UTC


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group