rooify
Forum Replies Created
-
nevermind. To anyone using this plugin + elementor pro.
Remember to not add any display condition on the elementor template created for the single recipe post type.Forum: Plugins
In reply to: [MaxiCharts Query Builder Add-on] Oceanwp conflictGreat, it is working now, thank you !!!
Forum: Plugins
In reply to: [MaxiCharts Query Builder Add-on] Oceanwp conflicthttps://staging-salaryintel.kinsta.com/
When I enable the plugin, the main menu dissapears.Forum: Plugins
In reply to: [Schema - All In One Schema Rich Snippets] conflict with oceanwp themeHi thanks for the reply, i tested with multiple snippets and filling all the info, it changes the order in which the sidebar gets called.
Default html looks like this:
<main>
<content></content>
<sidebar></sidebar>
</main>and with the plugin enabled, and adding the rich card the html changes to this:
<main>
<content></content>
<the rich card />
</main>
<sidebar></sidebar>Hope that helps.
Hi, its s single install, and full admin account
Deactivating all the plugins but: Events Manager, Events Manager Pro
And changing theme to twenty seventeen
Doesn’t fix the issue, the query looks a little strange:SELECT SQL_CALC_FOUND_ROWS 5953_posts.ID
FROM 5953_posts
INNER JOIN 5953_postmeta
ON ( 5953_posts.ID = 5953_postmeta.post_id )
INNER JOIN 5953_postmeta AS mt1
ON ( 5953_posts.ID = mt1.post_id )
WHERE 1=1
AND 5953_posts.post_author IN (21)
AND ( 5953_postmeta.meta_key = ‘_start_ts’
AND ( ( mt1.meta_key = ‘_start_ts’
AND mt1.meta_value >= ‘1513382400’ ) ) )
AND 5953_posts.post_type = ‘event’
AND (5953_posts.post_status = ‘publish’
OR 5953_posts.post_status = ‘future’
OR 5953_posts.post_status = ‘draft’
OR 5953_posts.post_status = ‘pending’
OR 5953_posts.post_status = ‘private’)
GROUP BY 5953_posts.ID
ORDER BY 5953_postmeta.meta_value+0 ASC
LIMIT 0, 20- This reply was modified 8 years, 5 months ago by rooify.
quick and dirty, using BWP for posts, pages but wrote a script for the listings based on this:
https://github.com/o/sitemap-phpSubmitted two index sitemaps to GWT for now.
resolved
Thanks Khang, ill check it out.
Big task for any process to go through a table of that size, i guess ill have to try and split it up somehow.
Hi Khang,
No extensions are added (no images, not news). The current split is at 1000 but we have had it as low as 100/100 & 10 queries until we forced a memory error on sitemapindex.xml.
php memorry is now 266MB so we don’t get a mem error on the sitemapindex but the ‘part’ sitemaps still timeout.This is what i am getting in the plugin logs:
‘Mar 03, 2016 01:06:02 AM —post_job_listing_part22629.xml does not have any item. There are no public ABN. Enable/disable sitemaps via BWP Sitemaps >> XML Sitemaps. (debugging was on)
Mar 03, 2016 01:02:25 AM —post_job_listing_part22629.xml will be served using module file post.php. (debugging was on)
Mar 02, 2016 11:57:35 PM —post_job_listing_part22813.xml does not have any item. There are no public ABN. Enable/disable sitemaps via BWP Sitemaps >> XML Sitemaps. (debugging was on)
Mar 02, 2016 11:54:19 PM —post_job_listing_part22813.xml will be served using module file post.php. (debugging was on)
Mar 02, 2016 11:53:43 PM —post_job_listing_part12447.xml does not have any item. There are no public ABN. Enable/disable sitemaps via BWP Sitemaps >> XML Sitemaps. (debugging was on)’Would there be any queries you would advise that we investigate to see if we can break them down? I appreciate any direction/
Further to the above: is this a bwp query?
SELECT p.* FROM wp_posts p WHERE p.post_status = ‘publish’ AND p.post_password =’ ‘;db is around 40G with:
296,372,879 rows in wp_postmeta
11,822,908 in wp_posts
23,729,634 in wp_term_relationships