Bugs item #2931429, was opened at 2010-01-13 10:59
Message generated for change (Comment added) made by lem9
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=2931429&group_id=23067
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Data insertion/extraction/manipulation
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Hardcode (hardcodear)
Assigned to: Nobody/Anonymous (nobody)
Summary: long querys cant be sent via GET
Initial Comment:
In my case, i had a very long trigger for mysql. so i needed to edit that trigger but the querystring was too damn long.
the simplest way i could think to solve it was this:
file "libraries/tbl_triggers.lib.php" near line 34 added
$_SESSION["__session__sql"] = $drop_and_create;
near line 45 changed this
'<a href="tbl_sql.php?' . $url_query . '&amp;sql_query=' . urlencode($drop_and_create) . '&amp;show_query=1&amp;delimiter=' . urlencode($delimiter) . '">' . $titles['Change'] . '</a>',
for this
'<a href="tbl_sql.php?' . $url_query . '&amp;sql_query=' . '&__session_sql=1&amp;show_query=1&amp;delimiter=' . urlencode($delimiter) . '">' . $titles['Change'] . '</a>',
so now the query is saved in a session var, and doesnt travel via GET
in the file 'libraries/sql_query_form.lib.php'
near line 80 changed this
if (true === $query) {
$query = $GLOBALS['sql_query'];
}
for this
if (true === $query) {
if($_GET["__session_sql"]) {
$query = $_SESSION["__session__sql"];
} else {
$query = $GLOBALS['sql_query'];
}
}
problem solved, i hope this helps anyone
it attaching both files, this is phpMyAdmin - 2.11.8.1deb5+lenny1
----------------------------------------------------------------------
>Comment By: Marc Delisle (lem9)
Date: 2010-01-26 13:05
Message:
In other similar cases we use a form instead of a link. See
PMA_linkOrButton() in libraries/common.lib.php.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=2931429&group_id=23067