BUG: cmsb 3.59: order by

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

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). 

Thanks!

Dave Edis - Senior Developer
interactivetools.com

By mark99 - July 5, 2023

I get something similar after going from 3.57 to 3.59, also focused on line 304 of common.php:

E_USER_NOTICE: MySQL Error: Unknown column 'totalReviewsCount' in 'order clause' - in viewer_functions.php on line 543 by mysql_get_query()

Url: https://www....co.uk/../../?orderBy=totalReviewsCount&num=17

File Path: /../system/lib/common.php

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
interactivetools.com