DeleteOldRevisions - MediaWiki-l - lists.wikimedia.org

List overview All Threads
Download

DeleteOldRevisions

customizing layout of main page

Skin modifying

Udo Zaydowicz

26 Jan 2007 26 Jan '07

8:51 p.m.

Hi, I'm trying to get rid of the old revisions in my wiki (1.82). Using "php deleteOldRevisions.php" I get the reply: Searching for active revisions...done. Searching for inactive revisions...done. 0 old revisions found. But for sure, I do have (too many) old revisions in the wiki. So, where is the problem? Thanks in advance, zaydo

Reply

Show replies by date

Jan

27 Jan 27 Jan

12:26 a.m.

New subject: [Mediawiki-l] DeleteOldRevisions

Hi Udo, for me, deleteOldRevisions.php works fine. Are you sure, that you have added the correct DB-data to AdminSettings.Smaple and rename it? Best regards, Jan Udo Zaydowicz schrieb:

Hi, I'm trying to get rid of the old revisions in my wiki (1.82). Using "php deleteOldRevisions.php" I get the reply: Searching for active revisions...done. Searching for inactive revisions...done. 0 old revisions found. But for sure, I do have (too many) old revisions in the wiki. So, where is the problem? Thanks in advance, zaydo _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Reply

zaydo

28 Jan 28 Jan

10:04 a.m.

New subject: [Mediawiki-l] DeleteOldRevisions

Thanks, Jan. Yes, I'm pretty sure, that the correct DB-data are set. And actually, on the first usage of deleteOldRevisions it was deleting a few revisions (5 from an estimated 500). But since then I get this '0 revisions'. I was running a 1.7 version before and updated to 1.8.2 before I used deleteOldRevisions the first time. Might it be, that a incomplete/wrong update is the reason? zaydo Jan-62 wrote:

Hi Udo, for me, deleteOldRevisions.php works fine. Are you sure, that you have added the correct DB-data to AdminSettings.Smaple and rename it? Best regards, Jan Udo Zaydowicz schrieb:

Hi, I'm trying to get rid of the old revisions in my wiki (1.82). Using "php deleteOldRevisions.php" I get the reply: Searching for active revisions...done. Searching for inactive revisions...done. 0 old revisions found. But for sure, I do have (too many) old revisions in the wiki. So, where is the problem? Thanks in advance, zaydo _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

_______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

-- View this message in context: http://www.nabble.com/-Mediawiki-l--DeleteOldRevisions-tf3124848.html#a8673… Sent from the WikiMedia General mailing list archive at Nabble.com.

Reply

zaydo

4 Feb 4 Feb

10:09 a.m.

New subject: [Mediawiki-l] DeleteOldRevisions

Hi, sorry for pushing that thread up again. But my problem is not yet solved ;-) I still do not get the old revisions deleted. deleteOldRevisions.php/.inc correctly delivers all the active revisions in $set. But then: $res = $dbw->query( "SELECT rev_id FROM $tbl_rev WHERE rev_id NOT IN ( $set )" ); while( $row = $dbw->fetchObject( $res ) ) { $old[] = $row->rev_id; } $res contains "Resource id #38"; no idea, what that means. And $old is empty, although there are inactive revisions. Manually executing the above-mentioned query delivers inactive revidions. But why is the script not working? I do get a warning "set_time_limit() [ function.set-time-limit function.set-time-limit ]: Cannot set time limit in safe mode in xxxx" at start of deleteOldRevisions. But it runs to the end. Any ideas? Thanks in advance, zaydo _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l -- View this message in context: http://www.nabble.com/-Mediawiki-l--DeleteOldRevisions-tf3124848.html#a8791… Sent from the WikiMedia General mailing list archive at Nabble.com.

Reply

Rob Church

6:28 p.m.

New subject: [Mediawiki-l] DeleteOldRevisions

On 04/02/07, zaydo <zaydo(a)gmx.de> wrote:

$res = $dbw->query( "SELECT rev_id FROM $tbl_rev WHERE rev_id NOT IN ( $set )" ); while( $row = $dbw->fetchObject( $res ) ) { $old[] = $row->rev_id; }

What version of MediaWiki? I seem to recall the original script had table prefix support added after the base functionality was done, and there were a couple of problems with it in the first release version. You could pinch the script (and dependencies) from a newer version, such as 1.8.x and see if those work. Rob Church

Reply

zaydo

7:33 p.m.

New subject: [Mediawiki-l] DeleteOldRevisions

Thanks, Rob. I'm running 1.8.2, which was installed over 1.7.x using the web-based installation. The problem definitely is, that the below query is not successful; $res is empty, although $set is ok. Although I do not get any warning: might it be a problem, that my provider only allows me 8 MB for php? Well, maybe I upgrade to 1.8.3 as soon as I have the time for it. Hopefully it will solve the problem ;-) zaydo Rob Church wrote:

On 04/02/07, zaydo <zaydo(a)gmx.de> wrote:

$res = $dbw->query( "SELECT rev_id FROM $tbl_rev WHERE rev_id NOT IN ( $set )" ); while( $row = $dbw->fetchObject( $res ) ) { $old[] = $row->rev_id; }

What version of MediaWiki? I seem to recall the original script had table prefix support added after the base functionality was done, and there were a couple of problems with it in the first release version. You could pinch the script (and dependencies) from a newer version, such as 1.8.x and see if those work. Rob Church _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

-- View this message in context: http://www.nabble.com/-Mediawiki-l--DeleteOldRevisions-tf3124848.html#a8795… Sent from the WikiMedia General mailing list archive at Nabble.com.

Reply

zaydo

5 Feb 5 Feb

11:15 p.m.

New subject: [Mediawiki-l] DeleteOldRevisions

Hi, no, the new version did not really solve the problem. After installing 1.9.2, I ran deleteOldRevisions (no table prefix selected on install). It actually found 2 revisions (out of appr. 600+). But those were not purged: "0 inactive items found." Quite obviously, the following code (in deleteOldRevisions.inc and purgeOldText.inc) $res = $dbw->query( "SELECT ........... NOT IN ( $set )" ); while( $row = $dbw->fetchObject( $res ) ) { $old[] = $row->....; is not working. $set is 'loaded' with valid values, $res delivers an ID, but §old is always empty. And I have absolutely no idea, why. Help ;-) Thanks in advance, zaydo _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l -- View this message in context: http://www.nabble.com/-Mediawiki-l--DeleteOldRevisions-tf3124848.html#a8816… Sent from the WikiMedia General mailing list archive at Nabble.com.

Reply

6283

days inactive

6293

days old

mediawiki-l@lists.wikimedia.org

Manage subscription

6 comments

4 participants

tags (0)

participants (4)

Jan
Rob Church
Udo Zaydowicz
zaydo