Cant prune.

[version2]

Im getting this error when I try to mass prune:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/version2/public_html/admin/db_mysql.php on line 154

[Wayne Luke]

Try pruning in smaller amounts of posts or increasing the maximum execution time for PHP scripts.

[Joshua Clinard]

Your still using vB 2.2.1. This problem should be fixed in vB2.2.2.

[version2]

*sigh*

Downloading now.

[version2]

Originally posted by Joshua Clinard
Your still using vB 2.2.1. This problem should be fixed in vB2.2.2.

Nope...that wasnt it.

wluke: Man, I am going 2 days at a time and it is still screwing up. I got another error by the way. Here it is:


Database error in vBulletin Control Panel 2.2.1:

Invalid SQL: DELETE FROM attachment WHERE attachmentid IN (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) AND NOT attachmentid IN (00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 000000000000000000000000000000...




And those 0's go on for a LOOOOONG time.

[John]

What happens after the 0's?

Also, try changing line 1887 from:
$omitattachmentids.=$omitattach['attachmentid'];

to:
$omitattachmentids.=$omitattach['attachmentid'].",";

[version2]

Line 1887 of what page?

After about 50 lines of zeros we get this:

mysql error: MySQL server has gone away

mysql error number: 2006

Date: Tuesday 22nd of January 2002 02:13:40 PM
Script: http://www.mysticwicks.com/admin/thread.php
Referer: http://www.mysticwicks.com/admin/thread.php

[John]

Thy this:

Change functions.php lines 1886 to 1891:

    // make sure you don't remove attachments that are already in use!
    $checkattachments=$DB_site->query("SELECT DISTINCT attachmentid FROM post WHERE attachmentid IN ($attachmentids"."0) AND threadid<>'$threadid'");
    $omitattachmentids="";
    while ($omitattach=$DB_site->fetch_array($checkattachments)) {
            $omitattachmentids.=$omitattach['attachmentid'].",";
        } 

The code should look similar to that already.

John

[version2]

Well, that fixed the pruning problem. I think that this little mishap has cost me ALL of my attachments that were on the board.