phpBB • Free and Open Source Forum Software

paulyii · by **paulyii** » Thu Aug 01, 2019 10:44 am

Sorry for my ignorance.
I had enabled the extension.
How do i know if it works ?

or i should do more than just enable it.
Generate site plan using it ? But how ?
I am really in a lost.

Can some brave Knight save my day ?
Definitely will be most grateful for any help rendered.

Anthony64 · by **Anthony64** » Tue Nov 26, 2019 1:28 am

same problem here

KYPREO · by **KYPREO** » Mon Dec 02, 2019 3:23 am

Anthony64 wrote:same problem here

Firstly, as per the FAQ, you need to either have URL rewriting enabled in the ACP, or configure your server to rewrite .\app.php\sitemap.xml to .\sitemap.xml. Read here for more: https://www.phpbb.com/customise/db/exte ... p/faq/2141

If you do not set this correctly, the extension will not work.

Assuming rewrites are working properly, then once the extension is enabled, go the ACP > Extensions tab > SEO Sitemap.

Configure the settings you want for the sitemap, click submit to save them.

Then click on the URL in that page or manually go to http://yourboard.com/sitemap.xml

When you go to the URL, the sitemap will generate dynamically (unless it is already cached). Depending on the size of your board, it may take a while, so do not close your browser. Once finished, it will load up the sitemap - or if you have more than 50,000 URLS, an index to the sub-sitemaps.

After you upload the sitemap URL to Google, or Bing, or whoever, every time they access the sitemap URL it will re-generate a new sitemap with newly added content - unless the sitemap has been cached.

I would suggest caching the sitemap to save on expending resources consumed if it generates every time it is accessed. That said, I submitted mine a few weeks ago and Google only reads it once every few days. Generally speaking, Google will not crawl the page more often than once every few days either. If there is newer content, Google has less troubles finding it than older pages. I therefore recommend setting the cache time to 72 hours.

If the above doesn't work, it might be that your board is too large. Mine has 2 million posts and in order to build the sitemap, I had to manually edit the extension to give PHP more memory. It seems that XML files are very resource-intensive to create.

Other than that, this is a great extension, and I have it working perfectly now. I can see Google going back to check the sitemap and new URLs are added to it every 3 days.

koraldon · by **koraldon** » Fri Jan 10, 2020 8:06 pm

KYPREO wrote:
If the above doesn't work, it might be that your board is too large. Mine has 2 million posts and in order to build the sitemap, I had to manually edit the extension to give PHP more memory. It seems that XML files are very resource-intensive to create.

Other than that, this is a great extension, and I have it working perfectly now. I can see Google going back to check the sitemap and new URLs are added to it every 3 days.

How did you increase it?
I get timeouts all the time...

KYPREO · by **KYPREO** » Sat Jan 11, 2020 5:02 am

koraldon wrote:How did you increase it?
I get timeouts all the time...

There is no execution time out for this extension. It overrides whatever your PHP default limit is. The cause of timeouts is lack of available memory.

Default memory allocated to Sitemap creation is 128M.

OPTION 1: If you have available memory, you can increase this.

Say you wanted to increase the limit to 256M, then edit /ext/shredder/sitemap/acp/sitemap_module.php at lines 80-102 as follows

Code: Select all

			if (!empty($mem_limit))
			{
				$unit = strtolower(substr($mem_limit, -1, 1));
				$mem_limit = (int) $mem_limit;

				if ($unit == 'k')
				{
					$mem_limit = floor($mem_limit / 1024);
				}
				else if ($unit == 'g')
				{
					$mem_limit *= 1024;
				}
				else if (is_numeric($unit))
				{
					$mem_limit = floor((int) ($mem_limit . $unit) / 1048576);
				}

				$mem_limit = max(256, $mem_limit) . 'M';
			}
			else
			{
				$mem_limit = '256M';
			}

The actual changes are at lines 98 and 102.

OPTION 2: There is a way to reduce memory requirements by unbuffering the SQL query used to generate the sitemap. As written, the extension loads each batch in memory before returning the results array. Instead you can have the sitemap processes each query result as it is generated. This will save memory but possibly increase CPU usage.

To do so if using => PHP 7.0 (MYSQLI) and MySQL, change /ext/shredder/sitemap/core.php at lines 224 and 272 from this:

Code: Select all

		$result = $this->db->sql_query($sql);

To this:

Code: Select all

		$result = mysqli_query($this->db->get_db_connect_id(), $sql, MYSQLI_USE_RESULT);

Tested and working on PHP 7.1.33. Should work on higher versions using mySQLi extension.

phpBB3 SEO Sitemap

After enabled the SEO SiteMap Extension. - phpBB3 SEO Sitemap

advertisements