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:config_list_view>
...
    <cms:field 'blog_category' header='Category' sortable='1'>
      <cms:related_pages 'blog_category' >
         <cms:show k_page_title />
      </cms:related_pages>
      </cms:field>
      <cms:field 'page_hits' header='Hits' sortable='1'>
      <h3>
         <cms:show page_hits />
      </h3>
      </cms:field>
...
</cms:config_list_view>
</cms:template>


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