Re: [Tiki-devel] MySQL error / System error: sorting members of a group by 'Assign'

[Jonny B. <jo...@ti...>]

Oops, sorry - i know we're not supposed to do it like this but i thought i'd just have a look and have accidentally fixed it in trunk in r47080 - please do backport as required.

Was so easy to reproduce... ;)

jb


On 15 Aug 2013, at 04:29, Pascal St-Jean <pas...@gm...> wrote:

> If you could submit an official bug report and reproduce using show that would be very appreciated and also easier for us to track and solve.
> 
> Thank you
> 
> On Aug 14, 2013 9:44 PM, "Frank Guthausen" <fg-...@da...> wrote:
> Hello.
> 
> I noticed a SQL related bug. Try admin groups, choose any group, go to
> tab 'Members'. Try sorting the tracker output by 'Assign' (desc or asc
> is not important AFAICS).
> 
> Error page with message:
> 
> | System error.
> |
> | The following error message was returned:
> |
> | Column 'created' in order clause is ambiguous
> | [...]
> 
> Can anyone reproduce/confirm that?
> 
> 
> Another issue: the tab 'Members' is not stable at
> reload. The tab switches back to 'Edit group foo'.
> 
> 
> regards
> Frank
> --
> sorry, less time than usual because of server hardware problems
> 
> ------------------------------------------------------------------------------
> Get 100% visibility into Java/.NET code with AppDynamics Lite!
> It's a free troubleshooting tool designed for production.
> Get down to code-level detail for bottlenecks, with <2% overhead.
> Download for free and get started troubleshooting in minutes.
> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
> _______________________________________________
> TikiWiki-devel mailing list
> Tik...@li...
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
> ------------------------------------------------------------------------------
> Get 100% visibility into Java/.NET code with AppDynamics Lite!
> It's a free troubleshooting tool designed for production.
> Get down to code-level detail for bottlenecks, with <2% overhead. 
> Download for free and get started troubleshooting in minutes. 
> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk_______________________________________________
> TikiWiki-devel mailing list
> Tik...@li...
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel