MediaWiki - Revision history

Leo: /* Mariadb 12 */

2025-08-18T23:57:03Z

Mariadb 12

← Older revision		Revision as of 23:57, 18 August 2025
Line 512:		Line 512:
	\| lang = text		\| lang = text
	}}		}}
	The fix is to downgrade the docker image back down to Mariadb 11. Fortunately, everything works even after Mariadb 12's database migration.{{Navbox Web}}		The fix is to downgrade the docker image back down to Mariadb 11. Fortunately, everything works even after Mariadb 12's database migration.

			This bug is tracked at https://phabricator.wikimedia.org/T401570<nowiki/>{{Navbox Web}}
	[[Category:WebApp]]		[[Category:WebApp]]

Leo: /* Troubleshooting */

2025-08-18T23:56:39Z

Troubleshooting

← Older revision		Revision as of 23:56, 18 August 2025
Line 504:		Line 504:
	) ENGINE=InnoDB DEFAULT CHARSET=binary;		) ENGINE=InnoDB DEFAULT CHARSET=binary;
	\| lang = terminal		\| lang = terminal
	}}{{Navbox Web}}		}}

			=== Mariadb 12 ===
			Mariadb 12 is not supported by MediaWiki (as of the time of writing, MediaWiki 1.44). I had some docker-compose files which references <code>mariadb:latest</code> which was recently changed over to verion 12 and this caused MediaWiki to think the database is in read-only mode. This resulted in this warning when trying to edit a page:
			{{Highlight
			\| code = The primary database server is running in read-only mode.
			\| lang = text
			}}
			The fix is to downgrade the docker image back down to Mariadb 11. Fortunately, everything works even after Mariadb 12's database migration.{{Navbox Web}}
	[[Category:WebApp]]		[[Category:WebApp]]

Leo at 00:13, 17 November 2023

2023-11-17T00:13:12Z

@@ Line 486: / Line 486: @@
 $wgDeprecationReleaseLimit = '1.30';
 | lang = php
 }}{{Navbox Web}}
 [[Category:WebApp]]

Leo: /* Adding the Score extension */

2023-01-30T07:16:58Z

Adding the Score extension

Show changes

Leo: /* Adding the Score extension */

2023-01-30T05:12:30Z

Adding the Score extension

@@ Line 317: / Line 317: @@
 #* The fuzzy png image apparently is from the ghostscript .ps to .png conversion. I'm not sure why this is even done separately when lilypond also generates the pngs. I hacked this by copying 'file.png' over 'file-page1.png' and commented out the runGhostscript call in the generatePngAndMidi.sh script.
 After overcoming all the aforementioned issues, I think I've finally got it working.
 ==Troubleshooting==
@@ Line 447: / Line 468: @@
 }}
-{{Navbox Web}}
+=== Updating from 1.37 to 1.39 ===
 [[Category:WebApp]]

Leo: /* Adding the Score extension */

2023-01-30T05:03:23Z

Adding the Score extension

← Older revision		Revision as of 05:03, 30 January 2023
Line 309:		Line 309:
	Issues are:		Issues are:

	# The extention ~~requires~~ the use of ShellBox because Lilypond may allow remote execution. You'll have to set up a ShellBox instance (as a separate container). MediaWiki/Wikipedia has their own container image which doesn't work outside their infrastructure so I had to make my own.		# The extention highly recommends the use of ShellBox to isolate Lilypond because Lilypond's insecure and may allow remote execution. Since this Wiki is editable to the public, this has to be done. You'll have to set up a ShellBox instance (as a separate container). MediaWiki/Wikipedia has their own container image which doesn't work outside their infrastructure so I had to make my own.
	# Lilypond is a piece of crap and breaks in my environment. I had to:		# Lilypond is a piece of crap and breaks in my environment. I had to:
	## Modify <code>/usr/bin/lilypond</code> to include <code>export PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" </code>otherwise it will fail silently in the extension's script. If you enable verbose mode on lilypond, you will see <code>warning: g_spawn_sync failed (0): gs: Failed to execute child process “gs” (No such file or directory)</code>.		#* Modify <code>/usr/bin/lilypond</code> to include <code>export PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" </code>otherwise it will fail silently in the extension's script. If you enable verbose mode on lilypond, you will see <code>warning: g_spawn_sync failed (0): gs: Failed to execute child process “gs” (No such file or directory)</code>.
	## Lilypond's defaults generate fuzzy low-res PNGs. I tried to enable SVG which after some tweaking works, but is a full page in size and can't be easily trimmed.		#* Lilypond's defaults generate fuzzy low-res PNGs. I tried to enable SVG which after some tweaking works, but is a full page in size and can't be easily trimmed.
	# The ~~extention is a piece of crap. The~~ included shell script is crap		#* Symlink the lilypond fonts because on Debian Bullseye, the package versions for Lilypond and Lilypond-fonts are mismatched so the paths are broken (What the heck Debian?)
	## The fuzzy png image apparently is from the ghostscript .ps to .png conversion. I'm not sure why this is even done separately when lilypond also generates the pngs. I hacked this by copying 'file.png' over 'file-page1.png' and commented out the runGhostscript call in the generatePngAndMidi.sh script.		# The Score extension's included shell script is crap.
			#* The fuzzy png image apparently is from the ghostscript .ps to .png conversion. I'm not sure why this is even done separately when lilypond also generates the pngs. I hacked this by copying 'file.png' over 'file-page1.png' and commented out the runGhostscript call in the generatePngAndMidi.sh script.
			After overcoming all the aforementioned issues, I think I've finally got it working.

	==Troubleshooting==		==Troubleshooting==

Leo at 04:43, 30 January 2023

2023-01-30T04:43:30Z

@@ Line 303: / Line 303: @@
 }}
 Replace 172.18.0.0/16 with the CIDR of your reverse proxy networks (this CIDR is my internal Traefik network for my Docker stack).
 ==Troubleshooting==

Leo: Undo revision 6669 by 174.211.32.16 (talk)

2022-03-14T04:05:28Z

Undo revision 6669 by 174.211.32.16 (talk)

← Older revision		Revision as of 04:05, 14 March 2022
Line 77:		Line 77:

	;WikiSEO		;WikiSEO
	:https://github.com//		:https://github.com/octfx/wiki-seo/
	:Enables custom SEO meta keyword and description tags on the wiki.		:Enables custom SEO meta keyword and description tags on the wiki.

Line 110:		Line 110:
	Skins should be able to handle contents on these MediaWiki pages which are typically shown somewhere on the page. Of course, custom skins can also reference their own set of pages such as the bootstrap/reader skin I'm currently using:		Skins should be able to handle contents on these MediaWiki pages which are typically shown somewhere on the page. Of course, custom skins can also reference their own set of pages such as the bootstrap/reader skin I'm currently using:

	*[[Bootstrap:~~Show source~~]		*[[Bootstrap:Footer]]
	*[[Bootstrap:Sidebar]]		*[[Bootstrap:Sidebar]]
	*[[Bootstrap:~~Show source~~]]		*[[Bootstrap:Jumbotron]]

	==Tasks==		==Tasks==

174.211.32.16: /* Configuration */

2022-03-05T22:32:59Z

Configuration

← Older revision		Revision as of 22:32, 5 March 2022
Line 77:		Line 77:

	;WikiSEO		;WikiSEO
	:https://github.com/~~octfx/wiki-seo~~/		:https://github.com//
	:Enables custom SEO meta keyword and description tags on the wiki.		:Enables custom SEO meta keyword and description tags on the wiki.

Line 110:		Line 110:
	Skins should be able to handle contents on these MediaWiki pages which are typically shown somewhere on the page. Of course, custom skins can also reference their own set of pages such as the bootstrap/reader skin I'm currently using:		Skins should be able to handle contents on these MediaWiki pages which are typically shown somewhere on the page. Of course, custom skins can also reference their own set of pages such as the bootstrap/reader skin I'm currently using:

	*[[Bootstrap:~~Footer]~~]		*[[Bootstrap:Show source]
	*[[Bootstrap:Sidebar]]		*[[Bootstrap:Sidebar]]
	*[[Bootstrap:~~Jumbotron~~]]		*[[Bootstrap:Show source]]

	==Tasks==		==Tasks==

Leo: /* The DynamicPageList extension doesn't sort by lastedit properly */

2022-01-25T04:51:25Z

The DynamicPageList extension doesn't sort by lastedit properly

← Older revision		Revision as of 04:51, 25 January 2022
Line 393:		Line 393:
	// To:		// To:
	case 'lastedit':		case 'lastedit':
	$fields['rc_timestamp'] = 'recentchanges.rc_timestamp';		$fields['rc_timestamp'] = 'MAX(recentchanges.rc_timestamp)';
	$tables['recentchanges'] = 'recentchanges';		$tables['recentchanges'] = 'recentchanges';
	$join['recentchanges'] = ['LEFT JOIN', '~~rc_cur_id~~ = ~~page_id~~'];		$join['recentchanges'] = ['LEFT JOIN', 'recentchanges.rc_title = page_title'];
	$options['GROUP BY'] = "page_id";		$options['GROUP BY'] = "page_id";
	$sqlSort = 'rc_timestamp';		$sqlSort = 'rc_timestamp';