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
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@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
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@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
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@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On 04/02/07, zaydo zaydo@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
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@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@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
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@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org