Paladox

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

Extension:DeletePagesForGood - Error

The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.

---

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 Sasazuka! (talk) 21:39, 25 September 2016 (UTC)

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. Paladox (talk) 22:37, 25 September 2016 (UTC)

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. Paladox (talk) 22:42, 25 September 2016 (UTC)

Now I'm getting the error

= Internal error =

[238883a4ce388335357e7dab] 2016-09-25 22:58:22: Fatal exception of type "DBUnexpectedError" Sasazuka! (talk) 23:00, 25 September 2016 (UTC)

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. Paladox (talk) 23:02, 25 September 2016 (UTC)

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? Paladox (talk) 23:04, 25 September 2016 (UTC)

[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} Sasazuka! (talk) 23:08, 25 September 2016 (UTC)

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? Sasazuka! (talk) 23:05, 25 September 2016 (UTC)

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. Paladox (talk) 23:11, 25 September 2016 (UTC)

Yeah, it would be great; an extension like Delete Revision for Good ; maybe in the future. Sasazuka! (talk) 23:15, 25 September 2016 (UTC)

Hi could you also test this https://gerrit.wikimedia.org/r/#/c/312797/ fix please? Paladox (talk) 23:38, 25 September 2016 (UTC)

[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} Sasazuka! (talk) 23:47, 25 September 2016 (UTC)

Ok I've updated https://gerrit.wikimedia.org/r/#/c/312797/ with a different fix could you try that please? Paladox (talk) 23:52, 25 September 2016 (UTC)

It works, thanks! Sasazuka! (talk) 00:01, 26 September 2016 (UTC)

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 Paladox (talk) 00:03, 26 September 2016 (UTC)

Just deleted several pages and got no errors, so I guess, it's ok. Sasazuka! (talk) 00:17, 26 September 2016 (UTC)

OK thanks I'm merging the patches now. And will backport them to the REL1_27 branch :) Paladox (talk) 00:20, 26 September 2016 (UTC)

I've backported it to the REL1_27 branch now. Paladox (talk) 00:41, 26 September 2016 (UTC)

The discussion above is closed. Please do not modify it. No further edits should be made to this discussion.

automating datadump

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)

Metrolook skin

Hi, do you still support this skin? I have a question there... Ludost Mlačani (talk) 12:37, 8 January 2021 (UTC)

Extension:DeletePagesForGood (mediawiki 1.35.x) - Error

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} Moskovets (talk) 16:49, 13 September 2021 (UTC)