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
Jeff Shields