- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] server_status.php notices
by Marc Delisle 17 Jun '11

17 Jun '11

Hi, I get this with current master: Notice in ./server_status.php#655 Undefined variable: replication_types ./server_status.php#425: printServerTraffic() Warning in ./server_status.php#655 Invalid argument supplied for foreach() ./server_status.php#425: printServerTraffic() -- Marc Delisle http://infomarc.info

2 1

[Phpmyadmin-devel] Live charts broken for non-default server
by Piotr Przybylski 17 Jun '11

17 Jun '11

Hi, Live charts in server status are not working with non-default server - AJAX requests go to wrong address (& instead of &), eg.: http://demo.phpmyadmin.net/master/server_status.php?server=2&token=c6a8… -- Piotr Przybylski

2 2

[Phpmyadmin-devel] pma demo on IE8
by Tyron Madlener 17 Jun '11

17 Jun '11

...causes this error to appear: Unexpected call to method or property access. server_status.php?token=591885fce98decf2e85474787d3a04a4, line 2476 character 1 Happens in http://demo.phpmyadmin.net/master/

4 5

[Phpmyadmin-devel] Visualizing GIS data with OpenSteetMaps
by Madhura Jayaratne 17 Jun '11

17 Jun '11

Hi all, I pushed my changes related to 'Visualizing GIS data with OpenSteetMaps' feature into my repo and you can try that out at [1]. What this does is, it uses OpenStreetMaps as a base layer to visualize GIS data that relates to earth's geography. Spatial reference ID (SRID) of the GIS data is used to identify the spatial reference system being used and correctly project the data over the map. I'd be grateful if you could check the functionality at [1] (You can use data in the opengis database). Any feedback is most welcome! -- Thanks and Regards, Madhura Jayaratne [1] http://demo.phpmyadmin.net/gsoc-madhura

1 0

[Phpmyadmin-devel] js/server_status.js and localization
by Marc Delisle 16 Jun '11

16 Jun '11

Tyron, some messages are not localized, for example Connections since last refresh Connections / Processes Issued queries Issued queries since last refresh -- Marc Delisle http://infomarc.info

2 1

[Phpmyadmin-devel] Live charts and PHP 5.2
by Marc Delisle 16 Jun '11

16 Jun '11

Hi, server_status.php uses header_remove() that requires PHP 5.3. Was it discussed to change the requirement for minimum PHP version. -- Marc Delisle http://infomarc.info

4 5

[Phpmyadmin-devel] New server status code
by Piotr Przybylski 16 Jun '11

16 Jun '11

Hi, Code in server_status.php has some formatting and coding style issues: - array declarations on one line, - missing spaces around operators - Array instead of array Can somebody take a look at it? I don't want to introduce possible merge conflicts to people currently working on that code. -- Regards, Piotr Przybylski

2 2

[Phpmyadmin-devel] AJAXify phpMyAdmin Interface - GSOC 2011 - db_structure -> insert
by Thilanka Kaushalya 15 Jun '11

15 Jun '11

Hi Marc, I started working on my third task which is applying ajax behavior for "Insert for a table in Database structure" option. I will update you soon with the progress. Thank you. Regards, Thilanka. -- L G Thilanka Kaushalya Computer Science & Engineering, University of Moratuwa, Sri Lanka Connect with me at, Gmail : lgtkaushalya(a)gmail.com Twitter : @thilanka_k Facebook : Thilanka Kaushalya Yahoo : lgtkaushalya(a)yahoo.com Blog : http://coders-view.blogspot.com/

2 21

[Phpmyadmin-devel] GSoC 2011: Support for Routines
by Rouslan Placella 15 Jun '11

15 Jun '11

Hi there, I've had good progress this week with my work on support for routines and if you guys have some time I'd be very grateful if you could check out the currently implemented functionality on my demo server [1] and, if you have extra time on your hands, also the code in my repo [2]. Currently the "Add", "Edit", "Export" and "Drop" functionalities work well and are already integrated with AJAX. But the execute functionality is unfinished and doesn't really work too well yet with or without AJAX - it's what I'll be working on next week. Any feedback is most welcome! Thanks. Also my report for this week is available on my blog [3]. Rouslan [1]: http://demo.phpmyadmin.net/gsoc-rouslan/ [2]: http://repo.or.cz/w/phpmyadmin/roccivic.git/shortlog/refs/heads/rte [3]: http://roccivic.blogspot.com/2011/06/week-2-report.html

4 11

[Phpmyadmin-devel] Table charting pChart replacement
by Tyron Madlener 15 Jun '11

15 Jun '11

Wasn't sure of whether to mail this to Michal or the mailing list, but I guess a bigger audience also means more feedback :) I am in the process of replacing pChart in pma and finishing on the table charting feature. Since the pChart-Version was rather difficult to use I thought I'd offer the user some choice about which column data is used for what. While implementing, I was orienting in the examples given by http://wiki.phpmyadmin.net/pma/Charts#Data_formats_for_query_results_chart where I was slightly surprised by the odd data format of the examples. It doesn't allow any graph with more than 2 series. So I thought the most logical of way representing table data is by selecting one column as x-axis and let the other columns be different series within the graph. So looking at the examples, the logical continuation of example 2 would be: SELECT 225 AS 'Value1', 653 AS 'Value2', '2009-11' AS 'Month' UNION SELECT 1157, 855, '2009-12' UNION SELECT 569, 253, '2010-01' UNION SELECT 282, 455, '2010-02' UNION SELECT 2960, 3552, '2010-03' ...which will display the date on the X-Axis and 2 series (Value1 and Value2) in the graph. However, in order to allow data like in the original example3 I've added a select list where one can select what the series types should be. The default selection is to use all columns except the selected xaxis but you can also select a specific column from where it should read all possible types (so this column should probably be a ENUM or similar). So when charting the original example3 with Type set to Column, Series=Operator, X-Axis=Month and Stacking on we get the same result again. I'm not quite sure whether such solution will make sense for everyone so I'm asking here if it is :-) Current differences over the pChart implementation: - Everything updates as you type/select. No more Redraw button is required - New charting types: (Horizontal-)Bar and Spline - No editable Area/Legend Margins (who needs that?) - Have as many Series (=Columns-1) as you want, not only 3 - Select the column you want to be the x-axis, so you don't need to know by heart where in your query result the x-axis column is supposed to be. - If a column contains the word date or time it will be pre-selected as xaxis - No width/height selection, instead just mouse-drag the chart to the right size. Please check it out at http://demo.phpmyadmin.net/gsoc-tyron/ P.S.: There seems to be a problem when using the sql statements given on the wiki within the db links SQL page. Once the query is executed and you click on display chart or export it just redirects you to the main page again.

4 17