[Phpmyadmin-devel] regarding bug #4245

[Viduranga Wijesooriya]

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 at 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.clktrk
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>



-- 
Best Regards
Viduranga Wijesooriya
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20140124/fe46cc3f/attachment.html>