Disable all unnecessary log data

calande · Post by **calande** » Wed Nov 08, 2006 5:45 pm

I was looking at a phpMyFAQ DB that got very big. The .sql file took a while to open in Kate, and there was a huge amount of junk (adminlogs, access logs, captcha info...) I removed everything but I'd like to know how to disable these logs so that it doesn't fill up again

Thanks,

matteo · Post by **matteo** » Wed Nov 08, 2006 8:27 pm

Hi,
I suppose you're running PMF 1.6.6, let's see each of the tables:

faqadminlog, go to the Edit configuration page and uncheck the use Adminlog? entry;
faqsessions, go to the Edit configuration page and uncheck the use Tracking? entry;
faqcaptcha, on each captcha image hit we remove data older than 1 week: you could tweak this setting opening the inc/captcha.php file, searching for the generateCaptchaCode() function and changing the call to the internal garbage collector to read the line below:
Code: Select all
```
        $this->garbageCollector(86400);
```
in order to clear data older than 1 day.

Regards,
Matteo

calande · Post by **calande** » Wed Nov 08, 2006 9:50 pm

Thank you Matteo!

dicks · Post by **dicks** » Thu Nov 09, 2006 10:52 am

Hi,

Setting it in the configuration is one thing, how do I now flush the admin entries (and others)?

Bye

DickS

matteo · Post by **matteo** » Thu Nov 09, 2006 5:03 pm

Hi,

dicks wrote:Setting it in the configuration is one thing

That was the question of the user

dicks wrote:how do I now flush the admin entries (and others)?

Tables:

faqadminlog, you need to drop records manually;
faqsessions, you can drop them on month-basis directly from PMF and the code will drop both records and traking data files;
faqcaptcha, you don't need to drop them: just wait for the next captcha image hit.

Ciao,
Matteo

dicks · Post by **dicks** » Thu Nov 09, 2006 5:09 pm

Hi,

On (1), why not add a button to phpmyfaq to drop the tables

?

Cheers!

DickS

matteo · Post by **matteo** » Fri Nov 10, 2006 4:53 pm

Hi,

dicks wrote:On (1), why not add a button to phpmyfaq to drop the tables ?

the "button" is already in the incoming PMF 2.0.0-beta: 1.6.x is features frozen, only bugs and security fixes will be addressed.

Ciao,
Matteo

dicks · Post by **dicks** » Fri Nov 10, 2006 8:51 pm

8)

Looking forward to 2.0 then. Any idea when it will be out of beta?

matteo · Post by **matteo** » Fri Nov 10, 2006 9:53 pm

Hi,

dicks wrote:Looking forward to 2.0 then. Any idea when it will be out of beta?

Short: When it will be ready

A bit longer: We're trying to release it within the first half of December but nothing has been written to the stone. Please, track our devblog for being updated about progress and issues of 2.0.0-beta

Ciao,
Matteo