Page 1 of 7

[ABD] phpBB3 SEO Sitemap

Posted: Wed Oct 29, 2014 11:59 pm
by 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

Re: [BETA] phpBB3 SEO Sitemap

Posted: Thu Oct 30, 2014 3:00 pm
by 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

Re: [BETA] phpBB3 SEO Sitemap

Posted: Thu Oct 30, 2014 5:45 pm
by Shredder
This data provides precise "lastmod" data for every URL in the sitemap.

Re: [BETA] phpBB3 SEO Sitemap

Posted: Thu Oct 30, 2014 5:51 pm
by MaFeSa
Thanks!
This extension is more important :D

Re: [BETA] phpBB3 SEO Sitemap

Posted: Thu Oct 30, 2014 8:04 pm
by leschek
Shredder wrote:This data provides precise "lastmod" data for every URL in the sitemap.
Thanks.

Re: [BETA] phpBB3 SEO Sitemap

Posted: Fri Oct 31, 2014 11:08 am
by 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

Re: [BETA] phpBB3 SEO Sitemap

Posted: Fri Oct 31, 2014 2:48 pm
by 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.

Re: [BETA] phpBB3 SEO Sitemap

Posted: Fri Oct 31, 2014 3:40 pm
by 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.

Re: [BETA] phpBB3 SEO Sitemap

Posted: Fri Oct 31, 2014 4:40 pm
by Shredder
Do you have "Extensions" tab after "System" tab?

Image

Re: [BETA] phpBB3 SEO Sitemap

Posted: Sun Nov 02, 2014 5:11 pm
by 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

Re: [BETA] phpBB3 SEO Sitemap

Posted: Sun Nov 02, 2014 5:19 pm
by szulik
Shredder wrote:Do you have "Extensions" tab after "System" tab?

Image

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!

Re: [BETA] phpBB3 SEO Sitemap

Posted: Sun Nov 02, 2014 5:32 pm
by Shredder
BrainStone wrote: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?

Re: [BETA] phpBB3 SEO Sitemap

Posted: Sun Nov 02, 2014 5:33 pm
by BrainStone
It simply is not generated. No errors, nothing.

Re: [BETA] phpBB3 SEO Sitemap

Posted: Sun Nov 02, 2014 5:39 pm
by HiFiKabin
BrainStone wrote: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
BrainStone wrote:It simply is not generated. No errors, nothing.
Same here. Installed perfectly, sync'd posts, but no sitemap :?:

Re: [BETA] phpBB3 SEO Sitemap

Posted: Sun Nov 02, 2014 5:50 pm
by bonelifer
Make the "Excluded forums:" box at least twice as tall.