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 previous 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"
 
Read Message
Read Message
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: Fri Nov 29 03:50:26 EST 2024

Total time taken to generate the page: 0.00871 seconds