[Resolved] Since the latest Layouts update WP Views Filter not working

[Author]

Posts

[lindsayH]

Since the update the wp-views in a widget does not display and the formatting has gone awry. Please see screen dumps. 'Refine Your Search' is missing and some of the Contact Details formatting is lost (I'm sure I can look at this - it's the missing WP Views Filter which is of most concern).

[Luo Yang]

Dear Lindsay,

It is abnormal, please try this:
1) deactivate other plugins and switch to oringinal Toolset starter theme, and test again
2) Enable PHP debug mode, copy and paste the debug logs here
PHP Debugging
In case you think that Types or Views are doing something wrong (what we call a bug), you should enable PHP error logging. Again, edit your wp-config.php file and add the following:

ini_set('log_errors',TRUE);
ini_set('error_reporting', E_ALL);
ini_set('error_log', dirname(__FILE__) . '/error_log.txt');
This will produce a file called ‘error_log.txt’ in your WordPress root directory. Make sure that the web server can create and write this file. If it cannot, use an FTP program to create the file and make it writable to Apache (normally, user www-data).
https://toolset.com/documentation/user-guides/debugging-types-and-views/

[lindsayH]

This was working on my site just fine, but the latest update has changed something. I have a second site which I haven't applied the updates to and this is fine.

I disabled all plugins (except any that started with Toolset) and changed theme to Toolset Starter and still same issue - see attached image.

JFYI I am using Toolset Genesis Integration.

Here is the results from the error_log

text/plain error_log.txt ( ASCII text, with very long lines )

[24-Nov-2016 09:09:22 UTC] WordPress database error Unknown column 'wpvw_postmeta.meta_value' in 'order clause' for query SELECT wpvw_posts.ID FROM wpvw_posts WHERE 1=1 AND wpvw_posts.ID NOT IN (6) AND wpvw_posts.post_type = 'wedding-supplier' AND ((wpvw_posts.post_status = 'publish')) ORDER BY wpvw_postmeta.meta_value DESC, menu_order DESC, post_modified DESC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/genesis/page.php'), genesis, get_footer, locate_template, load_template, require_once('/themes/genesis/footer.php'), do_action('genesis_after'), call_user_func_array, ez_fat_footer, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WPV_Widget_filter->widget, WP_Views->short_tag_wpv_view_form, do_action('wpv_action_extend_query_for_parametric_and_counters'), call_user_func_array, WPV_View_Post_Query->wpv_filter_extend_query_for_parametric_and_counters, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[24-Nov-2016 09:09:22 UTC] WordPress database error Unknown column 'wpvw_postmeta.meta_value' in 'order clause' for query SELECT SQL_CALC_FOUND_ROWS wpvw_posts.ID FROM wpvw_posts WHERE 1=1 AND wpvw_posts.post_type = 'post' AND (wpvw_posts.post_status = 'publish') ORDER BY wpvw_postmeta.meta_value DESC, menu_order DESC, post_modified DESC LIMIT 0, 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/genesis/page.php'), genesis, get_footer, locate_template, load_template, require_once('/themes/genesis/footer.php'), do_action('genesis_after'), call_user_func_array, ez_fat_footer, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, Genesis_Featured_Post->widget, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[24-Nov-2016 09:14:20 UTC] WordPress database error Unknown column 'wpvw_postmeta.meta_value' in 'order clause' for query SELECT wpvw_posts.ID FROM wpvw_posts WHERE 1=1 AND wpvw_posts.ID NOT IN (6) AND wpvw_posts.post_type = 'wedding-supplier' AND ((wpvw_posts.post_status = 'publish')) ORDER BY wpvw_postmeta.meta_value DESC, menu_order DESC, post_modified DESC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/genesis/page.php'), genesis, get_footer, locate_template, load_template, require_once('/themes/genesis/footer.php'), do_action('genesis_after'), call_user_func_array, ez_fat_footer, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WPV_Widget_filter->widget, WP_Views->short_tag_wpv_view_form, do_action('wpv_action_extend_query_for_parametric_and_counters'), call_user_func_array, WPV_View_Post_Query->wpv_filter_extend_query_for_parametric_and_counters, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[24-Nov-2016 09:14:20 UTC] WordPress database error Unknown column 'wpvw_postmeta.meta_value' in 'order clause' for query SELECT SQL_CALC_FOUND_ROWS wpvw_posts.ID FROM wpvw_posts WHERE 1=1 AND wpvw_posts.post_type = 'post' AND (wpvw_posts.post_status = 'publish') ORDER BY wpvw_postmeta.meta_value DESC, menu_order DESC, post_modified DESC LIMIT 0, 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/genesis/page.php'), genesis, get_footer, locate_template, load_template, require_once('/themes/genesis/footer.php'), do_action('genesis_after'), call_user_func_array, ez_fat_footer, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, Genesis_Featured_Post->widget, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[24-Nov-2016 09:40:04 UTC] WordPress database error Unknown column 'wpvw_postmeta.meta_value' in 'order clause' for query SELECT wpvw_posts.ID FROM wpvw_posts WHERE 1=1 AND wpvw_posts.ID NOT IN (6) AND wpvw_posts.post_type = 'wedding-supplier' AND ((wpvw_posts.post_status = 'publish' OR wpvw_posts.post_status = 'private')) ORDER BY wpvw_postmeta.meta_value DESC, menu_order DESC, post_modified DESC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/genesis/page.php'), genesis, get_footer, locate_template, load_template, require_once('/themes/genesis/footer.php'), do_action('genesis_after'), call_user_func_array, ez_fat_footer, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WPV_Widget_filter->widget, WP_Views->short_tag_wpv_view_form, do_action('wpv_action_extend_query_for_parametric_and_counters'), call_user_func_array, WPV_View_Post_Query->wpv_filter_extend_query_for_parametric_and_counters, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[24-Nov-2016 09:40:04 UTC] WordPress database error Unknown column 'wpvw_postmeta.meta_value' in 'order clause' for query SELECT SQL_CALC_FOUND_ROWS wpvw_posts.ID FROM wpvw_posts WHERE 1=1 AND wpvw_posts.post_type = 'post' AND (wpvw_posts.post_status = 'publish' OR wpvw_posts.post_status = 'private') ORDER BY wpvw_postmeta.meta_value DESC, menu_order DESC, post_modified DESC LIMIT 0, 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/genesis/page.php'), genesis, get_footer, locate_template, load_template, require_once('/themes/genesis/footer.php'), do_action('genesis_after'), call_user_func_array, ez_fat_footer, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, Genesis_Featured_Post->widget, WP_Query->__construct, WP_Query->query, WP_Query->get_posts

Many thanks, Lins

[Luo Yang]

There are mysql errors in your debug logs, for example:
WordPress database error Unknown column 'wpvw_postmeta.meta_value'

I suggest you check your database first, check if there is column "meta_value" in table "wpvw_postmeta"

More help:
https://codex.wordpress.org/Database_Description#Table:_wp_postmeta

[lindsayH]

I've looked at both the site that's working (before the latest layouts update) and the site that isn't - the tables look identical. See attached images.

Is there any way we can roll back the layouts or preferably can you have a look please? Many thanks for your help.

[lindsayH]

I'm a bit out of my depth here, but seems the query above is including data from the wpvw_posts table but is trying to ORDER BY data from the wpvw_postmeta table. I don't think you can do that.

As I've disabled all plugins and changed the theme to Toolset Starter and there is still an issue I think it's the Toolset (probably the Layout) plugin that needs looking at. Also this absolutely is still working on a site I have not yet upgraded.

Can you have a look please. Many thanks.

[Luo Yang]

Please follow our document and provide a copy of your website:
How To Provide Supporters With A Copy Of Your Site
https://toolset.com/faq/provide-supporters-copy-site/

I need to test and debug it in my localhost. thanks

[Luo Yang]

There are 21 plugins activated in your website, and you are using custom theme, I need your permission to deactivate them for further debug, you will need to backup the database first, thanks

[lindsayH]

Hi, yes I did say you can do what you like here. This is a staging site (not my live site). Many thanks for your help.

[Luo Yang]

Thanks for the details, I have done below modification in your website:
Edit the problem layout:
hidden link
1) Add a row with same widget cell (Views filter form)
2) Remove the original row with widget cell

Please test again, check if it is fixed or not. thanks

[lindsayH]

Actually, the issue is as soon as I add a tag class, the widget disappears. I did note that I'd lost the css formatting so this makes sense too.

Could you investigate again? Thank you very much for your help.

PS After much fiddling (i.e deleting a few cells in the sidebar, recreating, reordering) it now seems to be working BUT nevertheless when you add the css tag class initially the cell disappears on the front end.

[Luo Yang]

I can not duplicate same problem in your website, please correct me if there is anything missing:
1) Edit the laytout:
hidden link

2) Edit the widget cell "Refine Your Search". in option "Tag classes (optional)" add class name "widget-side", Save and refresh the page in front-end:
hidden link

I can see it works fine.

[lindsayH]

There is something odd going on. When I did on the main site - i.e.,
1) Add a row with same widget cell (Views filter form)
2) Remove the original row with widget cell
I then went back in to add the class name "widget-side", saved, on the front end that widget disappeared. As I mentioned in an earlier post, after a lot of fiddling I resolved, but it's not really 'stable'.

Now I look at what you've done in the staging site and the class name has NOT been saved (or is not visible) for the first WP Views Filter widget (see screen dump), though on the front end this widget IS using the CSS (again see screen dump - the first widget now has different styling, i.e. "widget-side"). Note: the other two widgets have simultaneously lost their styling too - I guess from the update.

I have not amended anything at all on the staging site, I just went in to look and report back to you.

[Luo Yang]

I just tested in your website, switch to Tooset starter theme, then the website is broken, I see below error:
This site can’t be reached
The webpage at hidden link might be temporarily down or it may have moved permanently to a new web address.
ERR_SPDY_PROTOCOL_ERROR

Since you did not provide the FTP access, I can not fix it, please fix it by this:
Use FTP tools. rename the Tooset starter theme to other name.

As I mentioned above, to debug this problem, please provide the FTP access of your test site.

[Luo Yang]

I just restored your test site by this:
1) Rename the your custom theme folder "toolset-starter" to "toolset-starter-bak"
2) Download the original "toolset-starter" theme and upload to your website.
Same problem occurs, I am downloading the PHP debug logs from your website, will feedback if there is anything found