Does SQL_Trail accurately show errors?

There are two possibilities.

    1. The Database user many not have Insert.Update Permissions to perform operations.
    2. The Given database corrupted the columns. or it might be corrupted database like missing some tables.

Check these facts and if you still face the same issue comment it back.

OOPS ! ! !   I forgot the csv attachment....but I don't know how to attach a file.  So I'll paste a few lines in.

274    SELECT * FROM 0_users WHERE user_id = 'jimmyc' AND password='xxxxxxxxxxxxxxxxxxxxxx'    
            1    could not get validate user login for jimmyc
275    SELECT * FROM 0_users WHERE user_id='jimmyc'    1    could not get user jimmyc
276    SELECT * FROM 0_security_roles WHERE id=2    1    could not retrieve security roles
277    "UPDATE 0_users SET last_visit_date='2018-08-12 08:57:02'
        WHERE user_id='jimmyc'"    1    could not update last visit date for user jimmyc
278    SET sql_mode = ''    1

Brand new install. 
Used the new USA 4-digit COA - ONLY!
Used the default "admin" account with a new password.
Setup => Access setup => System Administrator and enabled everything,
Brand new Bank account created (1066).

Still produced "some" of the same errors and I pasted them below.

Dumping data for table 0_sql_trail
1    SET sql_mode = ''    1   
2    UPDATE 0_users SET last_visit_date='2018-08-12 17:16:24' WHERE user_id='admin'    1    could not update last visit date for user admin
3    SET sql_mode = ''    1   
4    SET sql_mode = ''    1   
5    UPDATE 0_users SET last_visit_date='2018-08-12 17:17:08' WHERE user_id='admin'    1    could not update last visit date for user admin
6    SET sql_mode = ''    1   
7    SET sql_mode = ''    1   
8    SET sql_mode = ''    1   
9    SET sql_mode = ''    1   
10    SET sql_mode = ''    1   
11    SET sql_mode = ''    1   
12    INSERT INTO 0_chart_master (account_code, account_code2, account_name, account_type) VALUES ('1066', '', 'Undeposited Donations', '1')    1   
13    SET sql_mode = ''    1   
14    SET sql_mode = ''    1   
15    SET sql_mode = ''    1   
16    INSERT INTO 0_bank_accounts (account_code, account_type, bank_account_name, bank_name, bank_account_number, bank_address, bank_curr_code, dflt_curr_act, bank_charge_act) VALUES ('1066', '3', 'Undeposited Donations', 'Treasurer', '','', 'USD', '0', '5690')    1    could not add a bank account for 1066
17    SET sql_mode = ''    1   

I still can't figure out why.

Replace each instance of

'

with an apostrophe (single quote) and then execute the SQLs in order in some MySQL client like phpMyAdmin, SQLyog, etc.

Chances are that the db user you created does not have sufficient write permissions.

@apmuthu; I just realized one point that I haven't made is that even though sql_trail shows the errors I have listed, all but one or two out of the hundreds listed did complete correctly to the database.  For instance, for the following error:

INSERT INTO 0_bank_accounts (account_code, account_type, bank_account_name, bank_name, bank_account_number, bank_address, bank_curr_code, dflt_curr_act, bank_charge_act) VALUES ('1066', '3', 'Undeposited Donations', 'Treasurer', '','', 'USD', '0', '5690')    1    could not add a bank account for 1066
17    SET sql_mode = ''

The database still made the Bank account of 1066 with all of the field values listed.  I apologize for not pointing this out earlier because this may turn out to be a hand-shaking timing error.   I am also saying that all of the above errors that I listed in the previous posts except for "Concurrent editing conflict while sales order upda..." completed correctly without throwing an exception to the users form.  The errors only showed up in the sql_trail table in the database.

If this post raises any more unanswered questions, please ask and I will respond.

@kvvaradha, On the same server that hosts FA, I also run two other packages (HumHub which is written in YII and Mantis) for the last 21 months.  MySQL has not ever given either of those two packages any problems.  FA is the first application that we have experienced any time of DB read access or write problems.

I am still at a loss of why because I just do not know PHP hardly at all and it has been ten years since I worked with HTML web pages.  So I am of no help trying to figure out where in the FA code are the routines that actually control selecting and putting data. 

I will welcome your thoughts and any direction that you could offer me to try to figure out what is going on.

I forgot to say, the current DB collation is utf8_unicode_ci

@apmuthu; I have PM'd kvvaradha with credentials he requested along with 1N1.COM's suggested PHP script to connect to the MySQL DB for the FA link.

Let me know if you need any links/credentials to help.

@kvvaradha - Thank you for a quick reply again.   To paraphrase how I understand what you are saying is that  sometimes there are "warnings" triggered quick and presented in the sql_trail but after a very short time through the process of the DB firewall, the operation does complete despite the warning.

I did get in the habit of checking through FA user queries like "Sales order inquiry" and "GL inquiry" to verify the page operations (Direct Invoice, Bank Payment, etc.) completed properly.  So far, since the start of this total posting, all DB operations have completed properly when I checked inside the actual MySql DB even though the SQL_Trail reports problems.

Unless I can find an actual time DB operations do not complete (which has only occurred once in the hundreds of operations I've inspected), I will consider this post resolved.

Thank you again for your help (and apmuthu) and I will delete the connections I sent you in a couple of weeks if nothing else has happened.