MediaWiki: MySQL to extract path to images
In not as many words as others, here's my MySQL query to extract details on images stored in the MediaWiki CMS system (v1.14).
Read noteKnowledge base / Since 1999
Scripts, systems & field notes.
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
7 entries / MediaWiki
Clear filters
List MediaWiki Articles
What do I want? Page ID, Title, Content, Category, AccessLevel (note that AccessLevel is extra to your standard MediaWiki setup and one that was customized for my day job). Thought I already had this somewhere on my site, so it took a while again but I've posted my finished query here: The base query to list mediawiki...
Read note
Change the login link in MediaWiki
As usual I have searched the WWW but I obviously don't how to use Google because I couldn't find an answer. My situation is this: We have an internal wiki knowledge base using MediaWiki version 1.14. Some articles are available for public, some are restricted to staff and different localgroups. When users click on the...
Read note
Comparing two mediawiki sites
In this particular case, I'm comparing my Live and Dev versions of the same MediaWiki site. I want to add the SQL queries I used to this article but I'm in the middle of carrying out this process and it's due in two hours. Checking both MediaWiki have the same article content: Print Special:AllPages from both sites and...
Read note
How to put MediaWiki into Debug mode
By adding the following line to your LocalSettings.php file, you will be able to log everything that WikiMedia does: $wgDebugLogFile = '/home/username/public_html/wikidir/logfile'; IMPORTANT NOTE: The path above should be the exact full path to the wiki directory under your account.
Read note
Mediawiki Extension for Camtasia Studio SWF videos
This took me a whole afternoon and involved a lot of hope as I browsed the Internet and no one seemed to have done this before. Fortunately, MediaWiki extensions are easier to write than Joomla CMS ones :c) This article shows you how to get your MediaWiki system to display your Camtasia Studio SWF files in it's article...
Read note
Migrate MediaWiki to another server
Old Server mysqldump -u root -p wikidb > wikidb.sql tar -cvf wiki.tar wiki ;this is the wiki folder on document root New Server: create database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert, update, delete, lock tables on wikidb.* to wiki@localhost identified...
Read note
Loading more notes...
All published notes loaded.