Announcement

Collapse
No announcement yet.

Mass pruning errors.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mass pruning errors.

    Every time I try to mass prune even if its just like 20-30 posts I get this error:

    Deleting...


    Fatal error: Maximum execution time of 30 seconds exceeded in /***/****/***/boards/admin/db_mysql.php on line 153

    Is there any way to mass prune still?

    I'm running the latest version of VB.

  • #2
    take a read of http://vbulletin.com/forum/showthrea...threadid=33734
    :: Always Back Up Forum Database + Attachments BEFORE upgrading !
    :: Nginx SPDY SSL - World Flags Demo [video results]
    :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

    Comment


    • #3
      Originally posted by eva2000
      take a read of http://vbulletin.com/forum/showthrea...threadid=33734
      I was going to run the alter table add searchindex to postid query when I decided to see what was already in the searchindex.

      This is what I have:

      mysql> describe searchindex;
      +---------+----------------------+------+-----+---------+-------+
      | Field | Type | Null | Key | Default | Extra |
      +---------+----------------------+------+-----+---------+-------+
      | wordid | int(10) unsigned | | PRI | 0 | |
      | postid | int(10) unsigned | | PRI | 0 | |
      | intitle | smallint(5) unsigned | | | 0 | |
      +---------+----------------------+------+-----+---------+-------+
      3 rows in set (0.00 sec)


      Isn't the postid already indexed since it's set to primary key?
      Marc
      -------

      Comment


      • #4
        also, tried that simple if statement that afterburner recommended in that thread and came up with a parse error. Any idea why it would throw off that error. Made changes exactly per the post/thread.
        Marc
        -------

        Comment


        • #5
          upgrading to 2.2.2 would help as well
          :: Always Back Up Forum Database + Attachments BEFORE upgrading !
          :: Nginx SPDY SSL - World Flags Demo [video results]
          :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X