sv1cec
03-26-2008, 06:01 PM
Hey guys, I have just noticed that the PMTEXT table in my database is huge. It has about 1500 pages. While checking the code that deletes private messages, I can't find the statement that clears up the pmtext record for each record in the pm table that gets deleted. I check vB 3.0.17, 3.6.5 and the latest release from vBulletin.
Do you think this is normal? I mean I understand that when a user deletes a PM from his inbox, the PMTEXT entry is not deleted since the message may have been sent to more than one recipients. But when is that PMTEXT entry going to be deleted? Is there a cron job that tests for orphan PMTEXT records and deletes them?
Please enlighten me.
--------------- Added 1206563782 at 1206563782 ---------------
Never mind, I figure out they couldn't have forgotten that. It is taken care of, by the Hourly Clean-up No2 cron script.
Do you think this is normal? I mean I understand that when a user deletes a PM from his inbox, the PMTEXT entry is not deleted since the message may have been sent to more than one recipients. But when is that PMTEXT entry going to be deleted? Is there a cron job that tests for orphan PMTEXT records and deletes them?
Please enlighten me.
--------------- Added 1206563782 at 1206563782 ---------------
Never mind, I figure out they couldn't have forgotten that. It is taken care of, by the Hourly Clean-up No2 cron script.