+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Database error report (/thread-6515.html)
Database error report - timaaarrreee - 04-24-2009 06:05 PM
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
RE: Database error report - ephigenie - 04-24-2009 06:19 PM
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 ?
RE: Database error report - timaaarrreee - 04-24-2009 06:43 PM
(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?
RE: Database error report - ephigenie - 04-24-2009 06:50 PM
hm if you say it like that its a bug.
pls open a ticket for that.
RE: Database error report - timaaarrreee - 04-24-2009 06:56 PM
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
