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:
(page_hits work on the excepted way)
This is my config_list_view:
I'm not planning to use this on my actual project, just want to report the error.
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.