[eluser]Unknown[/eluser]
It's hard to identify the error if the error number is not set properly and almost all points to the DB_driver.php on line 330 that contains ');' only. Can someone please help me on this?
Code:
if (FALSE === ($this->result_id = $this->simple_query($sql)))
{
if ($this->save_queries == TRUE)
{
$this->query_times[] = 0;
}
// This will trigger a rollback if transactions are being used
$this->_trans_status = FALSE;
if ($this->db_debug)
{
// grab the error number and message now, as we might run some
// additional queries before displaying the error
$error_no = $this->_error_number();
$error_msg = $this->_error_message();
// We call this function in order to roll-back queries
// if transactions are enabled. If we don't call this here
// the error message will trigger an exit, causing the
// transactions to remain in limbo.
$this->trans_complete();
// Log and display errors
log_message('error', 'Query error: '.$error_msg);
return $this->display_error(
array(
'Error Number: '.$error_no,
$error_msg,
$sql
)
); //this is line 330
}
return FALSE;
}
Here's an example of the error I get:
Code:
A Database Error Occurred
Error Number:
Error Message:
SQL Message: SELECT REFNO, NAME, TO_DATE(SOD, '%M %d, %Y') SOD, TO_DATE(EOD, '%M %d, %Y') EOD, STATUS FROM PPLUS_PROJECTS WHERE STATUS != 8 AND (OWNER = 'ndsadona' OR CREATED_BY = 'ndsadona') UNION SELECT REFNO, NAME, TO_DATE(a.SOD, '%M %d, %Y') SOD, TO_DATE(a.EOD, '%M %d, %Y') EOD, a.STATUS FROM PPLUS_PROJECTS a, PPLUS_MODULES b WHERE a.REFNO = b.PROJECT_REFNO AND ASSIGNED_TO = 'ndsadona' AND a.STATUS != 8 ORDER BY NAME
Filename: C:\wamp\www\projectplus\system\database\DB_driver.php
Line Number: 330
Thanks in advance!
Here's a similar problem I posted almost 2 weeks ago:
Click me:
'Twas resolved but this time, it wasn't. I can't understand why :|