Problem sorting by date in list view

maxbel

Hi,

I've got a simple module containing two date related fields (one column has a DATE type and the other is a TIMESTAMP). In the list view with any or both of these columns showing, if I try to sort (order) any of these two columns, I get the spinning wheel and everything freezes. Sorting any other column works fine.

Any ideas?

Thank you!

maxbel

I've found the source of the problem. It is not related to the column type. In fact, the crash occurs anytime I try to sort a column that has an alias containing a space (in my list_items function).

For example, sorting de TEXTE column if...
$this->db->select('id_act, act_titre as TITRE, act_texte as "TEXTE"...
...woks fine and sorting de TEXTE_TEST if...
$this->db->select('id_act, act_titre as TITRE, act_texte as "TEXTE_TEST"...
also works.

However sorting TEXTE TEST if...
$this->db->select('id_act, act_titre as TITRE, act_texte as "TEXTE TEST"...
will fail (everything freezes), throwing an SQL syntax error.

I can work around by not using any spaces in my aliases, but it might be something to look into.