FrontAccounting forum — enabling $sql_trail not giving correct results

Re: enabling $sql_trail not giving correct results

2014-08-02T18:31:50Z

Thanks a lot. Yes the result field is 1.

May be you can help me with my objective or guide me to the right track:

I want to view exactly what happens when I execute ANY given transaction (as learning for now, and later on for trouble-shooting), how to do that?

Thanks in advance.

Re: enabling $sql_trail not giving correct results

2014-08-01T07:55:08Z

The sql trail feature may seems a little not intuitive. You should look first into result field, which stores the query result (1 on success, 0 otherwise). The message stored is just additional comment which should be considered mainly in case of query error, but is also handy when looking for exact place where the error was triggered, so is sotred also on success.
janusz

Re: enabling $sql_trail not giving correct results

2014-07-31T07:42:58Z

Missed my call-to-action in above .
I am a newbie still exploring the system. Am I missing something /doing something wrong? Has someone else experienced similar? Any fixes / workarounds (apart from db dumps before and after transaction and Diff of the two)? Please Help!

enabling $sql_trail not giving correct results

2014-07-30T06:31:38Z

I enabled $sql_trail in config.php file (following advice on forum) to enable me to see what was getting posted and where. From phpmyadmin when I looked at the table sql_trail - msg, it says: "could not insert quick entry for Bank Deposit 3" whereas the correct value is actually posted in the quick_entries table. Similarly it gives the same "could not insert ... "could not update ..." etc for all transactions that I tried.