Paladox

Previous discussion was archived at User talk:Paladox/Archive 1 on 2016-03-28.

Hi, I have in the wiki_1.35.3  Extension:DeletePagesForGood, but when I try to delete a page, doesn't work.

MediaWiki    1.35.3

PHP        7.3.29

MariaDB        10.3.29

DeletePagesForGood    2.0 (ebcf766)

The error is:

file.png&action=delete_page_permanently Wikimedia\Rdbms\DBQueryError from line 1699 of /var/www/wiki3/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' (localhost)

Function: Wikimedia\Rdbms\Database::select

Query: SELECT rev_text_id FROM `revision` WHERE rev_page=881

Backtrace:

#0 /var/www/wiki3/includes/libs/rdbms/database/Database.php(1683): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)

#1 /var/www/wiki3/includes/libs/rdbms/database/Database.php(1658): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)

#2 /var/www/wiki3/includes/libs/rdbms/database/Database.php(1227): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#3 /var/www/wiki3/includes/libs/rdbms/database/Database.php(1907): Wikimedia\Rdbms\Database->query(string, string, integer)

#4 /var/www/wiki3/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select(string, string, string)

#5 /var/www/wiki3/includes/libs/rdbms/database/DBConnRef.php(313): Wikimedia\Rdbms\DBConnRef->__call(string, array)

#6 /var/www/wiki3/extensions/DeletePagesForGood/ActionDeletePagePermanently.php(104): Wikimedia\Rdbms\DBConnRef->select(string, string, string)

#7 /var/www/wiki3/extensions/DeletePagesForGood/ActionDeletePagePermanently.php(55): ActionDeletePagePermanently->deletePermanently(Title)

#8 /var/www/wiki3/includes/htmlform/HTMLForm.php(707): ActionDeletePagePermanently->onSubmit(array, OOUIHTMLForm)

#9 /var/www/wiki3/includes/htmlform/HTMLForm.php(597): HTMLForm->trySubmit()

#10 /var/www/wiki3/includes/htmlform/HTMLForm.php(613): HTMLForm->tryAuthorizedSubmit()

#11 /var/www/wiki3/includes/actions/FormAction.php(160): HTMLForm->show()

#12 /var/www/wiki3/includes/MediaWiki.php(527): FormAction->show()

#13 /var/www/wiki3/includes/MediaWiki.php(313): MediaWiki->performAction(ImagePage, Title)

#14 /var/www/wiki3/includes/MediaWiki.php(940): MediaWiki->performRequest()

#15 /var/www/wiki3/includes/MediaWiki.php(543): MediaWiki->main()

#16 /var/www/wiki3/index.php(53): MediaWiki->run()

#17 /var/www/wiki3/index.php(46): wfIndexMain()

#18 {main}

Hi, do you still support this skin? I have a question there...

Is there a way to automate the DataDump extension? I'd like to clear out an existing backup and make the new backup in one click? It would be nice to have a button for images as well.

Thanks! Rsterbal (talk) 03:34, 1 September 2020 (UTC)

Marking as resolved, fix in the patches described in this thread.

Hi, I've installed the Extension:DeletePagesForGood, but when I try to delete a page, it doesn't work. The error is

Warning: preg_split(): No ending delimiter ':' found in <SITE PATH>\extensions\DeletePagesForGood\ActionDeletePagePermanently.php on line 165

Exception encountered, of type "Error"

----

PHP 7.0.9

MediaWiki 1.27.1

Hi I reported it here https://phabricator.wikimedia.org/T146598

May be because there was a change in php7, since I tested this on php 5.

hi I did this test fix https://gerrit.wikimedia.org/r/#/c/312796/ would you be able to test it please?

If it works I can then merge it.

Now I'm getting the error

Internal error

[238883a4ce388335357e7dab] 2016-09-25 22:58:22: Fatal exception of type "DBUnexpectedError"

Oh, iv'e updated https://gerrit.wikimedia.org/r/#/c/312796/ with a different fix, could you try that please.

Unless it may be using old db stuff which then I will need to see if that is broken.

Could you also set

$wgShowExceptionDetails = true;

and

$wgDevelopmentWarnings = true;

in localsettings.php, it may give us more info on what is causing the DBUnexpectedError error please?

[e0d818fd90271f519995febd] /site/index.php?title=DeletionTest&action=delete_page_permanently DBUnexpectedError from line 2668 of <site path> \includes\db\Database.php: MediaWiki::preOutputCommit: Flushing an explicit transaction, getting out of sync!

Backtrace:

#0 <site path> \includes\db\loadbalancer\LoadBalancer.php(1055): DatabaseBase->commit(string, string)

#1 <site path> \includes\db\loadbalancer\LBFactory.php(206): LoadBalancer->commitMasterChanges(string)

#2 <site path> \includes\db\loadbalancer\LBFactorySimple.php(154): LBFactory->{closure}(LoadBalancer, string, array)

#3 <site path> \includes\db\loadbalancer\LBFactory.php(208): LBFactorySimple->forEachLB(Closure, array)

#4 <site path> \includes\db\loadbalancer\LBFactory.php(250): LBFactory->forEachLBCallMethod(string, array)

#5 <site path> \includes\MediaWiki.php(560): LBFactory->commitMasterChanges(string, array)

#6 <site path> \includes\MediaWiki.php(539): MediaWiki::preOutputCommit(RequestContext)

#7 <site path> \includes\MediaWiki.php(750): MediaWiki->doPreOutputCommit()

#8 <site path> \includes\MediaWiki.php(519): MediaWiki->main()

#9 <site path> \index.php(43): MediaWiki->run()

#10 {main}

And I have an another question - is it possible to permanently delete a single edit from the history (e.g. a vandal one), because the only way to do this now is to hide it with the RevisionDelete thing; when I want to delete it from the db?

I'm not sure about the edit thing but the db that looks like changes in mediawiki core, I know someone who does the mw db I can ask him for help with this.

Yeah, it would be great; an extension like Delete Revision for Good ; maybe in the future.

Hi could you also test this https://gerrit.wikimedia.org/r/#/c/312797/ fix please?

[a9f6a78146dcbf0085a96a0c] /site/index.php?title=DeletionTest&action=delete_page_permanently DBUnexpectedError from line 2658 of <site path> \includes\db\Database.php: Got COMMIT while atomic sections ActionDeletePagePermanently::deletePermanently are still open

Backtrace:

#0 <site path> \includes\db\loadbalancer\LoadBalancer.php(1055): DatabaseBase->commit(string, string)

#1 <site path> \includes\db\loadbalancer\LBFactory.php(206): LoadBalancer->commitMasterChanges(string)

#2 <site path> \includes\db\loadbalancer\LBFactorySimple.php(154): LBFactory->{closure}(LoadBalancer, string, array)

#3 <site path> \includes\db\loadbalancer\LBFactory.php(208): LBFactorySimple->forEachLB(Closure, array)

#4 <site path> \includes\db\loadbalancer\LBFactory.php(250): LBFactory->forEachLBCallMethod(string, array)

#5 <site path> \includes\MediaWiki.php(560): LBFactory->commitMasterChanges(string, array)

#6 <site path> \includes\MediaWiki.php(539): MediaWiki::preOutputCommit(RequestContext)

#7 <site path> \includes\MediaWiki.php(750): MediaWiki->doPreOutputCommit()

#8 <site path> \includes\MediaWiki.php(519): MediaWiki->main()

#9 <site path> \index.php(43): MediaWiki->run()

#10 {main}

Ok I've updated https://gerrit.wikimedia.org/r/#/c/312797/ with a different fix could you try that please?

It works, thanks!

Oh, thanks for trying my fixes. I will get them merged tomarror :)

did it delete the page?

just wondering to make sure the fix did not have any unexpected changes that stopped it from deleting pages

Just deleted several pages and got no errors, so I guess, it's ok.

OK thanks I'm merging the patches now. And will backport them to the REL1_27 branch :)

I've backported it to the REL1_27 branch now.