Hi, I accidentally run in this error with config_list_view and cms:field with sortable='1'.
After clicking in the admin menu on blog_category's sort icon:

Could not successfully run query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 50' at line 2

(page_hits work on the excepted way)

This is my config_list_view:

Code: Select all
<cms:template title="Blog" clonable="1">
    <cms:field 'blog_category' header='Category' sortable='1'>
      <cms:related_pages 'blog_category' >
         <cms:show k_page_title />
      <cms:field 'page_hits' header='Hits' sortable='1'>
         <cms:show page_hits />

I'm not planning to use this on my actual project, just want to report the error.