2.8 Update – issues with shortcode output in Avada theme

Resolved

(@bemdesign)

Hi there! The latest Pods update seems to not work well with the Avada Theme (from ThemeFusion). My output shortcode looks like:
<div class="resource-list-display">[pods name="resource" template="Resource List" pagination="true" orderby="date DESC" limit="9"]</div>

Unfortunately what gets outputed is a database error message:

string(522) "Database Error; SQL: SELECT
                
                DISTINCT
                't'.*, 'd'.*
                FROM 'wp_posts' AS 't'
                LEFT JOIN 'wp_pods_resource' AS 'd' ON 'd'.'id' = 't'.'ID'
                WHERE ( ( 't'.'post_status' IN ( 'publish' ) ) AND ( 't'.'post_type' = 'resource' ) )
                
                
                ORDER BY 'd'.'date' DESC, 't'.'menu_order', 't'.'post_title', 't'.'post_date'
                LIMIT 0, 9; Response: Unknown column 'd.date' in 'order clause'"

Any ideas on whats happening here and how to fix? Thanks!

This topic was modified 4 years, 7 months ago by bemdesign. Reason: fixing extra code tags

Viewing 9 replies - 1 through 9 (of 9 total)

Thread Starter bemdesign
(@bemdesign)

4 years, 7 months ago

I have reverted back to the previous version of Pods to ensure functionality on the live site and will wait to see if future updates fix the issue.

Plugin Author Scott Kingsley Clark
(@sc0ttkclark)

4 years, 7 months ago

This may be one of the things we fixed in Pods 2.8.1 which is about to go out in a few minutes. If you have time at some point, I’d love to know if it fixes it for you, if you can manage to load it up on a staging site to test it.

Thread Starter bemdesign
(@bemdesign)

4 years, 7 months ago

Hi there Scott! I spun up a staging site to test the updated plugin on but unfortunately the latest update does not fix the issue – we’re still getting the same database error message as noted previously.

Thread Starter bemdesign
(@bemdesign)

4 years, 7 months ago

The orderby="date DESC" code that I’m using in my shortcode for some reason is triggering the error. When I remove the orderby field the display works correctly without error. Hope this is helpful info.

Thread Starter bemdesign
(@bemdesign)

4 years, 7 months ago

I figured it out! orderby="date" breaks but orderby="post_date" works. Apparently date is no longer the correct way to sort by the posts’ published date.

Plugin Author Scott Kingsley Clark
(@sc0ttkclark)

4 years, 7 months ago

If you know where you’ve seen it as date in our docs, let us know. It should have always been post_date or the more accurate t.post_date.

I’ll still get to working on a fix for this specific issue in 2.8.2 so it can help others who may not be able to make the change as easily.

Thread Starter bemdesign
(@bemdesign)

4 years, 7 months ago

Well shucks! Now I can’t find where I saw date being used in any of your documentation! What’s interesting is that the 2.7.31 version seemed to handle it fine but the new 3.8 version errors out. Maybe you had a way to catch that and translate it to post_date? Anyway, everything is working great now. Thank you for your support and such an awesome plugin!

Plugin Author Scott Kingsley Clark
(@sc0ttkclark)

4 years, 7 months ago

I’ll continue looking into the date alias issue and will get it resolved in Pods 2.8.2

Plugin Author Scott Kingsley Clark
(@sc0ttkclark)

4 years, 7 months ago

We solved this with Pods 2.8.2, please give it a go when you are able to. Pods 2.8.3 just went out so it includes even more fixes.

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘2.8 Update – issues with shortcode output in Avada theme’ is closed to new replies.