Re: [Phpgroupware-developers] todo list - ORDER BY clause

[Ralf Becker]

Michal Weis wrote:
> Hello All,
>
> I'm using Version-0_9_16-branch tag CVS version of phpgroupware. 
>
> May be it is my fault in settings, may be it is a bug, but time-to-
> time (estimating more than 50% of logging-in), todo application 
> displays strange SQL error:
>
>   "SELECT * FROM phpgw_todo WHERE todo_owner='3' AND
>    todo_access='private' ORDER BY   LIMIT 15"

Do you have mcrypt enabled? If yes, try switching it off (you will loose 
the custom email-pw's and the sessiondata is of cause not longer encrypted.

Ralf

> where in order-by clause contains two random characters. it cames 
> from file todo/inc/class.so.inc.php, line 127, where the command is 
> beeing assembled, but it is based on $order comming as parameter. 
> it arrives from todo/inc/class.bo.inc.php, line 217, which is a 
> _list() function, i assumed called indirectly through the hook-
> tables.
> Is there anything I should setup in apps or how to avoid this?
>
> thanks for hint
>
> mike
>
>
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers

--
----------------------------------------------------------------------
Ralf Becker
digital ROCK, Becker & Macht GbR            Telefon +49 (631) 31657-51
Leibnizstraße 17                            Telefax +49 (631) 31657-52
D-67663 Kaiserslautern                 EMail address@hidden