Issue Bug Closed

#14267sorting must be set for pi_list_query to work

old_cazoo 08/10/04, 16:07 updated 08/12/06, 14:26

Description

In class.tslib_pibase.php the function pi_list_query() specifies “orderBy” as an optional param. However, it fails if no orderBy (can be empty) is set. This also affects pi_exec_query().

For example this code:

$this->pi_list_query(“tx_some_table”);

… generates non-vaild SQL like this:

“ …. ORDER BY tx_some_table. LIMIT x,y”

(issue imported from #M280)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.