Radicore Forum: Bug Reports » Audit trail enquiry problem in 2007-11-01 release

Home » RADICORE development » Bug Reports » Audit trail enquiry problem in 2007-11-01 release

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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"

Report message to a moderator