Board updated to phpbb 3.3.9

English support forum

Moderators: white, Hacker, petermad, Stefan2

User avatar
ghisler(Author)
Site Admin
Site Admin
Posts: 48021
Joined: 2003-02-04, 09:46 UTC
Location: Switzerland
Contact:

Board updated to phpbb 3.3.9

Post by *ghisler(Author) »

Today I have updated the board software to phpbb 3.3.9. Please let me know if you encounter any problems.

I plan to update php from 7.4.x to 8.1.x soon because 7.4 is now end of life.
Author of Total Commander
https://www.ghisler.com
User avatar
white
Power Member
Power Member
Posts: 4595
Joined: 2003-11-19, 08:16 UTC
Location: Netherlands

Re: Board updated to phpbb 3.3.9

Post by *white »

ghisler(Author) wrote: 2022-12-13, 11:24 UTC I plan to update php from 7.4.x to 8.1.x soon because 7.4 is now end of life.
MariaDB 5.5 has been end of life for two and a half years. Are you going to update MariaDB as well?
User avatar
ghisler(Author)
Site Admin
Site Admin
Posts: 48021
Joined: 2003-02-04, 09:46 UTC
Location: Switzerland
Contact:

Re: Board updated to phpbb 3.3.9

Post by *ghisler(Author) »

I will have to because in order to go from PHP 7.4 to 8, I need to update Mediawiki 1.35.8 to 1.39 (both are the long term support versions), and that needs MariaDB 10.3.0+.

The MariaDB 5.5 you refer to comes with Centos 7 and contains backported patches.

I found instructions to update MariaDB here (my server uses Plesk):
https://support.plesk.com/hc/en-us/articles/213403429--How-to-upgrade-MySQL-5-5-to-5-6-5-7-or-MariaDB-5-5-to-10-x-on-Linux-?source=search
There is a danger that the forum will stop working completely when applying this, so I'm currently trying to figure out how to make a rollback if it fails.
Author of Total Commander
https://www.ghisler.com
User avatar
ghisler(Author)
Site Admin
Site Admin
Posts: 48021
Joined: 2003-02-04, 09:46 UTC
Location: Switzerland
Contact:

Re: Board updated to phpbb 3.3.9

Post by *ghisler(Author) »

It looks like the update to MariaDB 10.5 was successful:
https://www.ghisler.ch/wiki/index.php/Special:Version

Please let me know if there are any problems.

Edit: The Wiki is now on 1.39.0, the new long term support (LTS) version of MediaWiki.
Author of Total Commander
https://www.ghisler.com
User avatar
white
Power Member
Power Member
Posts: 4595
Joined: 2003-11-19, 08:16 UTC
Location: Netherlands

Re: Board updated to phpbb 3.3.9

Post by *white »

Thanks for updating the wiki software to version 1.39.0

I noticed the interwiki table is outdated. The interwiki prefix ""mw" for linking to MediaWiki is not defined. This prefix is used on the following pages (see Vector 2022): The file mediawiki-1.39.0\maintenance\interwiki.list contains default interwiki prefixes supplied with MediaWiki 1.39.0. In there, you can find the line:

Code: Select all

mw|https://www.mediawiki.org/wiki/$1|0|https://www.mediawiki.org/w/api.php
The current interwiki table used by Total Commander wikis can be viewed with the following urls:
https://www.ghisler.ch/wiki/api.php?action=query&meta=siteinfo&siprop=interwikimap
https://www.ghisler.ch/wikide/api.php?action=query&meta=siteinfo&siprop=interwikimap

Information on how to add entries to the interwiki table can be found here: It recommends to install and use the "Interwiki" extension. And it says alternatively, you can export the interwiki table, add a line and then re-import it.
User avatar
ghisler(Author)
Site Admin
Site Admin
Posts: 48021
Joined: 2003-02-04, 09:46 UTC
Location: Switzerland
Contact:

Re: Board updated to phpbb 3.3.9

Post by *ghisler(Author) »

I have run the following database command, did it do what you expected?

Code: Select all

INSERT INTO ewiki_interwiki (iw_prefix, iw_url, iw_local, iw_trans, iw_api, iw_wikiid) VALUES ('w', 'https://en.wikipedia.org/wiki/$1', 1, 0, "",0);
Author of Total Commander
https://www.ghisler.com
User avatar
white
Power Member
Power Member
Posts: 4595
Joined: 2003-11-19, 08:16 UTC
Location: Netherlands

Re: Board updated to phpbb 3.3.9

Post by *white »

ghisler(Author) wrote: 2022-12-19, 16:14 UTC I have run the following database command, did it do what you expected?
If I check the links:
white wrote: 2022-12-19, 11:41 UTC The current interwiki table used by Total Commander wikis can be viewed with the following urls:
https://www.ghisler.ch/wiki/api.php?action=query&meta=siteinfo&siprop=interwikimap
https://www.ghisler.ch/wikide/api.php?action=query&meta=siteinfo&siprop=interwikimap
I see that an extra prefix "w" is added (and some extra fields) for "https://en.wikipedia.org/wiki/$1". The default prefix "WikiPedia" also still exists.
I tested the prefix "w" on a wiki page and that works. However, this was not the prefix that needed to be added. Was this a test to see if it works? The prefix "mw" for "https://www.mediawiki.org/wiki/$1" needs to be added.
User avatar
ghisler(Author)
Site Admin
Site Admin
Posts: 48021
Joined: 2003-02-04, 09:46 UTC
Location: Switzerland
Contact:

Re: Board updated to phpbb 3.3.9

Post by *ghisler(Author) »

I simply followed the instructions on the page you linked to. There it told me to add the prefix "w":
https://www.mediawiki.org/wiki/Manual:Interwiki#Adding_a_new_website_for_interwiki_linking

Where is the prefix mw used? I have now added that too and cleared the php cache and purged the wiki page cache with
https://www.ghisler.ch/wiki/index.php?title=Special:Version#mw-version-skin&action=purge
but the page still links from "mw:Desktop Improvements" to an internal page...
Author of Total Commander
https://www.ghisler.com
User avatar
white
Power Member
Power Member
Posts: 4595
Joined: 2003-11-19, 08:16 UTC
Location: Netherlands

Re: Board updated to phpbb 3.3.9

Post by *white »

ghisler(Author) wrote: 2022-12-20, 08:42 UTC I simply followed the instructions on the page you linked to. There it told me to add the prefix "w":
https://www.mediawiki.org/wiki/Manual:Interwiki#Adding_a_new_website_for_interwiki_linking
That command was just an example on how to add an entry to the interwiki table. You have to adjust it to your own need.
  • So you have to use prefix "mw" because this is the prefix you want to add because it is used in the MediaWiki software.
  • You have to replace "https://en.wikipedia.org/wiki/$1" with "https://www.mediawiki.org/wiki/$1" because that is the external wiki it should redirect to.
  • It seems to me iw_local should be 0. I think iw_local value 1 should only be used for other (local!) wikis within your Wiki Family. And only if you wish that interwiki linking can occur within links coming from external sources to your wiki.
  • iw_trans=0 seems OK to me.
  • Why did you add iw_api="" and iw_wikiid=0 ? It says they are optional.
    iw_api="" seems to be the same as leaving it out.
    iw_wikiid is a database name, see https://www.mediawiki.org/wiki/Manual:Interwiki_table. The value 0 doesn't seem to be a valid name. None of the entres in the Wikipedia interwiki table have a wikiid defined. It doesn't seem to be something you would normally add.
ghisler(Author) wrote: 2022-12-20, 08:42 UTC Where is the prefix mw used? I have now added that too and cleared the php cache and purged the wiki page cache with
https://www.ghisler.ch/wiki/index.php?title=Special:Version#mw-version-skin&action=purge
but the page still links from "mw:Desktop Improvements" to an internal page...
It's working now. Perhaps because I removed the anchor from the purge url (or perhaps not). But it incorrectly redirects to wikipedia instead of mediawiki. I think you didn't notice the difference between the two urls.
User avatar
ghisler(Author)
Site Admin
Site Admin
Posts: 48021
Joined: 2003-02-04, 09:46 UTC
Location: Switzerland
Contact:

Re: Board updated to phpbb 3.3.9

Post by *ghisler(Author) »

So you have to use prefix "mw" because this is the prefix you want to add because it is used in the MediaWiki software.
A sorry, I didn't know that. It's strange that the update didn't add it automatically.
You have to replace "https://en.wikipedia.org/wiki/$1" with "https://www.mediawiki.org/wiki/$1" because that is the external wiki it should redirect to.
Done.
It seems to me iw_local should be 0. I think iw_local value 1 should only be used for other (local!) wikis within your Wiki Family. And only if you wish that interwiki linking can occur within links coming from external sources to your wiki.
iw_trans=0 seems OK to me.
Why did you add iw_api="" and iw_wikiid=0 ? It says they are optional.
iw_api="" seems to be the same as leaving it out.
Where would you set these? In LocalSettings.php ? I can't find any of them there.
Author of Total Commander
https://www.ghisler.com
User avatar
white
Power Member
Power Member
Posts: 4595
Joined: 2003-11-19, 08:16 UTC
Location: Netherlands

Re: Board updated to phpbb 3.3.9

Post by *white »

ghisler(Author) wrote: 2022-12-26, 11:50 UTC
You have to replace "https://en.wikipedia.org/wiki/$1" with "https://www.mediawiki.org/wiki/$1" because that is the external wiki it should redirect to.
Done.
Confirmed, but the cache hasn't expired yet. The Interwiki cache normally expires in 3 hours as set by $wgInterwikiExpiry or when you use the maintenance script clearInterwikiCache.php. So after a couple of hours from now, it will probably be OK. (Edit: They work now.)
ghisler(Author) wrote: 2022-12-26, 11:50 UTC
It seems to me iw_local should be 0. I think iw_local value 1 should only be used for other (local!) wikis within your Wiki Family. And only if you wish that interwiki linking can occur within links coming from external sources to your wiki.
iw_trans=0 seems OK to me.
Why did you add iw_api="" and iw_wikiid=0 ? It says they are optional.
iw_api="" seems to be the same as leaving it out.
Where would you set these? In LocalSettings.php ? I can't find any of them there.
These are interwiki table fields you used yourself:
ghisler(Author) wrote: 2022-12-19, 16:14 UTC I have run the following database command, did it do what you expected?

Code: Select all

INSERT INTO ewiki_interwiki (iw_prefix, iw_url, iw_local, iw_trans, iw_api, iw_wikiid) VALUES ('w', 'https://en.wikipedia.org/wiki/$1', 1, 0, "",0);
ghisler(Author) wrote: 2022-12-20, 08:42 UTC I simply followed the instructions on the page you linked to. There it told me to add the prefix "w":
https://www.mediawiki.org/wiki/Manual:Interwiki#Adding_a_new_website_for_interwiki_linking
Last edited by white on 2022-12-26, 14:12 UTC, edited 1 time in total.
Reason: Interwiki links work now
arko
Junior Member
Junior Member
Posts: 84
Joined: 2020-04-05, 06:41 UTC

Re: Board updated to phpbb 3.3.9

Post by *arko »

Is it possible to enable user-tagging? For example, in this post I want @Hacker to be notified that his name was mentioned.
User avatar
Hacker
Moderator
Moderator
Posts: 13052
Joined: 2003-02-06, 14:56 UTC
Location: Bratislava, Slovakia

Re: Board updated to phpbb 3.3.9

Post by *Hacker »

arko,
People get notified when they're quoted, not sure about @-tagging. I personally don't read notifications. On the other hand, I read all posts (except the Spanish, Dutch and French ones).

Roman
Mal angenommen, du drückst Strg+F, wählst die FTP-Verbindung (mit gespeichertem Passwort), klickst aber nicht auf Verbinden, sondern fällst tot um.
arko
Junior Member
Junior Member
Posts: 84
Joined: 2020-04-05, 06:41 UTC

Re: Board updated to phpbb 3.3.9

Post by *arko »

Hacker wrote: 2022-12-26, 17:56 UTCOn the other hand, I read all posts
Avatar image checks out :)
User avatar
white
Power Member
Power Member
Posts: 4595
Joined: 2003-11-19, 08:16 UTC
Location: Netherlands

Re: Board updated to phpbb 3.3.9

Post by *white »

New version MediaWiki 1.39.1 was released without pre-release announcement. It's a (low) security and maintenance release. See this announcement.
Post Reply