[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 »

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: 838
Joined: Tue Jul 18, 2006 12:49 pm
Contact:

Re: [BETA] phpBB3 SEO Sitemap

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

Re: [BETA] phpBB3 SEO Sitemap

Post by Shredder »

This data provides precise "lastmod" data for every URL in the sitemap.
MaFeSa
Registered User
Posts: 175
Joined: Wed Feb 11, 2009 7:48 am

Re: [BETA] phpBB3 SEO Sitemap

Post by MaFeSa »

Thanks!
This extension is more important :D
leschek
Registered User
Posts: 838
Joined: Tue Jul 18, 2006 12:49 pm
Contact:

Re: [BETA] phpBB3 SEO Sitemap

Post by leschek »

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 »

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 »

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 »

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 »

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 »

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 »

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 »

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 »

It simply is not generated. No errors, nothing.
User avatar
HiFiKabin
Community Team Member
Community Team Member
Posts: 6671
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 »

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: 3542
Joined: Wed Oct 27, 2004 11:35 pm
Name: William
Contact:

Re: [BETA] phpBB3 SEO Sitemap

Post by bonelifer »

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

Return to “Abandoned Extensions”