Devops Known Issues
Please see below as the list of all knowns issues during the development of PKC.
- Error database on Special:AllPages
Occured after migrating Mediawiki database version 1.35 to version 1.37. From the error message displayed, it is stating that SQL Query is forcibly using index called name_title on page table, which is non existance. Error message also suggest to run update.php maintenance script to resolve the issue. When update.php is executed, another error messages shows that Extension:TemplateStyle is not found. To resolve the error message during update.php, decided to activate Template Style extension, which can be found on Mediawiki home page on this link
To activate, modification on LocalSetting.php is made by adding below lines on the bottom of the file.
wfLoadExtension( 'TemplateStyles' );
Update.php script is successfully run after the extension is installed, however the exact error message is still displayed on Special:All Pages. To check on the further issues, decided to inspect the page table through PHPMyAdmin accessible through this link. From the inspection, found that index called "name_title" is not exists, causing the page to break.
Searching through the Mediawiki homepage, found that this particular index is use by MWDumper Extension, can be found here, which also when this documentation is written on 14-Feb-2022, is not actively maintain and cannot be use to import from version 1.31. However, the source-code that is installed is still trying to find non-existance index. So, decided to rename the existing index of page_name_title to become name_title. Once the index is renamed, the issue is resolved.