I checked the pma__table_uiprefs table. It's true that it stores the latest
"sort query". But even though I emptied that table, still records of
a particular table remain in the order which was sorted earlier. That means
sorting order doesn't get lost. But if I use a new browser window the
sorting order get lost. So I think it saves the current table order in
'pma__table_uiprefs'
table as well as in the session. But it doesn't use the data saved in
the 'pma__table_uiprefs'
table to sort the tables. It uses the data saved in the session to sort the
tables. Am I making sense to you ?
On Thu, Jan 23, 2014 at 2:28 AM, Marc Delisle <marc(a)infomarc.info> wrote:
Viduranga Wijesooriya a écrit :
Hi,
This regarding
https://sourceforge.net/p/phpmyadmin/bugs/4245/ .
I tried to fix it for hours, but I couldn't figure out some of the
things.
Bug is, phpmyadmin seems to loose the current
'select query' text after
clicking the browse button or selecting the same table again from the
navigation panel. But it seems to have stored the current order of the
table and also the value of "sort by key" select box. So I need to find
out
how they are stored. So we can use the same
method to store the query
also.
Can please you help ?
Thank you
Hi,
look at the phpMyAdmin configuration storage, pma__table_uiprefs. But do
not store the query, just ensure that the displayed query contains the
sorting parts.
--
Marc Delisle
http://infomarc.info |
http://phpmyadmin.net
------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today.
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.c…
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel