Maintenance Script Help

[itceyorks]

I need help!!! my Database is currently 955mb, and I seem to run the script.
http://ceyorks.org/xibo/maintenance.php?key=(*&^%$£%^&
and it come up

Email Alerts
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Tidy Logs
Done.
Tidy Stats
Done.
Wake On LAN
Done.

But doesn’t have seem to shrunk the DB. Please Help

[cslaughter]

Try going to Media and Tidy Library

[itceyorks]

Nope hasn’t effected it!!

[cslaughter]

Ok, try truncating the log, but it does sound like the maintenance script is not running correctly.

What OS is the CMS running on? Which version of the CMS?

[itceyorks]

Also tried that, log seems to appear again

[itceyorks]

On a Linux webserver, and the lastest 1.7.5

[cslaughter]

@itceyorks

Also tried that, log seems to appear again

Permissions issue?? Are the running the maintenance script from the browser or using cron?

[itceyorks]

Running from my brower

[cslaughter]

You might try running it from the command line and scheduling it in cron.

Maintenance script not run from command line

Dear all, I’m quite new to Xibo (we are running it from some months now) and only today I discovered the maintenance script! So I tried to setup the script as per instructions, but when calling it from command line (Debian 7 server) with /usr/bin/php /var/www/xibo/maintenance.php secret it seems not doing anything. I try to explain better: I have run the command in that way for the first time ever in my installation, and it did exit immediately. I thought it was strange, as surely it should…

[itceyorks]

Thank you, will look into Cron. It has reduced to 155mb now, what is the standard sort of size,

[cslaughter]

@itceyorks

It has reduced to 155mb now,

Nice.

There is not really a standard size. The size of the database will vary with number of displays, number of layouts, datasets, data collection intervals, frequency of the maintenance script being ran and more. But the biggest factors are your log collection settings and how often the maintenance script is ran.