Audit trail enquiry problem in 2007-11-01 release [message #1166] |
Tue, 13 November 2007 15:01 |
alrobertson
Messages: 9 Registered: October 2007 Location: Vancouver
|
Junior Member |
|
|
Somewhere between release 2007-09-01 and 2007-11-01 the audit trail list (audit_dtl_list3.php) stopped working.
In audit_tbl_s01.class.inc - _cm_pre_getData()
the where clause gets addslashes twice which puts 6 backslashes infront of the single quotes.
('pkey LIKE '%keyfield=\\\\\\'value\\\\\\'%')
Then in dml.mysqli.class.inc - adjustWhere()
since the clause has ^LIKE it gets 4 more backslashes
('audit_tbl.pkey LIKE '%keyfield=\\\\\\\\\\'value\\\\\\\\\\'%')
The result is the error
"Nothing retrieved from database table AUDIT_TBL"
|
|
|