Extension talk:DeletePagesForGood

Previous discussion was archived at Extension talk:DeletePagesForGood/Archive 1 on 2016-01-19.

Similar question than Not working since upgrading to 1.35, and the problem is now solved.

i test this extension in mediawiki 1.36 but the problem is the next:

Error de la base de datos Se ha producido un error en la consulta a la base de datos. Esto puede indicar un fallo en el software. [3102752f71c5e2193d32f7bb] 2021-06-20 06:59:10: Excepción grave de tipo "Wikimedia\Rdbms\DBQueryError"

¿any solution?

who know any extension similar to this?

There is Extension:Nuke with a different use case, but if the underlying question is "a working extension" then DeletePagesForGood now works since phabricator:T220884 is solved. You have to use the branch master (when you use Git or when you download it).

Solved. You have to use the branch master (when you use Git or when you download it).

Except for that bug where sometimes extension doesn't work when page has categories or text, this was working fine until upgrade. Updated the database several times without errors but that didn't work. Here's what I'm getting.

[X6OycVcDvIsIZ-OIJWQc8QAAAE0] /index.php?title=Categor%C3%ADa:Discos_de_m%C3%BAsica_Fusi%C3%B3n_folcl%C3%B3rica&action=delete_page_permanently Wikimedia\Rdbms\DBQueryError from line 1699 of /home/perm/mockup.org/wiki/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Error 1054: Unknown column 'rev_text_id' in 'field list' (mysql.mockup.org) Function: Wikimedia\Rdbms\Database::select Query: SELECT rev_text_id FROM `venci_revision` WHERE rev_page=16603 Backtrace:

1. 0 /home/perm/mockup.org/wiki/includes/libs/rdbms/database/Database.php(1683): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
2. 1 /home/perm/mockup.org/wiki/includes/libs/rdbms/database/Database.php(1658): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
3. 2 /home/perm/mockup.org/wiki/includes/libs/rdbms/database/Database.php(1227): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
4. 3 /home/perm/mockup.org/wiki/includes/libs/rdbms/database/Database.php(1907): Wikimedia\Rdbms\Database->query(string, string, integer)
5. 4 /home/perm/mockup.org/wiki/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select(string, string, string)
6. 5 /home/perm/mockup.org/wiki/includes/libs/rdbms/database/DBConnRef.php(313): Wikimedia\Rdbms\DBConnRef->__call(string, array)
7. 6 /home/perm/mockup.org/wiki/extensions/DeletePagesForGood/ActionDeletePagePermanently.php(104): Wikimedia\Rdbms\DBConnRef->select(string, string, string)
8. 7 /home/perm/mockup.org/wiki/extensions/DeletePagesForGood/ActionDeletePagePermanently.php(55): ActionDeletePagePermanently->deletePermanently(Title)
9. 8 /home/perm/mockup.org/wiki/includes/htmlform/HTMLForm.php(707): ActionDeletePagePermanently->onSubmit(array, OOUIHTMLForm)
10. 9 /home/perm/mockup.org/wiki/includes/htmlform/HTMLForm.php(597): HTMLForm->trySubmit()
11. 10 /home/perm/mockup.org/wiki/includes/htmlform/HTMLForm.php(613): HTMLForm->tryAuthorizedSubmit()
12. 11 /home/perm/mockup.org/wiki/includes/actions/FormAction.php(160): HTMLForm->show()
13. 12 /home/perm/mockup.org/wiki/includes/MediaWiki.php(527): FormAction->show()
14. 13 /home/perm/mockup.org/wiki/includes/MediaWiki.php(313): MediaWiki->performAction(CategoryTreeCategoryPage, Title)
15. 14 /home/perm/mockup.org/wiki/includes/MediaWiki.php(940): MediaWiki->performRequest()
16. 15 /home/perm/mockup.org/wiki/includes/MediaWiki.php(543): MediaWiki->main()
17. 16 /home/perm/mockup.org/wiki/index.php(53): MediaWiki->run()
18. 17 /home/perm/mockup.org/wiki/index.php(46): wfIndexMain()
19. 18 {main}

It seems the extension is not compatible with MW 1.35. You have to look for alternative.

Thanks! I'll look into it. This thing was awesome.

exist an a alternative of this extension?

This now works since phabricator:T220884 was solved, you have to use the branch master (when you use Git or when you download it).

Inexistant namespaces were removed from the config explanation on Extension page

Are those namespaces really correct ? Can't find them on the Meta-Wiki page and it creates an error on my wiki.

I think they aren't a thing. MW core uses NS_FILE and I can't find those from Extension default namespaces. Removed, thanks for the note.

Any time I try to perma-delete a page that is in a category, it throws a "Wikimedia\Rdbms\DBUnexpectedError" exception. Possibly because the extension does not remove category associations for the page (?).

This is also most likely the cause of the problem many others are having, where certain pages work but others don't (see below).

Temporary work-around: manually remove all Category tags from the page before perma-deleting it.

This happened to me because I was using a semantic mediawiki template in those pages I wanted to delete. I deleted the template and the problem went away. The template had a bunch of parser functions , so my guess is that was what it was Mark 02:50, 27 July 2019 (UTC)

When I try delete page, that write me error:

[b890fc3456e647424de6b01f] 2017-08-08 11:20:50: Неустранимое исключение типа «Wikimedia\Rdbms\DBUnexpectedError»

Read this: Topic:Tsu2kurqbgwrm544

There was a similar error.

Tried to run update.php, and try delete page. It's work.

However, before that, I deleted the category from the page.

Do not work for me anymore. Under shared server I can not use update.php I do not have shell console.

It's not really true. The extension works with 1.29.1 (tested) but does not work with content coming from 1.28.x

However, I updated the tables during the last update.

I updated the tables during the installation of version 1.29.1 but the extension DeletePagesForGood does not work.

On my debian server I tested update, without improvement.

On my local Debian server, however, I notice that, if indeed, I can not delete existing pages ...

I can create a new page, and destroy the new page created with the extension DeletePagesForGood.

I'm doing a deleteOldRevision.php to delete all the logs and save space in the database.

I test a "GOODBYE" page that refuses to be deleted with the extension DeletePagesForGood. I delete it normally. I recreate it. I can then delete it with the extension DeletePagesForGood. ( Delete / create / delete with DeletePagesForGood work for me. )

I have ask help here : https://phabricator.wikimedia.org/T113883

You can run the update.php script through mw-config (web ui)

<wiki>/mw-config/

I don't have the file update.php in the folder /mw-config/

Nope but it is the online updated for when you cannot run commands or ssh in.

I unpacked this extension and run update.php in the folder "maintenance". But when I tried to delete a page I received exception "Wikimedia\Rdbms\DBUnexpectedError". Is it possible to fix this problem?

I have the same problem on some pages but not all. Mine is also MW 1.31.

[23a349443279e368cc3e0372] 2018-11-30 15:32:10: Fatal exception of type "Wikimedia\Rdbms\DBUnexpectedError"

I did patch manually with https://gerrit.wikimedia.org/r/#/c/268902/

but it still fails on some pages.

Moved to Phabricator

When I try to delete page, it shows following error:

[900c19c0bc56df073fc35bae] /plavorexitbeta/index.php?title=User:PlavorSeol/Test&action=delete_page_permanently Wikimedia\Rdbms\DBQueryError from line 1443 of C:\inetpub\wwwroot\plavorexitbeta\includes\libs\rdbms\database\Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 

Query: DELETE FROM searchindex WHERE si_page = '177'

Function: ActionDeletePagePermanently::deletePermanently

Error: 1 no such column: si_page

Backtrace:

#0 C:\inetpub\wwwroot\plavorexitbeta\includes\libs\rdbms\database\Database.php(1413): Wikimedia\Rdbms\Database->makeQueryException(string, integer, string, string)

#1 C:\inetpub\wwwroot\plavorexitbeta\includes\libs\rdbms\database\Database.php(1186): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#2 C:\inetpub\wwwroot\plavorexitbeta\includes\libs\rdbms\database\Database.php(2887): Wikimedia\Rdbms\Database->query(string, string)

#3 C:\inetpub\wwwroot\plavorexitbeta\extensions\DeletePagesForGood\ActionDeletePagePermanently.php(86): Wikimedia\Rdbms\Database->delete(string, string, string)

#4 C:\inetpub\wwwroot\plavorexitbeta\extensions\DeletePagesForGood\ActionDeletePagePermanently.php(53): ActionDeletePagePermanently->deletePermanently(Title)

#5 C:\inetpub\wwwroot\plavorexitbeta\includes\htmlform\HTMLForm.php(662): ActionDeletePagePermanently->onSubmit(array, OOUIHTMLForm)

#6 C:\inetpub\wwwroot\plavorexitbeta\includes\htmlform\HTMLForm.php(554): HTMLForm->trySubmit()

#7 C:\inetpub\wwwroot\plavorexitbeta\includes\htmlform\HTMLForm.php(569): HTMLForm->tryAuthorizedSubmit()

#8 C:\inetpub\wwwroot\plavorexitbeta\includes\actions\FormAction.php(143): HTMLForm->show()

#9 C:\inetpub\wwwroot\plavorexitbeta\includes\MediaWiki.php(500): FormAction->show()

#10 C:\inetpub\wwwroot\plavorexitbeta\includes\MediaWiki.php(294): MediaWiki->performAction(Article, Title)

#11 C:\inetpub\wwwroot\plavorexitbeta\includes\MediaWiki.php(867): MediaWiki->performRequest()

#12 C:\inetpub\wwwroot\plavorexitbeta\includes\MediaWiki.php(524): MediaWiki->main()

#13 C:\inetpub\wwwroot\plavorexitbeta\index.php(42): MediaWiki->run()

#14 {main}

Of course I ran update.php

Fixed in https://gerrit.wikimedia.org/r/#/c/404083/

Hello! Yesterday I updated my wiki to the current master branch. The extension DeletePagesForGood works except while the user is not logged in. The error message is:

MediaWiki internal error.

Original exception: [WhFHY098QLwAAAqM4jUAAAAC] / UnexpectedValueException from line 239 of /var/www/mediawiki/includes/Hooks.php: Invalid return from ActionDeletePagePermanently::AddSkinHook for unabortable SkinTemplateNavigation::Universal.
Backtrace:
#0 /var/www/mediawiki/includes/skins/SkinTemplate.php(1153): Hooks::runWithoutAbort(string, array)
#1 /var/www/mediawiki/includes/skins/SkinTemplate.php(476): SkinTemplate->buildContentNavigationUrls()
#2 /var/www/mediawiki/includes/skins/SkinTemplate.php(249): SkinTemplate->prepareQuickTemplate()
#3 /var/www/mediawiki/includes/OutputPage.php(2438): SkinTemplate->outputPage()
#4 /var/www/mediawiki/includes/exception/PermissionsError.php(70): OutputPage->output()
#5 /var/www/mediawiki/includes/MediaWiki.php(529): PermissionsError->report()
#6 /var/www/mediawiki/index.php(43): MediaWiki->run()
#7 {main}

Exception caught inside exception handler: [WhFHY098QLwAAAqM4jUAAAAC] / UnexpectedValueException from line 239 of /var/www/mediawiki/includes/Hooks.php: Invalid return from ActionDeletePagePermanently::AddSkinHook for unabortable SkinTemplateNavigation::Universal.
Backtrace:
#0 /var/www/mediawiki/includes/skins/SkinTemplate.php(1153): Hooks::runWithoutAbort(string, array)
#1 /var/www/mediawiki/includes/skins/SkinTemplate.php(476): SkinTemplate->buildContentNavigationUrls()
#2 /var/www/mediawiki/includes/skins/SkinTemplate.php(249): SkinTemplate->prepareQuickTemplate()
#3 /var/www/mediawiki/includes/OutputPage.php(2438): SkinTemplate->outputPage()
#4 /var/www/mediawiki/includes/exception/MWExceptionRenderer.php(135): OutputPage->output()
#5 /var/www/mediawiki/includes/exception/MWExceptionRenderer.php(54): MWExceptionRenderer::reportHTML(UnexpectedValueException)
#6 /var/www/mediawiki/includes/exception/MWExceptionHandler.php(75): MWExceptionRenderer::output(UnexpectedValueException, integer)
#7 /var/www/mediawiki/includes/exception/MWExceptionHandler.php(149): MWExceptionHandler::report(UnexpectedValueException)
#8 /var/www/mediawiki/includes/MediaWiki.php(550): MWExceptionHandler::handleException(UnexpectedValueException)
#9 /var/www/mediawiki/index.php(43): MediaWiki->run()
#10 {main}

How can I solve this issue?

Hi, please give https://gerrit.wikimedia.org/r/#/c/404083/ that a try.

Hi this was resolved in https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/DeletePagesForGood/+/dc43aa69c3901784fdd440e39277db27b382854a%5E%21/#F0 (untested)

Fixed in https://gerrit.wikimedia.org/r/#/c/341006/

Hi @Paladox

I'm trying to use DeletePagesForGood with MW 1.25 and I'm getting a Fatal Error that has been experienced before:

Fatal error: Call to a member function refreshCounts() on a non-object in /u1/MediaWiki/extensions/DeletePagesForGood/ActionDeletePagePermanently.php on line

I attempted to manually fix this manually, but then got:

Fatal error: Call to private Category::__construct() from context 'DeletePagesForGood' in /u1/MediaWiki/extensions/DeletePagesForGood/DeletePagesForGood.class.php on line 195

I then tried to run the master branch on my version of MW but of course, it didn't work.

So I'm wondering if there's a way to fix this for MW 1.25?

Thanks

Fixed in https://gerrit.wikimedia.org/r/#/c/341006/

Closing as resolved as it is confirmed that fixed the problem.