Allow "DESC" ordering on CommentTableField

[mariocesar]

Using the SVN 48175 rev, the admin/comments get a Fatal Error

FATAL ERROR: DATABASE ERROR: Couldn't run query: SELECT `PageComment`.*,
`PageComment`.ID, if(`PageComment`.ClassName,`PageComment`.ClassName,
'PageComment') AS RecordClassName FROM `PageComment` WHERE (Created DESC)
ORDER BY Created DESC | You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax
to use near 'DESC) ORDER BY Created DESC' at line 1
At line 431 in /var/www/sczlearn/sapphire/core/model/Database.php

The declared WHERE (Created DESC) appears to be a Syntax SQL Error. The SQL Query is already sorting the Created field.

[mariocesar]

Patch to solve FATAL ERROR Sql Syntax on cms/code/CommentTableField.php

[sminnee]

It looks like the underlying issue here is that ComplexTableField? can't have "DESC" in the default sort column.

Can we fix that bug instead? :-)

[sminnee]

Simple patch applied in r65783; better solution will be left until 2.4.