[ABD] phpBB3 SEO Sitemap

[Shredder]

Extension Name: phpBB3 SEO Sitemap
Author: Shredder

Extension Description: Sitemap for search engines. Supports both default phpBB and installed Ultimate SEO URL Ext. Sitemap Extension automatically detects whether Ultimate SEO installed and enabled or not, and provides support when it's found.

This extension is a port of my phpBB3 SEO Sitemap MOD from phpBB 3.0.x.

Extension Version: 1.0.3

Requirements: phpBB 3.1.0 or later

Extension Download: http://www.phpbb-work.ru/resources/file/189

Installation:

• Download and unzip it
• Extension files from "shredder" folder should be extracted to phpBB's /ext/shredder/ folder. Then the extension should be enabled in "ACP --> Customise --> Extensions Management" Tab

Important Notes:

• Sitemap URL will be at http://your_forum/sitemap.xml - open it in your browser, not FTP
• On the servers with "millions of posts" or low performance it will probably fail due to "server overload". In the future I will try to fix it if possible
• This extension may require a special server configuration. If your sitemap generated as it should be, the following suggestions are not for you. Otherwise follow these instructions:
  
  1) If you have Apache server, ask your hoster to enable mod_rewrite on the server. If it's enabled, ensure that .htaccess file in forum root directory is correct. See correct .htaccess in phpBB 3.1 package: https://www.phpbb.com/downloads/
  Important mod_rewrite part in .htaccess is:

  Code: Select all

  <IfModule mod_rewrite.c>
  	RewriteEngine On
  	RewriteCond %{REQUEST_FILENAME} !-f
  	RewriteCond %{REQUEST_FILENAME} !-d
  	RewriteRule ^(.*)$ app.php [QSA,L]
  </IfModule>

  Without the code above sitemap will not work. This code is present in the standard phpBB 3.1 .htaccess, so you shouldn't add it if sitemap works fine or the code is already there.
  
  2) If you have a nginx server, you should add following code to server config:
  viewtopic.php?f=456&t=2269621&start=15#p13784226
  
  3) For Windows IIS use .htaccess to Web.Config converter:
  http://cbsa.com.br/tools/online-convert ... onfig.aspx

[leschek]

Nice extension. I guess I will use it as replacement for sitemap FX I use now in phpBB3.
English isn't my first language and I would like to ask what "post modification data" mean:

Code: Select all

You should synchronize post modification data before using this sitemap

[Shredder]

This data provides precise "lastmod" data for every URL in the sitemap.

[MaFeSa]

Thanks!
This extension is more important

[leschek]

This data provides precise "lastmod" data for every URL in the sitemap.

Thanks.

[szulik]

I get an error when trying to open settings in ACP:

Code: Select all

SQL ERROR [ mysqli ]

Unknown column 'post_modified' in 'where clause' [1054]

SQL

SELECT 1 FROM bb_posts WHERE post_modified = 0 LIMIT 1

And such error when opening sitemap.xml:

Code: Select all

SQL ERROR [ mysqli ]

Unknown column 'p.post_modified' in 'field list' [1054]

SQL

SELECT t.topic_id, t.topic_type, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.post_modified FROM bb_topics t, bb_posts p WHERE t.topic_visibility = 1 AND p.post_visibility = 1 AND t.topic_status <> 2 AND t.forum_id IN (0, '4', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '19', '20', '21', '22', '23', '24') AND t.topic_id = p.topic_id ORDER BY t.topic_id, p.post_time

[Shredder]

szulik
Try to:

• disable extension in "ACP" --> "Customise" --> "Extension management"
• press "Delete data" in front of extension name
• then re-enable extension and configure it.

[szulik]

I've done 2 steps, When trying to re-enable I get:

Code: Select all

Something went wrong during the request and an exception was thrown. The changes made before the error occurred were reversed to the best of our abilities, but you should check the board for errors.

A required module does not exist: ACP_CAT_DOT_MODS

Moreover, now even if I delete all files and intsall extension from the begining I get same error during enabling.

[Shredder]

Do you have "Extensions" tab after "System" tab?

[BrainStone]

Somehow no sitemap will be generated!
My forum is located in the root directory of my webserver.

If you need additional information, please tell me.

board version: 3.1.0

[szulik]

Do you have "Extensions" tab after "System" tab?

You were right! It was an issue. However as I was using SEO Sitremap mod on 3.0.12 after upgrade I had to follow your instruction with disabling, deleting data and re-enabling.

Now it works. Thanks!

[Shredder]

Somehow no sitemap will be generated!
My forum is located in the root directory of my webserver.

If you need additional information, please tell me.

board version: 3.1.0

What exactly happens when no sitemap generated?

[BrainStone]

It simply is not generated. No errors, nothing.

[HiFiKabin]

Somehow no sitemap will be generated!
My forum is located in the root directory of my webserver.

If you need additional information, please tell me.

board version: 3.1.0

It simply is not generated. No errors, nothing.

Same here. Installed perfectly, sync'd posts, but no sitemap

[bonelifer]

Make the "Excluded forums:" box at least twice as tall.