[ABD] phpBB3 SEO Sitemap

Any abandoned Extensions will be moved to this forum.

WARNING: Extensions in this forum are not currently being supported or maintained by the original Extension author. Proceed at your own risk.
Forum rules
IMPORTANT: Extension Development Forum rules

WARNING: Extensions in this forum are not currently being supported nor updated by the original Extension author. Proceed at your own risk.
Locked
Shredder
Registered User
Posts: 116
Joined: Tue Aug 04, 2009 11:56 pm
Contact:

[ABD] phpBB3 SEO Sitemap

Post by Shredder » Wed Oct 29, 2014 11:59 pm

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
Last edited by Shredder on Fri Feb 27, 2015 3:44 pm, edited 3 times in total.

leschek
Registered User
Posts: 789
Joined: Tue Jul 18, 2006 12:49 pm
Contact:

Re: [BETA] phpBB3 SEO Sitemap

Post by leschek » Thu Oct 30, 2014 3:00 pm

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
Registered User
Posts: 116
Joined: Tue Aug 04, 2009 11:56 pm
Contact:

Re: [BETA] phpBB3 SEO Sitemap

Post by Shredder » Thu Oct 30, 2014 5:45 pm

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

MaFeSa
Registered User
Posts: 174
Joined: Wed Feb 11, 2009 7:48 am

Re: [BETA] phpBB3 SEO Sitemap

Post by MaFeSa » Thu Oct 30, 2014 5:51 pm

Thanks!
This extension is more important :D

leschek
Registered User
Posts: 789
Joined: Tue Jul 18, 2006 12:49 pm
Contact:

Re: [BETA] phpBB3 SEO Sitemap

Post by leschek » Thu Oct 30, 2014 8:04 pm

Shredder wrote:This data provides precise "lastmod" data for every URL in the sitemap.
Thanks.

szulik
Registered User
Posts: 10
Joined: Sat Jan 11, 2014 12:15 pm

Re: [BETA] phpBB3 SEO Sitemap

Post by szulik » Fri Oct 31, 2014 11:08 am

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
Registered User
Posts: 116
Joined: Tue Aug 04, 2009 11:56 pm
Contact:

Re: [BETA] phpBB3 SEO Sitemap

Post by Shredder » Fri Oct 31, 2014 2:48 pm

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
Registered User
Posts: 10
Joined: Sat Jan 11, 2014 12:15 pm

Re: [BETA] phpBB3 SEO Sitemap

Post by szulik » Fri Oct 31, 2014 3:40 pm

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
Registered User
Posts: 116
Joined: Tue Aug 04, 2009 11:56 pm
Contact:

Re: [BETA] phpBB3 SEO Sitemap

Post by Shredder » Fri Oct 31, 2014 4:40 pm

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

Image

BrainStone
Registered User
Posts: 6
Joined: Sun Nov 02, 2014 5:08 pm

Re: [BETA] phpBB3 SEO Sitemap

Post by BrainStone » Sun Nov 02, 2014 5:11 pm

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
Registered User
Posts: 10
Joined: Sat Jan 11, 2014 12:15 pm

Re: [BETA] phpBB3 SEO Sitemap

Post by szulik » Sun Nov 02, 2014 5:19 pm

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!

Shredder
Registered User
Posts: 116
Joined: Tue Aug 04, 2009 11:56 pm
Contact:

Re: [BETA] phpBB3 SEO Sitemap

Post by Shredder » Sun Nov 02, 2014 5:32 pm

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?

BrainStone
Registered User
Posts: 6
Joined: Sun Nov 02, 2014 5:08 pm

Re: [BETA] phpBB3 SEO Sitemap

Post by BrainStone » Sun Nov 02, 2014 5:33 pm

It simply is not generated. No errors, nothing.

User avatar
HiFiKabin
Community Team Member
Community Team Member
Posts: 4016
Joined: Wed May 14, 2014 9:10 am
Location: Swearing at the PC, UK
Name: James
Contact:

Re: [BETA] phpBB3 SEO Sitemap

Post by HiFiKabin » Sun Nov 02, 2014 5:39 pm

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 :?:

User avatar
bonelifer
Community Team Member
Community Team Member
Posts: 3476
Joined: Wed Oct 27, 2004 11:35 pm
Name: William
Contact:

Re: [BETA] phpBB3 SEO Sitemap

Post by bonelifer » Sun Nov 02, 2014 5:50 pm

Make the "Excluded forums:" box at least twice as tall.
Knowledge Base | phpBB Board Rules | Search Customisation Database
Image
Please don't contact me via PM or email for phpBB support .

Locked

Return to “Abandoned Extensions”