Zend Server Best Practices > Development > Monitoring Rules > Database Error

Database Error

Description: When a specific watched database function returns FALSE, it generates an event. The “Database Error” Rule contains a list of monitored functions (i.e. functions that when returning FALSE will trigger an event).

Information Collected:

The most important details are:

Function Data - Listed in the Function Data tab.
Function Name - As displayed in the Issue’s General Details
The error type will show if it is an SQL query error, shell code error, Java code error

Applicable Diagnostic Actions:

Click on a link to see how to perform each action tools are listed in order of relevance to helping solve the event:

Open code in editor
Run the Debugger
View information in the Logs

Possible Causes and Solutions:

Possible causes:

Check that the connection to the DB is working. Possible Solution: verify the connection data is correct (address, user name, passwords etc.) and manually re-establish the connection.
External code problems such as malformed non-PHP code (code that can trigger a PHP error). Solution: Fix SQL code.
Function errors should to help understand the problem according to the content of the error.
Use the debugger to find the code/query that failed.
Incorrect database queries can trigger the event. Solution: redefine database queries and verify that the correct query syntax is used.


	Related Links: Advanced Diagnostics with Zend Server