Loading...
 
Skip to main content

LIST plugin failure in blog posts

  • Tracker item actions
Trackers
Items
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
(0)
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 clipboard
System 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+
Demonstrate Bug (older Tiki versions)
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


Show PHP error messages