BUG: cmsb 3.59: order by

4 posts by 3 authors in: Forums > CMS Builder
Last Post: July 5, 2023   (RSS)

By kitsguru - June 4, 2023

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. 


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


This does happen with cmsb 3.57 and php 8.0

Jeff Shields

By Dave - June 4, 2023

Hi Jeff, 

Thanks for posting this, we'll check it out.  

Can you temporarily set debugSql => true, and post the query that is being generated (or the relevant parts of it). 


Dave Edis - Senior Developer

By Dave - July 5, 2023

Hi Mark,

Are you using a leftJoin option?  And if so can you try adding a fully qualified name?

'orderBy' => " yourtable.dragSortOrder DESC ",

Just make sure the table and fieldname match what you're using.

Let me know if that works for you.

Dave Edis - Senior Developer