No Results Found

Resolved

(@corybolles)

Our listings have stopped showing on category pages suddenly; The listings themselves show up and have been verified to be in the right categories, but this error shows up regardless.

There is a relevant debug.log error:

[11-Sep-2023 15:22:56 UTC] WordPress database error Unknown column 'wpbdp_is_sticky' in 'order clause' for query 
					SELECT   wp_qjwjiw_posts.ID
					FROM wp_qjwjiw_posts  LEFT JOIN wp_qjwjiw_term_relationships ON (wp_qjwjiw_posts.ID = wp_qjwjiw_term_relationships.object_id)
					WHERE 1=1  AND ( 
  wp_qjwjiw_term_relationships.term_taxonomy_id IN (115)
) AND ((wp_qjwjiw_posts.post_type = 'wpbdp_listing' AND (wp_qjwjiw_posts.post_status = 'publish' OR wp_qjwjiw_posts.post_status = 'acf-disabled' OR wp_qjwjiw_posts.post_status = 'wc-unfulfilled' 
OR wp_qjwjiw_posts.post_status = 'private')))
					GROUP BY wp_qjwjiw_posts.ID
					ORDER BY wpbdp_is_sticky DESC, wp_qjwjiw_posts.post_title ASC
					
				 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

The page I need help with: [log in to see the link]

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

Plugin Support bobbied
(@bobbied)

2 years, 7 months ago

Hi @corybolles

Thanks for sharing that log error — let me get a developer to take a look here and I’ll let you know what they say. Have you tried a conflict test in the meantime?

Thread Starter corybolles
(@corybolles)

2 years, 7 months ago

Hi @bobbied

No problem; We have done a conflict test and the error seems to persist even when it’s the only thing active on the site.

I’m inclined to think that it may be a server issue as we had some changes recently; We’re running PHP 8.1 and MariaDB 10.6 for reference.
harryfp
(@harryfp)

2 years, 7 months ago
Just to add here — I’ve just updated this plugin for a client and we’re now seeing the exact same issue:
```
[Fri Sep 15 16:09:49.482821 2023] [proxy_fcgi:error] [pid 1065:tid 140600024221440] [client 86.13.239.4:0] AH01071: Got error 'PHP message: WordPress database error Unknown column 'wpbdp_is_sticky' in 'order clause' for query \n\t\t\t\t\tSELECT   wp_posts.ID\n\t\t\t\t\tFROM wp_posts \n\t\t\t\t\tWHERE 1=1  AND wp_posts.post_name = 'myspace-property-agent-in-london' AND wp_posts.post_type = 'wpbdp_listing' AND wp_posts.post_status NOT IN ('hidden_property','archived_property') \n\t\t\t\t\t\n\t\t\t\t\tORDER BY wpbdp_is_sticky DESC, wp_posts.post_title ASC\n\t\t\t\t\t\n\t\t\t\t made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts', referer: [SITE URL]/wp-admin/post.php?post=21631354&action=edit&classic-editor
```
All of our listings 404 when trying to reach their URLs, and don’t show up in the directory at all. Any ideas how to fix this? It’s pretty urgent.

How can I roll this back?
- This reply was modified 2 years, 7 months ago by harryfp.
Plugin Support bobbied
(@bobbied)

2 years, 7 months ago

Hey @corybolles and @harryfp

Thank you for being so patient on this. We’ve identified a fix for this. Can you please contact support directly for the steps to address this? We will get a release out as quickly as possible to address the issue, but it is possible to address with some minor adjustments to the plugin.

Please contact us with a link to this forum thread http://businessdirectoryplugin.com/contact/

Thread Starter corybolles
(@corybolles)

2 years, 7 months ago

@bobbied Great, I have sent a message to support and linked them to this thread. Please let us know when you have released a fix.

Plugin Support bobbied
(@bobbied)

2 years, 7 months ago

Hey @corybolles and @harryfp This release has now gone out and should address the issue. Thanks for the reporting!!

harryfp
(@harryfp)

2 years, 7 months ago

Looks fixed for me, thanks for the quick work! 👍

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

The topic ‘No Results Found’ is closed to new replies.