topoffice
Forum Replies Created
-
Posts
-
No problem. 🙂
So can you take care of the necessary changes on my site?
This reply has been marked as private.This reply has been marked as private.This reply has been marked as private.This reply has been marked as private.Whatever he did NOW … it did the trick! https://www.autobodyshop.org/sitemapindex.xml got created and loads (so do the sub maps). Full 200+k listings. Thank you very very much! 🙂
The BWP Sitemap plug-in offers lots of customization options. You may want to have a quick look at the setting options: Serious stuff aimed at handling huge DB’s. I’m curious to read what your developer comes back with. 🙂
Hi;
The BWP Sitemap plugin I installed shows “Place” as an option all over. Isn’t “Place” coming from GD?
Cheers,
Martin
Update
I just searched for a plugin that may be capable. I found, installed and set up:Better WordPress Google XML Sitemaps (1.4.1)
I DE-activated the old one.
The new offers even query limitations during the creation process – addressing exactly the issue you pointed out. ONly negative: The “create sitemap now” leads to the home page. With 200K+ install and just recently updated I doubt it’s a plugin fault. Maybe those new settings in GD you set up?
Cheers,
Martin
Hey Paolo;
Thanks for the efforts so far. 🙂
https://www.autobodyshop.org/sitemap_index.xml still gives me a 500 server error. I have not touched/changed a thing!
Location cities/tags/categories are highly important for me (an SEO thing with Google). I can’t drop them.
Question: What do websites with a REAL database do? How do they create sitemaps? Google officially accepts individual site maps with up to 50000 entries/pages each. How is is possible that my setup fails with a “lame” 200K listings.Within Google Webmaster I already notice the negative impact of the sitemap issue. It currently considers ~60K as submitted (down from 120K last week).
I appreciate your help. 🙂
Martin
Hey Guys;
Any news? I already deactivated the sitemap function in Yoast and tried with google-sitemap-generator.4.0.8 . The result is the same. I think this plugin even tries to max out the 50000 listings per map that Google takes. So it’s basically worse than the server time outs I get from Yoast when breaking up the listings in pieces of 500.
I would really appreciate if someone would address this shortly.
Thanks,
Martin
This reply has been marked as private.Hey Paolo;
Thanks for the note which I shared right away with my server admin guy. His reply:
No. Its not a nginx issue
I was trying get directly from apache
Its timed out
And stopped working with mysqlI provided 4 admin details. Which ones don’t work … do you need? 🙂
Cheers,
Martin
Hey Paolo;
I had my server guy look into this and he reported back with:
2016/01/22 08:39:30 [error] 30132#0: *359 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 85.132.54.30, server: autobodyshop.org, request: “GET /sitemap_index.xml HTTP/1.1”, upstream: “https://69.30.199.138:8443/sitemap_index.xml”, host: “www.autobodyshop.org”
[Fri Jan 22 08:40:01 2016] [error] [client 85.132.54.30] WordPress database error Query execution was interrupted for query SELECT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN wp_term_relationships as tr ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN wp_posts as p ON p.ID = tr.object_id INNER JOIN wp_geodir_gd_place_detail as pd ON pd.post_id = p.ID WHERE tt.taxonomy IN (‘gd_placecategory’) AND p.post_status = ‘publish’ AND pd.post_locations LIKE ‘%,[virginia],[united-states]’ GROUP BY t.term_id ORDER BY COUNT(t.term_id) DESC limit 5 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, geodir_sitemap_init, geodir_sitemap_load_sitemap_dataLooks like a DB loop caused by the GD code!!!
Please share this with Stiofan!
Cheers,
Martin
This reply has been marked as private.
