#4425 (ok 4.2.3) Status Monitor popup issues

[Richard]

RedHat 6.5
PHP 5.3.3
MariaDB 5.5.36
Firefox 29.0.1

1. The 'Log statistics' popup only works if you're clicking it when at an exact point in the data refreshing cycle.
2. Then when selecting results 'From slow log' or 'From general log' the time_start and time_end parameters that are sent are not those that I'd input.

Sorry if this is a duplicate or I've done anything wrong. This is my first bug report attempt.

[Madhura Jayaratne]

Thank you for your bug report.
About 1, Are you simply clicking on the charts on get the popup? Try clicking on a chart and dragging to right to select a time period.
About 2, The times are sent as 'epoch time values'. Try using the below external site [1] to covert them to human readable values.

[1] http://www.esqsoft.com/javascript_examples/date-to-epoch.htm

[Richard]

Hi Madhura,

1. I didn't realise about the click and drag functionality, and this works. Although, I'd suggest maybe giving some guidance as it took me ages to even figure out that the graphs were clickable (in an earlier version), and now they only seem to open on click and drag I think it'll make it even harder to uncover this functionality. Maybe you could add some guidance in the instructions/setup popup?

2. There's still the issue with the initial time value being sent in Firefox 29.0.1
   I've attached images to show this initial and changed. But here's a quick step by step:

clicked and dragged to open a popup

initial values were 2014-05-22 09:09:09 2014-05-22 09:09:26

changed the values to 2014-05-20 08:00:00 2014-05-22 09:09:26

clicked 'From slow log' button

this was the request sent http://[address_to_my_install_of_phpmyadmin]/server_status_monitor.php?token=00a28cdca512b7e822955da1db57f51a&ajax_request=true&log_data=1&type=slow&time_start=1400746149&time_end=1400746166&removeVariables=true&limitTypes=true&_nocache=1400746301863575780

note time_start and time_end equate to: 2014-05-22 09:09:09 2014-05-22 09:09:26 which are the initial opening values.

This isn't a problem in Chrome.

Thanks,

Richard

[Madhura Jayaratne]

About 1, Indeed, giving some guidance would be useful.
About 2, I can reproduce the problem with Firefox.

[Atul Pratap Singh]

About 2, I have changed it to use jQuery datepicker's "getdate" to resolve this date-format issue for Firefox. Madhura and Richard, could you confirm that https://github.com/phpmyadmin/phpmyadmin/commit/56d5ef04a0cf0a52cdd7082e43c6e62dc672f830 fixes it?

[Madhura Jayaratne]

@Atul
I get a new problem following the steps below.

1. Chose a time span and change 'from' time to some previous day. Submit and observe the parameters passed. They seem to be correct.
2. Now select a new time span and submit without any changes. Previously selected 'from' day is passed again.

[Atul Pratap Singh]

@Madhura Thanks, I have tried to fix that in https://github.com/phpmyadmin/phpmyadmin/commit/54e2c0f82accf03b4c9824dd838bd84d958620e0

[Richard]

Looks to be working correctly now for me.

Thanks.

[Atul Pratap Singh]

Ok, marking resolved. @Richard, we will soon add a suitable hint for selecting a time span.

[Richard]

Thanks @Atul

I'm finding myself using phpMyAdmin more and more over the likes of Workbench. It's a great application and improving all the time!