Developers

developers@phpmyadmin.net

2 participants
7003 discussions

[Phpmyadmin-devel] Allow specifying mime types and transformations in queries
by Chanaka Dharmarathna 02 Aug '12

02 Aug '12

Hi Michal, I'm trying to implement titled feature. [0] In current PMA, mime type transformations sometimes not working properly if the query is selecting only field with transformation. Sometime means, if the row data string is more lengthy, data is not transformed as expected. (data with string length > 1000) Due to that, where clause for linking a image (as example) is not setting. (comparison data is too heavy) If I use manually where clause, this will display properly. So as I think this can fix for only tables with primary key/unique key other than the field with transform. So that there may be a possibility to create where clause by executing sql (which related to display only field with transformation) with modification for retrieve both primary/unique key field and the relevant field and display only the relevant field with setting where clause properly. Any thoughts on this ? [0] : http://sourceforge.net/tracker/index.php?func=detail&aid=3112137&group_id=2… Regards ! *Chanaka*

1 1

[Phpmyadmin-devel] FAO: Michal. Dealing with merge conflicts in po files
by Rouslan Placella 02 Aug '12

02 Aug '12

Hi Michal, I just had a conflict while merging QA_3_5 into master and I wasn't sure how to resolve it. The problem was the po file for Catalan language that was heavily modified in d72f329301c28d222facce53e3da67deeb41b782. So, the first question is: why didn't Weblate merge QA_3_5 into master after committing? And if it didn't merge because of the conflicts, then why did it commit and push something that cannot be automatically merged in the first place? And the second question is: what is the correct thing to do when something like that happens? What I did was discard all the changes in that l10n file from the QA_3_5 branch, although I'm not sure if this might have any implications (losing some translated strings?)... Bye, Rouslan

2 2

[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] FAO: Chanaka. Can't drop tracking from table in master
by Rouslan Placella 01 Aug '12

01 Aug '12

Hi Chanaka, I've found a bug in master and after bisecting it looks like you've introduced it. > 39d37fafcce29160c4dfe6ef7696de19bebb1d18 is the first bad commit To reproduce: * Enable configuration storage * Activate tracking on any table with default options * Go back to the database in which the table in question is * Select the tracking tab * Click "Drop" near the tracking entry you created * You will get an internal server error From my error.log: roccivic@gentile-desktop:~/www/pma$ tail -n 1 /var/log/apache2/error.log [Wed Aug 01 19:10:31 2012] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined function PMA_query_as_controluser() in /home/roccivic/www/pma/libraries/Tracker.class.php on line 374, referer: http://localhost/pma/db_tracking.php?db=test3&token=f01096a0fa6885a13fcc199… Bye, Rouslan

2 1

[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

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

Developers