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
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.