I am trying to:
I have created 2 view - when I run the preview returns results.
When I embed in Elementor ( either shortcode / views element ) it returns no rows
Link to a page where the issue can be seen:
hidden link
I expected to see:
Rows returned in Elementor
Instead, I got:
No rows
Well - triggering debug mode - I see that it runs the following ...
SELECT wpqt_posts.* FROM wpqt_posts WHERE 1=1 AND wpqt_posts.ID IN (0) AND wpqt_posts.post_type = 'agenda-details' AND ((wpqt_posts.post_status = 'publish' OR wpqt_posts.post_status = 'private')) ORDER BY wpqt_posts.ID DESC
Going into mysql - I see that the issue is
wpqt_posts.ID IN (0) ==> Which returns 0 rows ...
Sleuthing ...
This worked in Elementor Pro a few days back. Either an update or I changed something.
Weird that it returns rows in Preview but not in Elementor
As an FYI -
hidden link - returns the POST ID ( this page is not built with Elementor )
But the widget in Elementor returns 0 ..
Thanks for the report, it sounds like a replicable problem but I miss the steps to reach it.
Can I ask if this issue as well happens when you query Post Types instead of RFG's?
I think that will solve it.
If this is so, can you let me know and eventually add a copy of your site using these steps:
https://toolset.com/faq/provide-supporters-copy-site/
I can then quickly check the install and replicate a clean copy of the problem so to escalate it to the Developers.
If you have precise single steps to reach the issue, please add them (I do suspect that it is the RFG query breaking things here)
The first test I'd do is see if other post type queries also behave like that.
I think this should be the source of the issue, with your feedback and data we will be able to confirm this and solve it eventually or instruct on how to resolve in on site.
Hi Breda,
I can answer some of your questions ...
1) I created a new view showing just post title / post body - and added view using element. This works!
2) The RPGs seems to be the issue.
3) Where do I upload the duplicator files?
Adding a View querying RFG's works just fine locally if inserted thru the Elementor Widget for Views.
I will need to have the duplicate, if this happens with Toolset and Elementor only, or/and the precise steps to reach the issue.
I have enabled private reply modes so you can add the information required.
In the duplicate received the Post agenda-minute/park/ has One Repeatable Field item:
Only the View that queries "Agenda Minute Details" hence can return results.
You inserted that View twice in the same post.
I saw that they work if you add them (as currently done) to the Post Editor as:
[wpv-view name="berry-view-all"]
[wpv-view name="agendas-minutes-widget-view"]
I tried to edit that post and got a row of errors related to other plugins which I had to disable hence.
( ! ) Warning: fsockopen(): php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known in .../plugins/sg-cachepress/class-sg-cachepress-supercacher.php on line 104
( ! ) Warning: fsockopen(): unable to connect to ::1:80 (php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known) in .../plugins/sg-cachepress/class-sg-cachepress-supercacher.php on line 104
( ! ) Warning: fsockopen(): php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known in .../sg-cachepress/class-sg-cachepress-supercacher.php on line 104
( ! ) Warning: fsockopen(): unable to connect to ::1:80 (php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known) in.../sg-cachepress/class-sg-cachepress-supercacher.php on line 104
( ! ) Warning: Cannot modify header information - headers already sent by (output started at .../plugins/sg-cachepress/class-sg-cachepress-supercacher.php:104) in .../wp-admin/post.php on line 198
( ! ) Warning: Cannot modify header information - headers already sent by (output started at .../plugins/sg-cachepress/class-sg-cachepress-supercacher.php:104) in .../wp-includes/pluggable.php on line 1219
We integrate with Elementor, hence I activated support for "Agenda Minute" editing with Elementor.
I added the 2 Views in question in the Agenda Minute "Park" and that works fine.
Please try to follow these steps outlined above, to see if they resolve the issue.
Breda,
The point of showing both views was just for testing purposes - to show the RPGs was the issue. I have deleted this from the home page.
You mention deleting some plugins ( which? I deleted SG Optimizer ) - you also mention " I activated support for "Agenda Minute" editing with Elementor." - I did this via, Elementor, Settings, and check "Agenda Minutes, Custom Layouts" ...
This does not work for me - I still receive zero rows for "[wpv-view name="agendas-minutes-widget-view"]" in the tab ...
For Park / Berry - I just have one view displaying now - preview shows rows, home page does not.
Also, it would not surprise me that the plugin issue with sg optimizer is because that pertains to SiteGround ... Which you are not on I presume.
Is there any way we can expedite this ticket - I recognize that you are in Hong Kong - and this is impeding a timely resolution. This is not meant to be a slam on you - but logistics is hurting my development here ...
The errors I saw are from the Plugin sg-cachepress.
They may not appear on your site, maybe this is requiring some more setup that is not done when migrating the site
The Elementor was not set to edit the custom post type hence I added that.
Then, I edited the single Post of that post type with elementor and added the widgets for views.
I cannot see this done on the site, the park post for example is not edited with elementor at all and instead has the ShortCodes inserted, not elementors widgets.
Please edit that / those posts with elementor and add the widget for Views.
I can do that, however, it may destroy what you already saved in that post.
Hi Breda,
Please login in and see what can be done - I am adding the widget in Ultimate Addons tabs ...
I don't mind if things get awry - this is a sandbox.
Just to recap - I am using Ultimate Addons for Elementor - it's the tab - and I will need to use the shortcode.
Let's get this resolved asap ... Any chance that I can get a timely reply - from you or someone else?
I am NOT complaining about you I just want this resolved and receiving replies at midnight is just not working for me.
I have redone everything - deleted / view - created a new view. Deleted RPGs - re-created them.
As of now ...
Tab does not have the view shortcode. I created a section below the tabs, and inserted the view - "No Rows".
Please do further tests on my sandbox site ...
OK, I can assign this to someone closer to your timezone.
The thing is, I do not see this done with Elementor on the Site, as stated.
hidden link
This is not edited with Elementor.
The only other post in that type as well is not edited with Elementor.
I see no View in the entire website with a name as "no rows", what do you refer to? Can you link me to the posts, views and other screens you refer to?
I edited the post "Park" and inserted the View, it works.
I will now un-assign this ticket from myself, and assign it to Shane, I think he is closer to your TimeZone.
Please let us know if I did it wrong, I inserted the View in the "Park" post with Elementor, as the last item on the page.
I’ll check in the morning.
But let me be clear.
The post was not created in elementor - but rather in the native WordPress editor.
The section that has the view - that was added into the homepage which is an elementor section.
Are you saying that I need to create the CPT post in elementor?