[3.3][RC] Filter by country - version 1.0.19

A place for Extension Authors to post and receive feedback on Extensions still in development. No Extensions within this forum should be used within a live environment!
Ideas Centre
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: Extensions Development rules

IMPORTANT FOR NEEDED EVENTS!!!
If you need an event for your extension please read this for the steps to follow to request the event(s)
User avatar
KlausiMaus
Registered User
Posts: 193
Joined: Sat Nov 15, 2014 4:55 pm

Re: [3.3][RC] Filter by country - version 1.0.19

Post by KlausiMaus »

MarkDHamill wrote:
Sat Dec 19, 2020 3:03 pm
The extension can be downloaded here or from the GitHub 1.0.19 release branch. If downloaded from GitHub, make sure to place the files in /ext/phpbbservices/filterbycountry.
The two files are different!
Klaus (http://forum.kuhnert.ch/) :: Keep it simple, stupid :!:
User avatar
MarkDHamill
Registered User
Posts: 4366
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

Re: [3.3][RC] Filter by country - version 1.0.19

Post by MarkDHamill »

RemmyH wrote:
Sat Dec 19, 2020 3:52 pm
Is there a Dutch translation available somewhere?
I came across a link somewhere but that site doesn't exist anymore.
His website is down but you can contact him through his profile.
Need phpBB services or a phpBB consultant? I offer most phpBB services. Getting lost managing phpBB? Buy my book, Mastering phpBB Administration. eBook and paper versions available.
User avatar
MarkDHamill
Registered User
Posts: 4366
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

Re: [3.3][RC] Filter by country - version 1.0.19

Post by MarkDHamill »

KlausiMaus wrote:
Sat Dec 19, 2020 3:57 pm
MarkDHamill wrote:
Sat Dec 19, 2020 3:03 pm
The extension can be downloaded here or from the GitHub 1.0.19 release branch. If downloaded from GitHub, make sure to place the files in /ext/phpbbservices/filterbycountry.
The two files are different!
If you download from GitHub, you will have an unneeded .idea folder. I haven't figured out a way to get rid of it, sorry. But it can be deleted.
Need phpBB services or a phpBB consultant? I offer most phpBB services. Getting lost managing phpBB? Buy my book, Mastering phpBB Administration. eBook and paper versions available.
User avatar
bubbathegimp
Registered User
Posts: 175
Joined: Tue Sep 25, 2018 8:02 pm
Location: Off Plumb
Name: Bubba
Contact:

Re: [3.3][RC] Filter by country - version 1.0.19

Post by bubbathegimp »

Table './****_****/phpbb_fbc_stats' is marked as crashed and last (automatic?) repair failed [144]......
If at first you don't succeed, Sky diving is not for you....
Ymmv
User avatar
janus_zonstraal
Registered User
Posts: 5134
Joined: Sat Aug 30, 2014 1:30 pm

Re: [3.3][RC] Filter by country - version 1.0.19

Post by janus_zonstraal »

Try to repair it manually with phpmyadmin.
Sorry! My English is bat ;) !!!
User avatar
MarkDHamill
Registered User
Posts: 4366
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

Re: [3.3][RC] Filter by country - version 1.0.19

Post by MarkDHamill »

Better yet, once recovered, if the storage engine is MYISAM change it to INNODB.

Code: Select all

ALTER TABLE phpbb_fbc_stats ENGINE=INNODB;
It's not a bad idea to do this for all similar tables.
Need phpBB services or a phpBB consultant? I offer most phpBB services. Getting lost managing phpBB? Buy my book, Mastering phpBB Administration. eBook and paper versions available.
User avatar
RMcGirr83
Former Team Member
Posts: 21909
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: [3.3][RC] Filter by country - version 1.0.19

Post by RMcGirr83 »

MarkDHamill wrote:
Sat Dec 19, 2020 4:48 pm
If you download from GitHub, you will have an unneeded .idea folder. I haven't figured out a way to get rid of it, sorry. But it can be deleted.
In your repo create a .gitattributes file and put this in it. Then upload into where the README.md file is.

Code: Select all

tests/			export-ignore
.idea/			export-ignore
.github/		export-ignore
.gitignore		export-ignore
.gitattributes	export-ignore
phpunit.xml.*	export-ignore
build.xml		export-ignore
composer.lock	export-ignore
README.md		export-ignore
You can remove the things you don't have but it won't hurt anything leaving them in the file.
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beerImage
User avatar
MarkDHamill
Registered User
Posts: 4366
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

Re: [3.3][RC] Filter by country - version 1.0.19

Post by MarkDHamill »

Thanks Rich! I thought I had a .gitignore file but I never created one! I gather I don't need a .gitignore file too. I assume I need to publish a new version for the .idea folder to be removed from the GitHub master?
Need phpBB services or a phpBB consultant? I offer most phpBB services. Getting lost managing phpBB? Buy my book, Mastering phpBB Administration. eBook and paper versions available.
User avatar
RMcGirr83
Former Team Member
Posts: 21909
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: [3.3][RC] Filter by country - version 1.0.19

Post by RMcGirr83 »

No you don't need to publish a new version, just remove the folder directly in your local repo and push/commit and the folder will be removed on github.
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beerImage
User avatar
MarkDHamill
Registered User
Posts: 4366
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

Re: [3.3][RC] Filter by country - version 1.0.19

Post by MarkDHamill »

RMcGirr83 wrote:
Sat Dec 26, 2020 5:52 pm
No you don't need to publish a new version, just remove the folder directly in your local repo and push/commit and the folder will be removed on github.
I must be doing something wrong. I removed the .idea folder from the command line. I also tried this advice:

https://www.david-merrick.com/2017/08/0 ... -from-git/

I use GitHub Desktop for the Mac. I don't see a commit, but I do see Repository -> Push. It just doesn't result in the .idea folder being removed from GitHub.
Need phpBB services or a phpBB consultant? I offer most phpBB services. Getting lost managing phpBB? Buy my book, Mastering phpBB Administration. eBook and paper versions available.
lacike
Registered User
Posts: 12
Joined: Fri Apr 05, 2013 6:26 pm

Re: [3.3][RC] Filter by country - version 1.0.19

Post by lacike »

Anybody else having issues to provide MaxMind licence key? 1.0.19 version of the extension keeps telling me "Your license key is invalid. Enter a valid MaxMind license key."
1. I generated 3.1.1 or above licence key here: https://www.maxmind.com/en/accounts/xxxxxx/license-key (xxxxxx is my account-id)
2. I copy paster the key to my phpBB
3. It keeps telling me it is incorrect.
4. I tried both Update and not for update version, 3.1.1 and also prior 3.1.1 licence key format. I also tried downloading the file manually and placing it to store folder.
User avatar
Onnozel Manneke
Registered User
Posts: 45
Joined: Mon Feb 01, 2021 8:37 pm
Location: Walhalla
Name: Loki Heimdall
Contact:

Re: [3.3][RC] Filter by country - version 1.0.19

Post by Onnozel Manneke »

MarkDHamill wrote:
Sat Dec 19, 2020 4:44 pm
RemmyH wrote:
Sat Dec 19, 2020 3:52 pm
Is there a Dutch translation available somewhere?
I came across a link somewhere but that site doesn't exist anymore.
His website is down but you can contact him through his profile.
I took over his styles & translations. Update will follow later today.
--> https://github.com/OnnozelManneke
User avatar
MarkDHamill
Registered User
Posts: 4366
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

Re: [3.3][RC] Filter by country - version 1.0.19

Post by MarkDHamill »

lacike wrote:
Wed Mar 03, 2021 6:21 am
Anybody else having issues to provide MaxMind licence key? 1.0.19 version of the extension keeps telling me "Your license key is invalid. Enter a valid MaxMind license key."
1. I generated 3.1.1 or above licence key here: https://www.maxmind.com/en/accounts/xxxxxx/license-key (xxxxxx is my account-id)
2. I copy paster the key to my phpBB
3. It keeps telling me it is incorrect.
4. I tried both Update and not for update version, 3.1.1 and also prior 3.1.1 licence key format. I also tried downloading the file manually and placing it to store folder.
The key must be 16 characters long. Login to maxmind.com. Look for Services > Manage License Keys on the left sidebar. You can't see the old license key but you can generate a new one. Do not create a key for the GeoIP update service.
Need phpBB services or a phpBB consultant? I offer most phpBB services. Getting lost managing phpBB? Buy my book, Mastering phpBB Administration. eBook and paper versions available.
User avatar
Onnozel Manneke
Registered User
Posts: 45
Joined: Mon Feb 01, 2021 8:37 pm
Location: Walhalla
Name: Loki Heimdall
Contact:

Re: [3.3][RC] Filter by country - version 1.0.19

Post by Onnozel Manneke »

RemmyH wrote:
Sat Dec 19, 2020 3:52 pm
Is there a Dutch translation available somewhere?
I came across a link somewhere but that site doesn't exist anymore.
NL Transation https://github.com/OnnozelManneke/filterbycountry
User avatar
MarkDHamill
Registered User
Posts: 4366
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

Re: [3.3][RC] Filter by country - version 1.0.19

Post by MarkDHamill »

I noticed the other day when testing in local mode (IP = 127.0.0.1) that this error was placed in phpBB's error log:
A call to the MaxMind country code database triggered an error. The database is most likely corrupt.
This hadn't occurred before and it may indicate a more general problem if the IP is not found in the MaxMind database. I thought maybe the database was corrupt but it was refreshed recently.

I developed a workaround. In /event/main_listener.php on line 625 replace:

Code: Select all

						if ($e->getCode() == 'AddressNotFoundException')
with:

Code: Select all

						if (preg_match('*The address (25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)(\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)){3} is not in the database.*',$e->getMessage()))
When the extension thinks the MaxMind database may be corrupt, it defaults to not bringing the board down so it will allow traffic from the IP.
Need phpBB services or a phpBB consultant? I offer most phpBB services. Getting lost managing phpBB? Buy my book, Mastering phpBB Administration. eBook and paper versions available.
Post Reply

Return to “Extensions in Development”