Thanks, Ryan!

You can run the script manually from the browser to see if it's working for you, but note that you will not receive any output in the browser. When it's done, it will either just stop running with a blank screen or say "No Data".

Jennifer.

just a note, foe some reason my global.php had this.
instead of this
I have 2.2.9. So if you have trouble finding that line, this may be why.

Derek

Well it works but I get a database error:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: DELETE FROM searchindex WHERE wordid IN (0) AND postid=
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql error number: 1064

Date: Sunday 20th of April 2003 08:51:59 AM
Script: http://www.talkdisney.com/forums/for...cron_prune.php
Referer:

could this be because i emptied my searchindex to save space?

any idea why I get this when trying to run this on command line

[root@srv1 forums]# php -q /home/virtual/site1/fst/var/www/html/forums/admin/cron_prune.php

Warning: main(./config.php) [http://www.php.net/function.main]: failed to create stream: No such file or directory in /home/virtual/site1/fst/var/www/html/forums/admin/global.php on line 96

yet if I go direct to the admin dir and run the script w/o the whole path but with just the file, it works no prob.

D

look in global.php and see what it's trying to do on line 96.

Just what I needed! Thanks! I think there's a lot of people that are looking for something like this but didn't type in the right search terms to find it. Works great in combination with the newsgroup hack for deleting old threads that can take up extra space. :)