BUG: cmsb 3.59: order by

I am testing cmsb 3.59 under php 8.1 with MariaDB v10.11.2 and getting the following error. This is happening whenever I have a left join.

Notice: MySQL Error: Column 'dragSortOrder' in order clause is ambiguous - in viewer_functions.php on line 343 by mysql_get_query in /Volumes/J/@projects/yaaws5/html/www/cmsb/lib/common.php on line 304

Here a sample getRecords call:

list($theRecords, $theMetaData) = getRecords(array(
    'tableName'   => 'bios',
    'where'       => $pageWhere,
    'loadUploads' => true,
    'allowSearch' => true,
    'leftJoin'    => array(
        'companies' => 'company'),
    'limit'       => '1',
    'debugSql'    => false,
));

It appears to picking up the orderBy clause from the editor sorting field, both tables have the dragSortOrder specified. 

WORK AROUND

Add a specific orderBy clause to the getRecords call with a fully qualified name 'orderBy' => "bios.dragSortOrder'.

NOTE:

This does happen with cmsb 3.57 and php 8.0