1/8/2024 0 Comments Bitnami mediawiki stack 1.16.2![]() Also, replaced "distinctrow" with "distinct" - it's really better, and it bugged you ealier :) Jehy 23:47, 20 September 2010 (UTC) Reply Keep at least five or ten revisions, regardless of date Thanks, fixed this in 1.4.4 - now extension detects database type. I have commented out the optimization loop around line 369 to get it working. In /var/www/wiki/htdocs/mediawiki/includes/db/DatabasePostgres.php ![]() Query failed: ERROR: unrecognized configuration parameter "tables" Other databased either have other methods to "optimize" tables or don't need that step at all. The added "Optimize Table" loop breaks it for any database other than MySQL, since MySQL specific commands are used. Table Optimization in 1.4.3 Breaks it Further (Fixed) $res = $dbw->query( "SELECT DISTINCT ar_text_id FROM $tbl_arc" ) $res = $dbw->query( "SELECT DISTINCTROW ar_text_id FROM $tbl_arc" ) $res = $dbw->query( "SELECT DISTINCT rev_text_id FROM $tbl_rev" ) $res = $dbw->query( "SELECT DISTINCTROW rev_text_id FROM $tbl_rev" ) The extension seems to work with Postgres when you change (line 103): By the way, I may be wrong, but it seems that DISTINCT is more appropriate in your script (I'm not MySQL nor PHP fluent, but it looks like you want to build a set as a filter, and DISTINCTROW may return useless duplicates). I guess this extension was written with MySQL in mind. Object(OutputPage), Object(User), Object(WebRequest)) #7 /filer/s/k/undisclosed/w/index.php(116): MediaWiki->initialize(Object(Title), NULL, #6 /filer/s/k/undisclosed/w/includes/Wiki.php(59): MediaWiki->initializeSpecialCases(Object(Title), #5 /filer/s/k/undisclosed/w/includes/Wiki.php(229): SpecialPage::executePath(Object(Title)) #4 /filer/s/k/undisclosed/w/includes/SpecialPage.php(559): DeleteOldRevisionsPage->execute(NULL) #3 /filer/s/k/undisclosed/w/extensions/SpecialDeleteOldRevisions2/SpecialDeleteOldRevisions2.php(530): #2 /filer/s/k/undisclosed/w/extensions/SpecialDeleteOldRevisions2/SpecialDeleteOldRevisions2.php(502): #1 /filer/s/k/undisclosed/w/extensions/SpecialDeleteOldRevisions2/SpecialDeleteOldRevisions2.php(103): #0 /filer/s/k/undisclosed/w/includes/db/Database.php(616): DatabasePostgres->reportQueryError LINE 1: SELECT /* WikiSysop */ DISTINCTROW rev_text_id FROM revisio. Query: SELECT DISTINCTROW rev_text_id FROM revisionĮrror: 1 ERROR: syntax error at or near "rev_text_id" $maxDate = $this->mRequest->getText( 'wpMaxDate' )). If the extension is used with a Postgres database as backend, the following error occurs:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |