Session Table Filling up then crashing

[wcjw1140]

Hi guys,

I run a pretty large forum and just recently upgraded to the latest version of the forums.

After upgrading the session table fills up and then crashes the whole forum. Is there some sort of recurring vBulletin job that clears the session table that may not be running? How would I check to ensure this is running?

Thanks!

-Blair

[Lynne]

Both of the Hourly Cleanup scrips clean out the session table, so make sure they are running.

[wcjw1140]

Thanks Lynn - let me apologize in advance for asking a really dumb question, but where would I look to make sure these cleanup scripts are working?

[Lynne]

They are Scheduled Tasks. You may go into the Scheduled Task Manager, select the task to edit and click on Log Entries > Yes. Then they should start showing up in the Scheduled Task Log.

[wcjw1140]

Thanks Lynn.

I began logging these scheduled tasks and they don't appear to run automatically. They will however, run if I run them manually. This issue started after I upgraded to 3.8.1.

I've set the permissions for all the cron php files to 777 to make sure it wasn't a permissions issue either.

Where should I go from here?

[Lynne]

Make sure you have these lines in your footer template:
<!-- Do not remove $cronimage or your scheduled tasks will cease to function -->
$cronimage
<!-- Do not remove $cronimage or your scheduled tasks will cease to function -->

[wcjw1140]

That was it!!! Thanks Lynn! Really weird why that would disappear.

On a side note, do you know what the php code would be to create a scheduled task that would delete all threads from all forums older than 365 days and users who have not logged in in over 365 days? I've looked all over the forums but haven't been able to find anything...

Thanks again for your help!

[Lynne]

You can go to Prune Threads in the Admin CP to remove threads and you can Prune Users also in there. The queries are in those admin pages. I don't just 'know' them, sorry.