Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Bug Reports » Audit trail enquiry problem in 2007-11-01 release
Audit trail enquiry problem in 2007-11-01 release [message #1166] Tue, 13 November 2007 15:01 Go to next message
alrobertson is currently offline  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"
Re: Audit trail enquiry problem in 2007-11-01 release [message #1167 is a reply to message #1166] Tue, 13 November 2007 19:51 Go to previous message
AJM is currently offline  AJM
Messages: 2350
Registered: April 2006
Location: Surrey, UK
Senior Member
Try the attached fixes.

Previous Topic: calling ADD2 from LIST1 with $where set.
Next Topic: Multi-line text box not working on inner table of MULTI2
Goto Forum:

Current Time: Mon Jun 24 10:30:27 EDT 2024

Total time taken to generate the page: 0.01059 seconds