Database error report

[timaaarrreee]

Hi all,

How do i stop the system's midnight check from picking up this error? It is sending this in my email for eache and every database at midnight.
Im running:

• Debian 5
• ispCP 1.0
  

I am using a different sql server form the ispcp system.

Code:

Hey There,

I'm the automatic email sent by on your panel.khost.co.nz (10.1.1.6) server.

A critical error just was encountered while executing function mysqldb_quota_by_mysql_engine() in /var/www/ispcp/engine/quota/ispcp-dsk-quota

Error encountered was:

========================================================================
Database '17_mainsite3422db' exists only in table 'sql_database'!!!
========================================================================

Cheers

[ephigenie]

remove the entry for this database in the sql_database table of ispcp.

There seems to be a record of a user-db left which was (administratively) removed ?

[timaaarrreee]

(04-24-2009 06:19 PM)ephigenie Wrote:  There seems to be a record of a user-db left which was (administratively) removed ?

Thanks for quick reply!

When a DB is created in ispcp it is added in my remote db server but an entry is made on the ispcp database table "sql_database" and it reports an error at midnight for each database.
At the moment have 23 databases which means i am getting 23 emails each night. Because it is checking for the database's existance on localhost not my sqlserver

How can this be fixed?

[ephigenie]

hm if you say it like that its a bug.
pls open a ticket for that.

[timaaarrreee]

Ok i will do that. But in the meantime is there a way to stop the constant stream of error logs getting sent to be caused by it ( i have tried to disable log reporting in "Log Level" Section in IspCP -> Admin -> Settings

The errors just keep flowing in