July 2012 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Upgrading sf.net project
by Michal Čihař 16 Nov '12

16 Nov '12

Hi maybe you've noticed, maybe not, but sf.net is slowly moving to new platform called Allura [1] and projects can opt in for upgrading. There seems to be quite a lot of improvements [2], especially in the Issue tracking (you can see Allura's own tickes [3] as an example). There are upgrading information on separate page [4] and none of not migrated things does not affect us, so I'd go for upgrade. Any comments on that? [1]:https://sourceforge.net/p/allura/ [2]:https://sourceforge.net/p/allura/wiki/Features/ [3]:https://sourceforge.net/p/allura/tickets/ [4]:https://sourceforge.net/p/upgrade/ -- Michal Čihař | http://cihar.com | http://blog.cihar.com

3 9

[Phpmyadmin-devel] Bug with properties system
by Marc Delisle 17 Aug '12

17 Aug '12

Hi, since this commit, the db Export panel no longer shows the SQL choice: 9458f9d06263822558d39e2a52fabafe40259bf1 is the first bad commit commit 9458f9d06263822558d39e2a52fabafe40259bf1 Author: Alex Marin <alex.ukf(a)gmail.com> Date: Tue Jul 17 13:32:13 2012 +0300 oop: integrate the properties system for ExportXml -- Marc Delisle http://infomarc.info

4 14

[Phpmyadmin-devel] New built in transformations and relations
by Chanaka Dharmarathna 02 Aug '12

02 Aug '12

Hi Michal, I'm going to look the titled feature request [0] while fixing the issues in my previous work. Feels its better to get more explanation on this. You have mentioned in feature description about the relations inside mysql database. Currently both mysql and information_schema databases are not have linked to each data rows where possible. Do you mean make those as links (for database, table, user etc) ? Is that same as the think saying in feature request [1] ? Can you explain what you really mean here ? And can they be real relations with foriegn keys ? (I'm not sure) [0] : https://sourceforge.net/tracker/?func=detail&aid=1327651&group_id=23067&ati… [1] : http://sourceforge.net/tracker/index.php?func=detail&aid=2950664&group_id=2… Regards ! *Chanaka*

2 4

[Phpmyadmin-devel] Refactoring db_operations: problem renaming a db
by Marc Delisle 31 Jul '12

31 Jul '12

Thilina, renaming a db gives multiple notices of missing variables and missing argument for function. As a result, renaming a db that contains a view has for effect that the view is lost. To see these warnings, please do your tests having this line in config.inc.php: $cfg['Error_Handler']['display'] = true; -- Marc Delisle http://infomarc.info

2 1

[Phpmyadmin-devel] addHtml() usage
by Thilina Buddika Abeyrathna 29 Jul '12

29 Jul '12

Hi Rouslan, How do I use addHtml() function for the following type code, <div class="-------"> <?php include('libraries/example.php'); ?> </div> I tried, $response->addHTML(<div class="........">) include 'libraries/example.php' $response->addHTML(</div>) But nothing displayed. And can we use both addHtml() and 'echo' in a script? -- Regards. Thilina Abeyrathna Gtalk : thilinaabeyrathna skype: thilinabuddika88 thilinaa.wordpress.com

2 3

[Phpmyadmin-devel] problem with ExportSql.class.php
by Marc Delisle 26 Jul '12

26 Jul '12

Hi Alex, I believe there is a problem with your implementation of getTableDef(). In the previous code, this function has the side effect of modifying several global variables, for example $sql_drop_foreign_keys. In the new implementation, if I'm not mistaken, you are getting these global variables but never setting their modified values in the global space for use by the calling script. I'm not advocating that you should continue using globals in this case, but we need a way to pass back these modified values, for example by passing back an array of results. Please coordinate with Thilina who is refactoring db_operations.php. -- Marc Delisle http://infomarc.info

3 2

[Phpmyadmin-devel] PhpMysql
by Atirek Goyal 26 Jul '12

26 Jul '12

Hi, Here is some error My scanner find here is the Description à “The version of phpMyAdmin hosted on the remote server is 3.4.x prior to 3.4.8 and is affected by a cross‑site scripting vulnerability. The database name is not properly sanitized in the file 'js/db_operations.js' when attempting to rename a database. Note that this version is reportedly affected by several other cross‑ site scripting vulnerabilities. However, Site Scanner has not tested for these vulnerabilities.” And they told me for the solution.. “Either apply the vendor patches or upgrade to phpMyAdmin version 3.4.8 or later.” When I about to access the same URL that will shows.. “$(document).ready(function(){$("#rename_db_form.ajax").live("submit",function(a){a.preventDefault();a=$(this);var d="CREATE DATABASE "+$("#new_db_name").val()+" / DROP DATABASE "+window.parent.db;PMA_prepareForAjaxRequest(a);var b={};b[PMA_messages.strYes]=function(){$(this).dialog("close").remove();window.parent.refreshMain();window.parent.refreshNavigation()};b[PMA_messages.strNo]=function(){$(this).dialog("close").remove()};a.PMA_confirm(d,a.attr("action"),function(e){PMA_ajaxShowMessage(PMA_messages.strRenamingDatabases); $.get(e,$("#rename_db_form").serialize()+"&is_js_confirmed=1",function(c){if(c.success==true){PMA_ajaxShowMessage(c.message);window.parent.db=c.newname;$("#topmenucontainer").next("div").remove().end().after(c.sql_query);c=$("#topmenucontainer").next("div").find(".notice");c.text()==""&&c.remove();$("<span>"+PMA_messages.strReloadDatabase+"?</span>").dialog({buttons:b})}else PMA_ajaxShowMessage(c.error)})})});$("#copy_db_form.ajax").live("submit",function(a){a.preventDefault();var d=PMA_ajaxShowMessage(PMA_messages.strCopyingDatabase); a=$(this);PMA_prepareForAjaxRequest(a);$.get(a.attr("action"),a.serialize(),function(b){$(".success").fadeOut();$(".error").fadeOut();if(b.success==true){$("#topmenucontainer").after(b.message);if($("#checkbox_switch").is(":checked")){window.parent.db=b.newname;window.parent.refreshMain();window.parent.refreshNavigation()}else window.parent.refreshNavigation(true)}else $("#topmenucontainer").after(b.error);PMA_ajaxRemoveMessage(d)})});$("#change_db_charset_form.ajax").live("submit",function(a){a.preventDefault(); a=$(this);PMA_prepareForAjaxRequest(a);PMA_ajaxShowMessage(PMA_messages.strChangingCharset);$.get(a.attr("action"),a.serialize()+"&submitcollation="+a.find("input[name=submitcollation]").attr("value"),function(d){d.success==true?PMA_ajaxShowMessage(d.message):PMA_ajaxShowMessage(d.error)})})},"top.frame_content");” è Here I am not able to update the version of phpMyAdmin currently I am using 3.4.5 version please suggest me how to “apply the vendor patches”. Thanks, Ati

2 4

[Phpmyadmin-devel] Bypassing row counting by default for performance reasons
by Marc Delisle 24 Jul '12

24 Jul '12

Hi, please give your opinions in this thread: [0]. I think that these users have a good point. [0] https://github.com/phpmyadmin/phpmyadmin/pull/83#issuecomment-7203730 -- Marc Delisle http://infomarc.info

1 0

[Phpmyadmin-devel] Display multiple query results
by Chanaka Dharmarathna 24 Jul '12

24 Jul '12

Hi Michal, I'm trying to implement titled case related to bug [0]. In current code, any SQL going to executed via SQL window, is processed and if there are more SQL queries, it detect only one query. So whole statement with any valid number of SQl queries need to be detected. Then by using mysql_multi_query() function all results related to multiple queries can be obtained. As I think displaying these results can be done with looping the result sets. Additionally I saw mysql_multi_query manual [1] mentioned that separate queries are identified by semicolon. May be I need to replace the delimiter if it is not a semicolon. Please put me into right track with your suggestions if my way is not correct. [0] : http://sourceforge.net/tracker/index.php?func=detail&aid=3474853&group_id=2… [1] : http://php.net/manual/en/mysqli.multi-query.php Regards ! *Chanaka*

3 11

[Phpmyadmin-devel] Automated Testing - GSoC 2012
by yasitha pandithawatta 23 Jul '12

23 Jul '12

Hi Michal, I am currently working on some selenium test cases. While I working on that I observe weird behavior, probably should be a bug. After changing your password there is no any confirmation message. This may be an usability issue. Again you click on the change password link there is only Go and Cancel buttons in the opened dialog box. Reason may due to re-factoring is going on. I am having a difficulty to access elements in the dialog box. I tried both is and xpath. May be those are dynamically created ones. Any method to access those? -- Yasitha Pandithawatta Undergraduate Computer Science and Engineering Department University of Moratuwa Sri Lanka

3 2