backupmng database issue

[bananapar]

I've only recently been administrating this server, which is running plesk 9.2.3 and have just noticed that backupmng isn't working and hasn't been for some time.
When trying to schedule from the control panel backupmng produces the error:

Error: Unable to update scheduled backup information: MySQL query failed: Unknown column 'backup_time' in 'field list'

If I attempt to run from bash I also get

backupmng: Unable to fetch backup tasks from database: Unknown column 'backup_time' in 'where clause'

Unfortunately this doesn't tell me much about where in the (mysql) psa database it's looking or why and I haven't managed to find any information to help with this.

Does anyone have any suggestions/has anyone else had this problem?

Also it appears cron was set to run this 4 times a minute - that seems more than a little extreme - is it perfectly reasonable for me to change it to run daily at 2am or something instead? This way we still have fairly regular backups and it won't affect server load and important times.

[bananapar]

It appears backup_time is supposed to be in the "BackupsScheduled" table
As this table was empty I altered the table to include the column, it then said the column backup_day was missing.
After adding this I now get

Error: Unable to update scheduled backup information: MySQL query failed: Column 'last' cannot be null

I am reluctant to continue on this path for now and reverted te table to its previous state.

[scott]

Was this system upgraded to 9.2? This might be a failed upgrade

[bananapar]

Yes the system was upgraded from a previous version, in January I believe.

Out of curiosity I re-added the backup time and day columns and then set last to allow NULL values.
Plesk did then added everything apart from in the 'last' column. I then put a fake value from earlier in the month into 'last' and set it to NOT NULL again - I won't know if this has done anything until later on though.

(If I try to reschedule though [through plesk CP] it does do it properly this time.)

[bananapar]

The backup went as planned last night. Hopefully there won't be any more problems with it.

However the email I recieve to confirm it's taken place says "Status warnings"
Attached to the email is a file which contains

<?xml version="1.0" encoding="UTF-8"?>
<execution-result status="warnings">
<object name="domain-name" type="domain">
<message severity="warning" code="msgtext">Error during getting information about spam filter for email-address</message>
</object>
<object name="domain-name2" type="domain">
<message severity="warning" code="msgtext">Error during getting information about spam filter for email-address2</message>
</object>
</execution-result>

except that the list of email addresses is slightly longer.

None of these email addresses are present in the psa.spamfilter table, which I think is why these warnings are appearing.

All of these are email accounts that we set up fairly recently (within the last month or two) Should I worry that these aren't protected properly by spamassassin etc.? or is it nothing to worry about.

[scott]

You can verify that by look at each email accounts .qmail file, it should reference spamassassin in there pretty clearly

[bananapar]

Thanks a lot Scott, they do still show positive for spam checking.

I am slightly curious as to why new mail accounts are no longer being put in the spamfilter table but at least it isn't a huge issue.