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
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.
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@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.cl... _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Viduranga Wijesooriya a écrit :
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 ?
Yes, this makes sense.
P.S. please use bottom-posting on this list. http://en.wikipedia.org/wiki/Posting_style#Bottom-posting
On Thu, Jan 23, 2014 at 2:28 AM, Marc Delisle marc@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.cl... _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
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.cl...
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-
Marc Delisle -
Viduranga Wijesooriya