LIST plugin failure in blog posts
- Status
- Open
- Subject
- LIST plugin failure in blog posts
- Version
- 15.x
- Category
- Conflict of two features (each works well independently)
- Feature
- Blog
Wiki Plugin (extends basic syntax) - Resolution status
- New
- Submitted by
- Jean-Marc Libs
- Lastmod by
- Jonny Bradley
- Rating
- Description
When I put the following LIST plugin showing the contents of a file gallery:
Copy to clipboard{LIST()} {filter field="gallery_id" content="4"} {LIST}I get a:
Copy to clipboardSystem error. The following error message was returned: Unknown column 'created' in 'order clause' The query was: SELECT * FROM `index_57c5a14334249` WHERE 1=1 AND (`searchable` = 'y' AND `gallery_id` = '4') ORDER BY `created` desc The built query was likely: SELECT * FROM `index_57c5a14334249` WHERE 1=1 AND (`searchable` = 'y' AND `gallery_id` = '4') ORDER BY `created` desc
This does not happen in the blog post preview or in a wiki page.- Workaround
Curious indeed, but it seems to be because tiki-view_blog_post.php uses a default sort_mode of "created_desc" for no apparent reason and this confuses the list plugin. There is a workaround though, you can specify the sort_arg for the pagination like this:
Copy to clipboard{LIST()} {pagination sort_arg="list_sort_mode"} {filter field="gallery_id" content="4"} {LIST}
and it then works ok (but who knew!?)- Importance
- 10 high
- Priority
- 50
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is currently unavailableUnable to connect to show.tikiwiki.org. Please let us know of the problem so that we can do something about it. Thanks.
- Ticket ID
- 6099
- Created
- Thursday 01 September, 2016 12:49:55 UTC
by Jean-Marc Libs - LastModif
- Thursday 01 September, 2016 14:27:53 UTC