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
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*
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
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
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
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
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*
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